Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3F3682E414F for ; Mon, 21 Jan 2008 03:58:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 07277-03 for ; Mon, 21 Jan 2008 03:58:18 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id C26622E4123 for ; Mon, 21 Jan 2008 03:58:19 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 6757BB7A4E; Mon, 21 Jan 2008 09:58:32 +0200 (SAST) Message-ID: <479450A6.1070004@careerjunction.co.za> Date: Mon, 21 Jan 2008 09:58:30 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Alvaro Herrera CC: pgsql-performance@postgresql.org Subject: Re: strange pauses 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> In-Reply-To: <20080118124121.GA5326@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/157 X-Sequence-Number: 28396 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