Re: strange pauses - Mailing list pgsql-performance

From Adrian Moisey
Subject Re: strange pauses
Date
Msg-id 479450A6.1070004@careerjunction.co.za
Whole thread Raw
In response to Re: strange pauses  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: strange pauses  (Decibel! <decibel@decibel.org>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow set-returning functions
Next
From: "Marten Verhoeven"
Date:
Subject: Slow performance with left outer join