Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Performance Help - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Index Performance Help
Date
Msg-id 200402051028.35116.josh@agliodbs.com
Whole thread Raw
In response to Re: Index Performance Help  ("Damien Dougan" <damien.dougan@mobilecohesion.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Orion Henry
Date:
Subject: Re: 7.3 vs 7.4 performance
Next
From: Mark Harrison
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?