* david drummard (vijayspam@xxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
