Re: Slow SQL lookup due to every field being listed in SORT KEY

* Mason Harding (mason.harding@gmail.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.

    Thanks,

        Stephen