Re: random slow query

From: Mike Ivanov <mikei(at)activestate(dot)com>
To: Sean Ma <seanxma(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: random slow query
Date: 2009-06-30 18:00:07
Message-ID: 4A4A52A7.4050000@activestate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Ivanov 2009-06-30 18:01:59 Re: random slow query
Previous Message Scott Marlowe 2009-06-30 17:59:52 Re: random slow query