* Mason Harding (mason.harding@xxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
