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

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&#x

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 >> (inc

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 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&#x

[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

Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Faheem Mitha
On Mon, 19 Jan 2009, Jeff Davis wrote: On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote: In any case, I don't have admin permissions on the machine I'm trying to install it to. At absolute minimum, you need PostgreSQL superuser privileges. If you don't, you need

Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Faheem Mitha
Hi Jeff, On Sun, 18 Jan 2009, Jeff Davis wrote: On Sun, 2009-01-18 at 16:52 -0500, Faheem Mitha wrote: Hi Jeff, When I try to run array_agg.sql inside psql I get btsnp_test=# \i '/tmp/array_agg/array_agg.sql' BEGIN psql:/tmp/array_agg/array_agg.sql:5: ERROR: could not access fil

[GENERAL] array_agg for 8.3

2009-01-16 Thread Faheem Mitha
t want to wait. If anyone has working code along these lines, please send it to me. Also, please CC me on any reply. Thanks. Regards, Faheem Mitha. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su