Re: random slow query - Mailing list pgsql-performance

From Mike Ivanov
Subject Re: random slow query
Date
Msg-id 4A4A52A7.4050000@activestate.com
Whole thread Raw
In response to Re: random slow query  (Sean Ma <seanxma@gmail.com>)
List pgsql-performance
Sean,

> Yes, besides another mysql server running on
> the same server,
Which is a really bad idea :-)

> The postgres shared cache is at 4G, is that too big?
>
OK, I have misread the total memory amount which was 32G, and I thought
it was 3G. Thanks to Scott Marlow who pointed that out. In this case 4G
for shared buffers is good.

Actually, I take back my words on swap, too. 200M swapped is less
important when you have a plenty of memory.

Regards,
Mike


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: random slow query
Next
From: Mike Ivanov
Date:
Subject: Re: random slow query