Postgres Pro
Downloads
Home   >   mailing lists

Re: drop/truncate table sucks for large values of shared buffers - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: drop/truncate table sucks for large values of shared buffers
Date
Msg-id 558FFD60.6010804@dunslane.net
Whole thread Raw
In response to Re: drop/truncate table sucks for large values of shared buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 06/27/2015 10:10 AM, Tom Lane wrote:
> It also
> offers no hope of a fix for the other operations that scan the whole
> buffer pool, such as DROP TABLESPACE and DROP DATABASE.
>

Improving DROP TABLE / TRUNCATE would still be a significant advance. 
These cases cause far more real world pain than the ones you mention, in 
my experience.

cheers

andrew

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: proposal: condition blocks in psql
Next
From: Andres Freund
Date:
Subject: Re: drop/truncate table sucks for large values of shared buffers