From: Adrian Moisey <adrian@careerjunction.co.za>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: strange pauses
Date: Mon, 21 Jan 2008 09:58:30 +0200
Message-ID: <479450A6.1070004@careerjunction.co.za> (raw)
In-Reply-To: <20080118124121.GA5326@alvh.no-ip.org>
References: <478DDF83.8070106@careerjunction.co.za>
<478DE16F.50308@archonet.com>
<4790863E.4000309@careerjunction.co.za>
<47909577.4070704@careerjunction.co.za>
<20080118124121.GA5326@alvh.no-ip.org>
Hi
> Perhaps, if you want to avoid I/O caused by temp tables (but it's not at
> checkpoint time, so perhaps this has nothing to do with your problem),
> you could try raising temp_buffers.
How can I find out if temp_buffers is being exceeded ?
--
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
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: adrian@careerjunction.co.za, alvherre@commandprompt.com
Subject: Re: strange pauses
In-Reply-To: <479450A6.1070004@careerjunction.co.za>
* 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