Horton

Re: big select is resulting in a large amount of disk writing by kjournald

Greg Smith <greg@2ndquadrant.com>

View thread
From: Greg Smith <greg@2ndquadrant.com>
To: Joseph S <jks@selectacast.net>
Cc: pgsql-performance@postgresql.org
Date: 2009-12-09T19:53:56Z
Lists: pgsql-performance 
Joseph S wrote:
> So I run "select count(*) from large_table" and I see in xosview a 
> solid block of write activity. Runtime is 28125.644 ms for the first 
> run.  The second run does not show a block of write activity and takes 
> 3327.441 ms
http://wiki.postgresql.org/wiki/Hint_Bits

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com