If I insert a bunch of rows, then truncate, then insert a bunch more rows, do I need to vacuum? I've been assuming that TRUNCATE TABLE is a brute-force technique that more-or-less tosses the old table and starts fresh so that no vacuum is necessary.
Second question: Same scenario as above, but now the table has indexes. Is a reindex needed, or are the indexes they "truncated" too?
In response to
pgsql-performance by date
|Next:||From: Chris||Date: 2006-07-07 01:51:00|
|Subject: Re: Query plan issue when upgrading to postgres 8.14 (from|
|Previous:||From: Mark Kirkwood||Date: 2006-07-06 22:51:54|
|Subject: Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL|