Hi Tom (and all) Yes, in the meantime I realised that the other relevant clients (the ones that seemed to be holding the file handle) were ones that sat idle most of the time and rarely executed any query. You are right, as each of these executed a query (thus processing sinval) they released the filehandle. Thanks for the pointers. Vince -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: 26 October 2007 13:22 To: Vince Negri Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: TRUNCATE - timing of the return of disk space - caused by long-lived client? "Vince Negri" <vnegri@xxxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
