"Mark Dexter" <[EMAIL PROTECTED]> writes: > Several recent postings appear to confirm that there is an issue with > the use of VACUUM or ANALYZE on empty tables. Specifically, if you > VACUUM or ANALYZE a table that is empty and then insert a large number > of rows into this table, you will experience very poor performance.
Well-known issue. See this thread for the latest discussion: http://archives.postgresql.org/pgsql-hackers/2004-11/msg00985.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
