From: Stephen Frost <sfrost@snowman.net>
To: Mason Harding <mason.harding@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow SQL lookup due to every field being listed in SORT KEY
Date: Fri, 10 Sep 2010 21:59:03 -0400
Message-ID: <20100911015903.GG26232@tamriel.snowman.net> (raw)
In-Reply-To: <AANLkTinQu1vhokjuAZDd3d2b6oeSqERF4biNGP-k-6UV@mail.gmail.com>
References: <AANLkTinQu1vhokjuAZDd3d2b6oeSqERF4biNGP-k-6UV@mail.gmail.com>
* 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
Attachments:
signature.asc (application/pgp-signature, 196B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, mason.harding@gmail.com
Subject: Re: Slow SQL lookup due to every field being listed in SORT KEY
In-Reply-To: <20100911015903.GG26232@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox