>>> On Tue, Jan 15, 2008 at 11:05 AM, in message
<[EMAIL PROTECTED]>, Doug Knight
<[EMAIL PROTECTED]> wrote:
> We tried reducing the memory footprint of the postgres processes, via
> shared_buffers (from 3 on Linux to 3000 on Windows),
I would never go below 1. 2 to 3 is a goo
On Jan 18, 2008 2:14 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Fri, 18 Jan 2008, Sean Davis wrote:
>
> > FYI, here are the specs on the server.
> > http://www.thinkmate.com/System/8U_Dual_Xeon_i2SS40-8U_Storage_Server
>
> Now we're getting somewhere. I'll dump this on-list as it's a good
> e
On Fri, 18 Jan 2008, Sean Davis wrote:
FYI, here are the specs on the server.
http://www.thinkmate.com/System/8U_Dual_Xeon_i2SS40-8U_Storage_Server
Now we're getting somewhere. I'll dump this on-list as it's a good
example of how to fight this class of performance problems.
The usual troub
On Jan 18, 2008 4:58 AM, Adrian Moisey <[EMAIL PROTECTED]> wrote:
>
> We use a lot of checkpoints in our database, we don't care about these
> much. We think this is causing the checkpoint to write a lot of data at
> checkpoint time. Can we stop this behavior ?
You can smooth out the checkpoint
On Jan 17, 2008 6:23 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Thu, 17 Jan 2008, Scott Marlowe wrote:
>
> > On Jan 17, 2008 2:17 PM, Sean Davis <[EMAIL PROTECTED]> wrote:
> >> two3-ware cards, one 9640SE-24 and one 9640SE-16
> > Sounds like they're sharing something they shouldn't be. I'm no
Adrian Moisey wrote:
> Hi
>
If I tail the logs, I see a steady stream of functions that took longer
then 5 seconds. But every now and then I see nothing for 3 minutes and
after that a whole bunch (about 20 - 30) queries all finishing at the
same second.
>>>
>>> Search this l
Hi
If I tail the logs, I see a steady stream of functions that took
longer then 5 seconds. But every now and then I see nothing for 3
minutes and after that a whole bunch (about 20 - 30) queries all
finishing at the same second.
Search this list for references to "checkpoints". If you run
Hi
If I tail the logs, I see a steady stream of functions that took
longer then 5 seconds. But every now and then I see nothing for 3
minutes and after that a whole bunch (about 20 - 30) queries all
finishing at the same second.
Search this list for references to "checkpoints". If you run
