Re: [GENERAL] Large temporary file generated during query

2012-12-08 Thread Ryan Kelly
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 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 won

Re: [GENERAL] Large temporary file generated during query

2012-12-07 Thread Jeff Janes
On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly 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.