Re: What is the tuplestore?

On 12/10/2018 06:24 PM, Thomas Munro wrote:
> On Tue, Dec 11, 2018 at 2:56 AM Ron <ronljohnsonjr@gmail.com> wrote:
>> 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.)
> Maybe the setting log_temp_files could help you identify the query
> that is doing it?
>
> https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-TEMP-FILES

Great idea; I've made the change.  What do I grep for in the pg_log file?


-- 
Angular momentum makes the world go 'round.