Skip site navigation (1) Skip section navigation (2)

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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Joseph S <jks(at)selectacast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: big select is resulting in a large amount of disk writing by kjournald
Date: 2009-12-09 19:53:56
Message-ID: 4B200054.3020209@2ndquadrant.com (view raw or flat)
Thread:
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(at)2ndQuadrant(dot)com  www.2ndQuadrant.com


In response to

Responses

pgsql-performance by date

Next:From: Joseph SDate: 2009-12-09 20:50:57
Subject: Re: big select is resulting in a large amount of disk writing by kjournald
Previous:From: Kenneth MarshallDate: 2009-12-09 19:45:57
Subject: Re: big select is resulting in a large amount of diskwriting by kjournald

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group