Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date
Msg-id cone.1288198967.167575.5695.1000@shelca
Whole thread Raw
In response to Regression: 8.3 2 seconds -> 8.4 100+ seconds  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
Tom Lane writes:

> Please provide a self-contained test case for this.  In testing here,
> 8.4 can still figure out that it ought to use an indexscan against the
> large table ... so there is some aspect of your tables that you're not
> showing us.

It is possible, and very likely, that it is an issue with the distribution
of values.

The data is 40GB+ and the largest table is 200M+ rows..
Setting a standalone setup may be difficult, but what we could do is
something like webex where you, or someone else we would trust, would
connect to a web conference and tell us what to type.


pgsql-performance by date:

Previous
From: Divakar Singh
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Next
From: André Volpato
Date:
Subject: Re: AIX slow buffer reads