Skip site navigation (1) Skip section navigation (2)

Re: temporary tables, indexes, and query plans

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: temporary tables, indexes, and query plans
Date: 2010-10-27 17:59:40
Message-ID: AANLkTimLX___=XXUMc86tjaxu7ketDpYr2Yd=YJFw0B6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, Oct 27, 2010 at 12:44 PM, Mladen Gogala
<mladen(dot)gogala(at)vmsinfo(dot)com> wrote:
> On 10/27/2010 1:29 PM, Jon Nelson wrote:
> How big is your default statistics target? The default is rather small, it
> doesn't produce very good or usable histograms.

Currently, default_statistics_target is 50.

I note that if I create a indexes earlier in the process (before the
copy) then they are used.
I'm not trying creating them after the first UPDATE (which updates
2.8million of the 10million rows).
The subsequent UPDATE statements update very few (3-4 thousand for 2
of them, less than a few dozen for the others) and the ones that use
the index only update *1* row.

I'll also try setting a higher default_statistics_target and let you know!

-- 
Jon

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2010-10-27 18:03:36
Subject: Re: CPUs for new databases
Previous:From: Scott CareyDate: 2010-10-27 17:48:35
Subject: Re: Postgres insert performance and storage requirement compared to Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group