Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-04-01 Thread Alvaro Herrera
Faheem Mitha wrote: > Regardless, you don't address why the email I sent disappeared into > the ether. If it was rejected due to excessive length, then it would > be polite to get an automated rejection. Perhaps something like > > "Your message is too long and so is being rejected. Messages to th

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-31 Thread Faheem Mitha
On Wed, 31 Mar 2010, Bruce Momjian wrote: Faheem Mitha wrote: I submitted a modified self-contained email as requested, but it does not appear to have made it to the list, and I never got any kind of reject message. It was around 1000 lines with no attachments. Is there a size limit for pos

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-31 Thread Bruce Momjian
Faheem Mitha wrote: > > > On Sun, 28 Mar 2010, Tom Lane wrote: > > > Faheem Mitha writes: > >> ... In any case, feedback would be helpful. Details of my attempts > >> at optimization are at > >> http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf > > > > By and large, this is not the way to ask

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-29 Thread Faheem Mitha
On Sun, 28 Mar 2010, Tom Lane wrote: Faheem Mitha writes: ... In any case, feedback would be helpful. Details of my attempts at optimization are at http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf By and large, this is not the way to ask for help on the Postgres lists. If you're supplyin

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Faheem Mitha
Hi again Andy, On Sun, 28 Mar 2010 20:59:24 -0500, Andy Colson wrote: > On 03/28/2010 07:43 PM, Andy Colson wrote: >> On 03/28/2010 03:05 PM, Faheem Mitha wrote: >>> >>> >> >> Wait... Your saying your question is so complex it needs 41 pages >> (including graphs) to ask? I didn't bother before, b

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Faheem Mitha
On Sun, 28 Mar 2010, Andy Colson wrote: Wait... Your saying your question is so complex it needs 41 pages (including graphs) to ask? I didn't bother before, but now I'm curious, I'll have to go take a look. No, only the 25 page document (which has the graphs) is directly related to the qu

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Andy Colson
On 03/28/2010 07:43 PM, Andy Colson wrote: On 03/28/2010 03:05 PM, Faheem Mitha wrote: Wait... Your saying your question is so complex it needs 41 pages (including graphs) to ask? I didn't bother before, but now I'm curious, I'll have to go take a look. -Andy Faheem, you seem to be incred

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Andy Colson
On 03/28/2010 03:05 PM, Faheem Mitha wrote: On Sun, 28 Mar 2010, Tom Lane wrote: Faheem Mitha writes: ... In any case, feedback would be helpful. Details of my attempts at optimization are at http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf By and large, this is not the way to ask for h

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Faheem Mitha
On Sun, 28 Mar 2010, Tom Lane wrote: Faheem Mitha writes: ... In any case, feedback would be helpful. Details of my attempts at optimization are at http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf By and large, this is not the way to ask for help on the Postgres lists. If you're supplyin

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-28 Thread Tom Lane
Faheem Mitha writes: > ... In any case, feedback would be helpful. Details of my attempts > at optimization are at > http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf By and large, this is not the way to ask for help on the Postgres lists. If you're supplying extremely large test data or someth

[GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-27 Thread Faheem Mitha
Hi everyone, I've been trying to reduce both memory usage and runtime for a query. An issue I have encountered is that I can drastically reduce both runtime and memory usage by splitting up the query into two pieces and gluing them together outside PostgreSQL. However, I'm unable to get simil