pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Jon Nelson <jnelson+pgsql@jamponi.net>
Cc: mladen.gogala@vmsinfo.com, "david@lang.hm" <david@lang.hm>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: Vitalii Tymchyshyn <tivv00@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Slow count(*) again...
Date: Tue, 12 Oct 2010 09:18:34 -0400
Message-ID: <4CB4602A.3040800@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTina3zfQ01UwPqps_hogvR-ge=ur9zHCSsxvKAm8@mail.gmail.com>
References: <201010091626.18636.neil.whelchel@gmail.com>
	<AANLkTimayTM__hHu9RoiLaNhzfpNY6Vo5y4OkbX_sV=o@mail.gmail.com>
	<4CB34D69.6060108@emolecules.com>
	<4CB4149D.8030803@gmail.com>
	<4CB41902.1020503@postnewspapers.com.au>
	<alpine.DEB.2.00.1010120118030.21889@asgard.lang.hm>
	<4CB4542E.5010406@vmsinfo.com>
	<AANLkTina3zfQ01UwPqps_hogvR-ge=ur9zHCSsxvKAm8@mail.gmail.com>

Jon Nelson wrote:
> Is there a command to tell postgresql to drop/clear/reset it's buffer_cache?
>   

No.  Usually the sequence used to remove all cached data from RAM before 
a benchmark is:

pg_ctl stop
sync
echo 3 > /proc/sys/vm/drop_caches
pg_ctl start

-- 
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support  www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance"    Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book




view thread (246+ messages)  latest in thread

Message-ID: <4CB4602A.3040800@2ndquadrant.com>
Permalink:  ../4CB4602A.3040800@2ndquadrant.com/
Also on:    postgresql.org/message-id/4CB4602A.3040800@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, jnelson+pgsql@jamponi.net, david@lang.hm, craig@postnewspapers.com.au, tivv00@gmail.com
  Subject: Re: Slow count(*) again...
  In-Reply-To: <4CB4602A.3040800@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox