Dinesh Bhandary <dbhandary@xxxxxxx> 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/SlowQueryQuestions > 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. They get rebuilt as empty indexes. > It does not seem like they > are removed, but merely marked for deletion by a vacuum job and it > creates huge bloats and performance problems. On what do you base this clearly-contrary-to-reality conclusion? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
