Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?
Date
Msg-id 9415.1193401302@sss.pgh.pa.us
Whole thread Raw
In response to TRUNCATE - timing of the return of disk space - caused by long-lived client?  ("Vince Negri" <vnegri@asl-electronics.co.uk>)
Responses Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?  ("Vince Negri" <vnegri@asl-electronics.co.uk>)
List pgsql-general
Tree view 
"Vince Negri" <vnegri@asl-electronics.co.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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: TRUNCATE - timing of the return of disk space - caused by long-lived client?
Next
From: Michael Glaesemann
Date:
Subject: Re: How to ALTER a TABLE to change the primary key?