From: Harry Broomhall <harry.broomhall@uk.easynet.net>
To: shridhar_daithankar@myrealbox.com
Cc: harry.broomhall@uk.easynet.net
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance weirdness with/without vacuum analyze
Date: Tue, 21 Oct 2003 13:35:50 +0100 (BST)
Message-ID: <200310211235.NAA15239@haeb.noc.uk.easynet.net> (raw)
In-Reply-To: <3F951FC8.2090906@myrealbox.com>
Shridhar Daithankar writes:
> Harry Broomhall wrote:
> > #effective_cache_size = 1000 # typically 8KB each
> > #random_page_cost = 4 # units are one sequential page fetch cost
>
> You must tune the first one at least. Try
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html to tune these
> parameters.
Wow. Many thanks for the pointer. I'm going to be spending some time
trying to get my head around all of that!
[SNIP]
> > Total runtime: 80408.42 msec
> > (12 rows)
>
> You are lucky to get a better plan here because planner is way off w.r.t
> estimated number of rows.
Yes! I thought that. Which was why I was so surprised at the difference.
> >
> > And now the case *with* the vacuum analyze:
> >
[SNIP]
>
> What happens if you turn off hash joins? Also bump sort memory to something
> good.. around 16MB and see what difference does it make to performance..
Lots of things to try there.....
It will probably take me some time <grin>.
Regards,
Harry.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: harry.broomhall@uk.easynet.net, shridhar_daithankar@myrealbox.com
Subject: Re: Performance weirdness with/without vacuum analyze
In-Reply-To: <200310211235.NAA15239@haeb.noc.uk.easynet.net>
References: <3F951FC8.2090906@myrealbox.com> <200310211235.NAA15239@haeb.noc.uk.easynet.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