Re: Postgres Hidden Pitfalls - Mailing list pgsql-admin

From Robert Treat
Subject Re: Postgres Hidden Pitfalls
Date
Msg-id 1030723474.7035.16.camel@camel
Whole thread Raw
In response to Postgres Hidden Pitfalls  (matthew.palmer@abcmail.co.uk (Matt Palmer))
Responses Re: Postgres Hidden Pitfalls
List pgsql-admin
On Fri, 2002-08-30 at 05:37, Matt Palmer wrote:
> Hi,
>
> is anyone able to assist me in finding a publication/source which
> documents Postgresqls hidden problems. I have some postgresql books
> which are good for database creation/functions, but for example just
> recently I had a problem with the 'pg_xlogs', of which I could find no
> mention inside the manuals I had.
>
> Unfortuantely my /var file system filled up because I had to do about
> 10 bulk copies, which created an unexpected 160 mb of xlog files on
> var and toppled the system as the var filesystem filled up. - Its
> things like this I would be insterested in, so that I can pre-empt
> them happening. Fortunately I managed to resolve this issue, but it
> took me a days work to get there.
>
> Any help you have would be great.

I think there are a few documents like this on the
techdocs.postgresql.org, though I don't know if there is a general
"gotchas" document. (I guess you could start one ;-> )

Robert Treat




pgsql-admin by date:

Previous
From: Andrew Perrin
Date:
Subject: Re: Silencing NOTICEs in Perl Pg
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres Hidden Pitfalls