Re: performance question related to pgsql

* david drummard (vijayspam(at)gmail(dot)com) wrote:
> thanks very much for the response. Are there any special commands to analyze
> the index before using the table. If i rename the table, will the indexes
> still stay with the table ( i hope so).

You want to run 'analyze <tablename>' after you've created the index.
Renaming the table will retain the indexes (and should retain everything
else, analyze statistics, etc). The only issue you might need to be
careful about is that renaming the table might not rename the indexes,
in which case you might get errors when you try to create the new
indexes about an index with that name already existing.

Just be sure to test your scripts out w/ empty tables to make sure
everything in the rotation works correctly so that when you add the data
it all works correctly.

By the way, there's a Postgres mailing list dedicated to Performance
issues. These questions would probably be more appropriate there.

Enjoy,

Stephen