Re: Simple select hangs while CPU close to 100%

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Jozsef Szalay" <jszalay(at)storediq(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Simple select hangs while CPU close to 100%
Date: 2007-07-25 17:42:11
Message-ID: 162867790707251042h432f46f8x61e22c70a5f35662@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2007/7/25, Jozsef Szalay <jszalay(at)storediq(dot)com>:
> Hi Pavel,
>
>
> Yes I did vacuum. In fact the only way to "fix" this problem is
> executing a "full" vacuum. The plain vacuum did not help.
>
>
> Regards,
> Jozsef

It's question if vacuum was done.

Try vacuum verbose;

Maybe your max_fsm_pages is too low and you have to up it.

Regards
Pavel Stehule

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jozsef Szalay 2007-07-25 17:51:39 Re: Simple select hangs while CPU close to 100%
Previous Message Jozsef Szalay 2007-07-25 17:37:23 Re: Simple select hangs while CPU close to 100%