| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Andy Colson <andy(at)squeakycode(dot)net> |
| Cc: | Michael Kohl <michael(dot)kohl(at)tupalo(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High load, |
| Date: | 2011-01-27 18:14:32 |
| Message-ID: | AANLkTikCF30=ji60kJbCcp_LJqMPs9TVBDv8x+uk_+pb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Jan 27, 2011 at 10:20 AM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> On 1/27/2011 9:09 AM, Michael Kohl wrote:
>>
>> On Thu, Jan 27, 2011 at 4:06 PM, Andy Colson<andy(at)squeakycode(dot)net> wrote:
>>>
>>> Have you run each of your queries through explain analyze lately?
>>
>> A code review including checking of queries is on our agenda.
>>
>>> You are vacuuming/autovacuuming, correct?
>>
>> Sure :-)
>>
>> Thank you,
>> Michael
>>
>
> Oh, also, when the box is really busy, have you watched vmstat to see if you
> start swapping?
Setting sysstat service to run so you can see what your disks were
doing in the last 7 days is useful too. Makes it much easier to
figure things out afterwards when you have history of what has been
happening.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2011-01-27 18:19:35 | Re: High load, |
| Previous Message | Scott Marlowe | 2011-01-27 18:13:17 | Re: High load, |