Re: What is the tuplestore?

Which file system (specifically, which directory)?  Is it data/base/pgsql_tmp?  There's 96GB free, which is 74% of the volume.

Maybe the temp space got released right after the failure?

https://grokbase.com/t/postgresql/pgsql-general/02ag7k8gcr/tuplestore-write-failed

do you have space usage charts for that partition? doesn't it show a spike during that time?

Am Mo., 10. Dez. 2018 um 15:54 Uhr schrieb Ron <ronljohnsonjr@gmail.com>:

There's certainly a problem with the application, but the error is in the pg_log, not the application log.

On 12/10/2018 03:21 PM, Rene Romero Benavides wrote:

What if this error message pertains to something happening on the application side? 

Am Mo., 10. Dez. 2018 um 09:56 Uhr schrieb Ron <ronljohnsonjr@gmail.com>:

Hi,

v9.6.6


2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS CDSLBXW 13748 SELECT
PostgreSQL JDBC Driver 53100 ERROR:  could not write to tuplestore temporary
file: No space left on device

I see this in the pg_log file, but #1 can't figure out what "tuplestore" is
(Google doesn't help), and #2 there's lots of space on all my file systems. 
data/base, where pgsql_tmp lives, has 96GB free.)

Thanks