Re: [DOCS] pg_total_relation_size() and CHECKPOINT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Date: 2008-03-14 17:21:48
Message-ID: 21561.1205515308@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

"Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com> writes:
> The previous results were received on PG 8.3 version:
> "PostgreSQL 8.3.0, compiled by Visual C++ build 1400"

Hmm. I find the whole thing fairly worrisome, because what it suggests
is that Windows isn't actually allocating file space during smgrextend,
which would mean that we'd be prone to running out of disk space at
unfortunate times --- like during a checkpoint, after we've already
promised the client the data is committed.

Can any Windows hackers look into this and find out what's really
happening?

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-14 17:28:39 Re: Small typo in install-win32.sgml
Previous Message Guillaume Lelarge 2008-03-14 16:47:39 Small typo in install-win32.sgml

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-14 17:26:01 pgsql: Fix vacuum so that autovacuum is really not cancelled when doing
Previous Message Joshua D. Drake 2008-03-14 17:19:52 Commit fest?