Re: Insert only tables and vacuum performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Insert only tables and vacuum performance
Date: 2004-05-01 03:04:36
Message-ID: 9781.1083380676@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joseph Shraibman <jks(at)selectacast(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Creager 2004-05-01 04:03:06 Re: Wierd context-switching issue on Xeon
Previous Message Tom Lane 2004-05-01 01:19:39 Re: planner/optimizer question