Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vince Negri" <vnegri(at)asl-electronics(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?
Date: 2007-10-26 12:21:42
Message-ID: 9415.1193401302@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vince Negri" <vnegri(at)asl-electronics(dot)co(dot)uk> writes:
> What causes the file handles of the truncated table to be released by all postmaster processes?

It should happen when the other backends process the sinval message
about the TRUNCATE, which at the latest should be the next time they
begin command execution. What were the other clients doing, just
sitting idle?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-10-26 12:25:39 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Magnus Hagander 2007-10-26 12:07:02 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit