Large temporary file generated during query

From: Ryan Kelly <rpkelly22(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Large temporary file generated during query
Date: 2012-12-07 21:58:04
Message-ID: 20121207215804.GA23450@llserver.lakeliving.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a very large query that also touches quite a bit of data. It
generates a large temporary file (actually, several, because the total
size is about 4.5GB). I'm wondering which part of the query's plan
causes these files to be created. The query has the following sequence
of plan nodes when run through EXPLAIN:

HashAggregate -> Result -> Append -> [Seq Scan | Bitmap Heap Scan, ...]

Where there are many "Seq Scan" or "Bitmap Heap Scan" nodes being
generated, one for each partition of the partitioned table.

So, why are these files being created?

Also, I suppose this data on-disk can be kept in memory instead by increasing
work_mem to a suitable value?

Thanks,
-Ryan Kelly

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2012-12-07 22:35:18 Re: How to mix psql commands and SQL commands on the shell command line?
Previous Message Andres Freund 2012-12-07 21:48:14 Re: unlooged tables