Chander Ganesan <chander(at)otg-nc(dot)com> 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