Re: Large temporary file generated during query

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@gmail.com> 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