Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group