Postgres Pro
Downloads
Home   >   mailing lists

Re: big select is resulting in a large amount of disk writing by kjournald - Mailing list pgsql-performance

From Greg Smith
Subject Re: big select is resulting in a large amount of disk writing by kjournald
Date
Msg-id 4B200054.3020209@2ndquadrant.com
Whole thread Raw
In response to big select is resulting in a large amount of disk writing by kjournald  (Joseph S <jks@selectacast.net>)
Responses Re: big select is resulting in a large amount of disk writing by kjournald
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: big select is resulting in a large amount of disk writing by kjournald
Next
From: Joseph S
Date:
Subject: Re: big select is resulting in a large amount of disk writing by kjournald