Re: Index Performance Help

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Damien Dougan" <damien(dot)dougan(at)mobilecohesion(dot)com>, "'Richard Huxton'" <dev(at)archonet(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index Performance Help
Date: 2004-02-05 18:28:35
Message-ID: 200402051028.35116.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Damian,

Also, if there have been a lot of updates to the table, you may need to run a
REINDEX on it. An attenuated index would be slow to load because of the
nummber of empty disk blocks.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Harrison 2004-02-05 23:09:36 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Previous Message Orion Henry 2004-02-05 18:04:44 Re: 7.3 vs 7.4 performance