* Mason Harding (mason(dot)harding(at)gmail(dot)com) wrote:
> Hi all. I Have the following query (tested in postgres 8.4 and 9.0rc1)
Can you provide \d output from all the tables involved..?
Also, what does the query plan look like w/o 'enable_seqscan=off' (which
is not a good setting to use...)? Increasing work_mem is often a good
idea if your system can afford it based on the number/kind of queries
running concurrently. Note that you can also increase that setting for
just a single role, single session, or even single query.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2010-09-11 02:00:38|
|Subject: Re: Slow SQL lookup due to every field being listed in SORT KEY |
|Previous:||From: Mason Harding||Date: 2010-09-10 22:35:17|
|Subject: Slow SQL lookup due to every field being listed in SORT KEY|