On Fri, Dec 12/07/12, 2012 at 05:33:45PM -0800, Jeff Janes wrote: > On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly <rpkelly22@xxxxxxxxx> wrote: > > 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. > > Doing an "explain (analyze, buffers)" should tell you that. Was hoping to avoid that because the query had not finished running after 48 hours. I'll see if it finishes in a reasonable amount time with extra work_mem. > > Cheers, > > Jeff -Ryan Kelly -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
