Re: [ADMIN] impact of truncate table on indexes

2011-12-22 Thread Tom Lane
Dinesh Bhandary writes: > We have been having some performance issues with indexes right after > truncating a table. You'd need to be a lot more specific than that if you want useful help. Also, pgsql-performance is a better list for discussing performance issues. http://wiki.postgresql.org/wiki

[ADMIN] impact of truncate table on indexes

2011-12-22 Thread Dinesh Bhandary
Hi All - We have been having some performance issues with indexes right after truncating a table. My understanding is truncate removes all the contents of the table and the space get reclaimed immediately. In such cases what happens to its indexes. It does not seem like they are removed, but m