Re: Postgres Hidden Pitfalls - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres Hidden Pitfalls
Date
Msg-id 556.1030718734@sss.pgh.pa.us
Whole thread Raw
In response to Postgres Hidden Pitfalls  (matthew.palmer@abcmail.co.uk (Matt Palmer))
List pgsql-admin
matthew.palmer@abcmail.co.uk (Matt Palmer) writes:
> is anyone able to assist me in finding a publication/source which
> documents Postgresqls hidden problems.

Well, one not-too-hidden pitfall is running with old releases...

> 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

... and unlimited growth of xlog files was fixed awhile ago.

We don't make dot-releases just to amuse ourselves.  If you're on
7.1.2, and there's a 7.1.3 available, you're on the wrong release.
(Actually you should be on 7.2.2 ;-) ... but moving up to a patch
release later in the same series is a painless no-brainer.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compile Error
Next
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] Max Shared Memory