Re: Insert only tables and vacuum performance
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Shraibman <jks@selectacast.net>
Cc: pgsql-performance@postgresql.org
Date: 2004-05-01T03:04:36Z
Lists: pgsql-performance
Joseph Shraibman <jks@selectacast.net> writes: > INFO: "elog": found 0 removable, 12869411 nonremovable row versions in > 196195 pages > DETAIL: 0 dead row versions cannot be removed yet. > There were 5 unused item pointers. > 0 pages are entirely empty. > CPU 31.61s/4.53u sec elapsed 1096.83 sec. Hmm. These numbers suggest that your disk subsystem's bandwidth is only about 1.4 Mbytes/sec. Was there a lot else going on? regards, tom lane