Re: VACUUMing sometimes increasing database size / sometimes

$ ls -al pgsqldb/pg_xlog
total 32816
drwx------    2 nitinverma root         4096 Jun 16 19:53 .
drwx------    6 nitinverma root         4096 Jun 16 19:33 ..
-rw-------    1 nitinverma root     16777216 Jun 16 20:08 0000000000000001
-rw-------    1 nitinverma root     16777216 Jun 16 19:45 0000000000000002

Looks like if a WAL file is created even vacuum can't reclaim the space. Is
that the root cause behind DB bloating with 7.3.2?

-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Friday, June 16, 2006 6:29 PM
To: Nitin Verma
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] VACUUMing sometimes increasing database size /
sometimes

Nitin Verma wrote:
>>> if your application depends on things that changed between 7.3 and 8.1.
>>
> Postgres tends to become more strict with every release, so
>>> there are things you got away with in 7.3 which now cause an error
>>> message.
>
> Do we have change lists where I can see all the changes between 7.3 and
8.1,
> may be release by release?

Try the manuals where there are version-by-version details of changes in
the release-notes.

http://www.postgresql.org/docs/8.1/static/release.html

--
   Richard Huxton
   Archonet Ltd