To: Bartels, Eric
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres eats all memory
In response to "Bartels, Eric" <[EMAIL PROTECTED]>:
> Hi there,
>
> we are running a fresh Postgres 8.3 installation with a single
> database with about 80GB of data.
Bartels, Eric wrote:
In addition to info others have requested, the output of the following
may be useful:
select name,setting,source from pg_settings where not source = 'default';
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
On Wed, Aug 13, 2008 at 4:06 AM, Bartels, Eric <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> we are running a fresh Postgres 8.3 installation with a single
> database with about 80GB of data.
>
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a
On Wed, Aug 13, 2008 at 10:06:37AM +0200, Bartels, Eric wrote:
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a system reboot
> and even without sending queries against the database the
> whole system memory is consumed after some time.
In response to "Bartels, Eric" <[EMAIL PROTECTED]>:
> Hi there,
>
> we are running a fresh Postgres 8.3 installation with a single
> database with about 80GB of data.
>
> After a while the whole system memory is eaten up and every
> operation becomes very slow. Shortly after a system reboot
> a
On 2008-08-13 10:06, Bartels, Eric wrote:
> After a while the whole system memory is eaten up and every
> operation becomes very slow.
Show us:
- output of "free" command, when server gets slow.
- output of "ps v --sort=-size | head -10"
- output of "ps auxww | grep postgres"
- in terminal st
Hi there,
we are running a fresh Postgres 8.3 installation with a single
database with about 80GB of data.
After a while the whole system memory is eaten up and every
operation becomes very slow. Shortly after a system reboot
and even without sending queries against the database the
whole system