"Stuart Brooks" <stuartb@xxxxxxxxx> writes: > It'll take a few minutes but I'll try and get the information to you. A summary > is: > > Process 1: > - writing 50 rows/second, 1 row/transaction. > - every so often delete 100 rows > > Process 2: > - running ANALYZE VERBOSE and pg_total_relation_size every second You'll probably have to vacuum pg_statistics as well then. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
