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

Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-10-27 13:16:54
Message-ID: AANLkTimzhZr2ZjAQFRP100nrEM=1xqHN=xOa13OYC25=@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello

>
> The 8.4 machines have more memory than the 8.3.7 and are in general much
> better machines.
> 8.4 settings
> Shared_buffers 18GB
> effective_cache_size 18GB
>
> Machines have 72GB of RAM
> Tried turning off sequential scan on the 8.4.5 and that did not help.
>
> Any ideas/suggestions?
>

increase statistics on columns. The estimation is totally out.

Regards

Pavel Stehule

> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

pgsql-performance by date

Next:From: Divakar SinghDate: 2010-10-27 14:00:15
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Previous:From: Brad NicholsonDate: 2010-10-27 12:42:33
Subject: Re: AIX slow buffer reads

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