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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
