Re: [GENERAL] temp files getting me down

2011-05-25 Thread Ben Chobot
On May 25, 2011, at 7:36 PM, Merlin Moncure wrote: > On Wed, May 25, 2011 at 6:44 PM, Ben Chobot wrote: >> >> >> Well, the query itself was calling a plpgsql function, and the function >> itself was doing: >> >> DECLARE >>row formatted_replication_queue%ROWTYPE; >> BEGIN >>fo

Re: [GENERAL] temp files getting me down

2011-05-25 Thread Merlin Moncure
On Wed, May 25, 2011 at 6:44 PM, Ben Chobot wrote: > On May 25, 2011, at 2:57 PM, Merlin Moncure wrote: > >> On Wed, May 25, 2011 at 2:14 PM, Ben Chobot wrote: >>> On May 25, 2011, at 9:31 AM, Ben Chobot wrote: >>> I'm running 9.0.3, and recently started getting temp files being created. >>

Re: [GENERAL] temp files getting me down

2011-05-25 Thread Ben Chobot
On May 25, 2011, at 2:57 PM, Merlin Moncure wrote: > On Wed, May 25, 2011 at 2:14 PM, Ben Chobot wrote: >> On May 25, 2011, at 9:31 AM, Ben Chobot wrote: >> >>> I'm running 9.0.3, and recently started getting temp files being created. >>> This is a problem because it's making a bunch of dirty b

Re: [GENERAL] temp files getting me down

2011-05-25 Thread Merlin Moncure
On Wed, May 25, 2011 at 2:14 PM, Ben Chobot wrote: > On May 25, 2011, at 9:31 AM, Ben Chobot wrote: > >> I'm running 9.0.3, and recently started getting temp files being created. >> This is a problem because it's making a bunch of dirty buffers that have to >> be flushed to disk and my poor litt

Re: [GENERAL] temp files getting me down

2011-05-25 Thread Ben Chobot
On May 25, 2011, at 9:31 AM, Ben Chobot wrote: > I'm running 9.0.3, and recently started getting temp files being created. > This is a problem because it's making a bunch of dirty buffers that have to > be flushed to disk and my poor little disk isn't up to the task. I'm not sure > why though,