Re: Very slow catalog query - Mailing list pgsql-general

From Just Someone
Subject Re: Very slow catalog query
Date
Msg-id 36932f270803310946m57b4b71fq7ee32ef1a525f59e@mail.gmail.com
Whole thread Raw
In response to Re: Very slow catalog query  (Pedro Doria Meunier <pdoria@netmadeira.com>)
List 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.

pgsql-general by date:

Previous
From: "Brett Hoerner"
Date:
Subject: Re: [pgsql-general] Daily digest v1.8030 (22 messages)
Next
From: "Just Someone"
Date:
Subject: Re: Very slow catalog query