| From: | Ryan Kelly <rpkelly22(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Large temporary file generated during query |
| Date: | 2012-12-08 19:50:47 |
| Message-ID: | 20121208195047.GA24467@llserver.lakeliving.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2012-12-09 10:36:11 | ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
| Previous Message | Condor | 2012-12-08 13:54:17 | Query and index ... unexpected result need advice. |