where I had 500 MB of file space defined for my WAL log files and then
attempted (not thinking it through thoroughly) to perform a COPY of a
very large (1.8 GB) dataset and kept adding WAL files until my file
system filled up and then the instance crashed.
[mailto:firstname.lastname@example.org] On Behalf Of Tom Lane
Sent: Tuesday, September 30, 2008 1:45 PM
To: Chander Ganesan
Cc: Jonny; email@example.com
Subject: Re: [ADMIN] turning of pg_xlog
Chander Ganesan <firstname.lastname@example.org> writes:
> You should also understand that if you set checkpoint_segments to a
> small number, its still possible that PostgreSQL might use more than
> that number for a large transaction.
"Large transactions" have nothing to do with this. You are confusing
Postgres' implementation with Oracle's.
regards, tom lane