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.

On 12/10/2018 04:50 PM, Rene Romero Benavides wrote:
> 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(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)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(at)gmail(dot)com <mailto:ronljohnsonjr(at)gmail(dot)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
>>
>

--
Angular momentum makes the world go 'round.