Re: Does indexing help >= as well as = for integer columns?

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does indexing help >= as well as = for integer columns?
Date: 2005-02-23 07:18:02
Message-ID: aiao111hhqhj619bk4ifh99v6dee4e1pks@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02 Feb 2005 00:58:17 -0500, Greg Stark <gsstark(at)mit(dot)edu> wrote:
>I don't recall what the original motivation to rewrite the analyze sampling
>was, did having lots of dead tuples cause bad estimates in 7.4?

The original intention was to make analysing huge tables faster. But
the patch turned out to be _slower_ for mid sized tables. So it was
sold to the community as a way to produce better statistics for
relations with many dead tuples near the start.

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2005-02-23 08:01:01 Re: tsearch2 problems / limitations
Previous Message anupam.chaudhury 2005-02-23 05:16:51 Porting Postgres on VXworks+SH4