Re: best way to test new index?

On 4/21/11 1:28 PM, Kevin Grittner wrote:
> That said, I would start by making sure that basic things like
> CREATE INDEX and DROP INDEX work.  Then I would test that INSERT,
> UPDATE, and DELETE do the right things with the index.  Then I would
> make sure that vacuum did the right thing.  Then I would make sure
> that the optimizer was doing a reasonable job of knowing when it was
> usable and what it cost, so that it would be chosen when
> appropriate.  Once everything seemed to be behaving I would
> benchmark it against the reasonable alternatives.

... And then finally, kill -9 the database server while updating the
index to test crash-safeness.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com