From: Jean-Max Reymond <jmreymond@gmail.com>
To: Gary Doades <gpd@gpdnet.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimizing a request
Date: Tue, 31 Aug 2004 22:24:51 +0200
Message-ID: <4b09a0c04083113243b6198b8@mail.gmail.com> (raw)
In-Reply-To: <4134EABE.28891.4E1B76A@localhost>
References: <4134DDDD.428.4AF67CC@localhost>
<4134EABE.28891.4E1B76A@localhost>
On Tue, 31 Aug 2004 21:16:46 +0100, Gary Doades <gpd@gpdnet.co.uk> wrote:
> I can only presume you mean 1 GB RAM. What exactly are your
> settings for shared buffers and effective_cache_size?
for 1 GB RAM,
shared_buffers = 65536
effective_cache_size = 16384
>
> Can you increase default_statistics_target and re-test? It is possible
> that with such a large table that the distribution of values is skewed and
> postgres does not realise that an index scan would be better.
OK, tomorrow, I'll try with the new value of default_statistics_target
> It seems very odd otherwise that only on row out of 10,000,000 could
> match and postgres does not realise this.
>
> Can you post an explain analyse (not just explain) for this query?
yes, of course
--
Jean-Max Reymond
CKR Solutions
http://www.ckr-solutions.com
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: jmreymond@gmail.com, gpd@gpdnet.co.uk
Subject: Re: Optimizing a request
In-Reply-To: <4b09a0c04083113243b6198b8@mail.gmail.com>
* 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