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

Re: Very slow catalog query

From: "Just Someone" <just(dot)some(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Very slow catalog query
Date: 2008-03-31 16:46:23
Message-ID: 36932f270803310946m57b4b71fq7ee32ef1a525f59e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,


>  I'm wondering... just 4GB of ram?
>  What's the "normal" "hammering" -- a.k.a. user access -- to all of this?
>  PG, as expected, launches a separate process for each connection. this eats up
>  resources quite quickly....
>  Did you check your system processes with 'top' ? how's it looking for swap
>  usage?

Swap usage is almost nil. And I only have a constant number of
connections (about 10-15) as it serves as the backend for a Web
application. Transactions run at about 20-40 per second, but mostly
very short and simple ones.

Thanks,

Guy.

In response to

pgsql-general by date

Next:From: Just SomeoneDate: 2008-03-31 16:52:06
Subject: Re: Very slow catalog query
Previous:From: Brett HoernerDate: 2008-03-31 16:33:53
Subject: Re: [pgsql-general] Daily digest v1.8030 (22 messages)

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