[PERFORM] Pointers needed on optimizing slow SQL statements

2009-06-03 Thread Janine Sisk
) Index Cond: (item_id = $0) Total runtime: 195949.928 ms (33 rows) --- Janine Sisk President/CEO of furfly, LLC 503-693-6407 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [PERFORM] Pointers needed on optimizing slow SQL statements

2009-06-03 Thread Janine Sisk
. Thanks! janine On Jun 3, 2009, at 2:42 PM, Tom Lane wrote: Janine Sisk jan...@furfly.net writes: I've been Googling for SQL tuning help for Postgres but the pickings have been rather slim. Maybe I'm using the wrong search terms. I'm trying to improve the performance of the following query

Re: [PERFORM] Pointers needed on optimizing slow SQL statements

2009-06-03 Thread Janine Sisk
? This is an overloaded system to start with, so I'm being fairly conservative with what I change. thanks, janine On Jun 3, 2009, at 2:42 PM, Tom Lane wrote: Janine Sisk jan...@furfly.net writes: I've been Googling for SQL tuning help for Postgres but the pickings have been rather slim