I've noticed my postgres processes have been increasing their memory usage.
this seems to happen because my clients applications are using connection
pooling and
until one of the clients forces a connection reset the postgres process does
not
release its memory.
I'd love to understand how to manag
Hard to know without a lot more info -
...any number of things could be culprit - from 'simple' config issue right up
through schema definition.
Lou
- Original Message -
From: "mark"
To: pgsql-admin@postgresql.org
Sent: Friday, February 11, 2011 6:12:10 PM
Subject: [ADMIN] PG
jf wrote:
>>> I tried to restart postgresql server and to reboot the server,
>>> but 5 minutes later, the trouble was here again.
>>
>> Any idea what changed during those 5 minutes?
> 5 minutes: just the time for my users to reconnect to my frontend.
> max_fsm_pages = 153600
Probably not the
Hi,
>> I tried to tune posgresql.conf to use more memory.
> Right before the problems started?
Yes two years ago.
>> postgresql processes eat my server
>> ressources, my load, which was between 0 and 2.5 on my 4 cpus
>> server, grows to 20.
>
> The output from `vmstat 1` during such an episod
Is this true ? I am having trouble finding the documentation on this.
Thanks for someone with better google-foo than me if they can find it, and
maybe why?
I have an LDAP master running 2.3.(something) on a box and it is looking
like getting that to 2.4 is a no-go.
Postgres does not auth with
