Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the tuplestore? - Mailing list pgsql-general

From Rene Romero Benavides
Subject Re: What is the tuplestore?
Date
Msg-id CANaGW08NTVcykCJS3Bd2m_8cuEWSM0nVXy1WXS+2k08GydNWAA@mail.gmail.com
Whole thread Raw
In response to Re: What is the tuplestore?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: What is the tuplestore?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
Maybe the temp space got released right after the failure?
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


--
Angular momentum makes the world go 'round.


--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory exhaustion due to temporary tables?
Next
From: Ron
Date:
Subject: Re: What is the tuplestore?