Postgres Pro
Downloads
Home   >   mailing lists

Re: Fast way to delete big table? - Mailing list pgsql-general

From John R Pierce
Subject Re: Fast way to delete big table?
Date
Msg-id fbc9bc2a-0b3d-3a11-5aed-daff92dc4c20@hogranch.com
Whole thread Raw
In response to Re: Fast way to delete big table?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: Fast way to delete big table?
List pgsql-general
Tree view
On 5/15/2016 10:23 PM, Gavin Flower wrote:
4. recreate indexes for tableA

note on a large table, this step can take a LONG time.   its greatly facilitated by setting  maintenance_work_mem = 1G beforehand.





-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Fast way to delete big table?
Next
From: Haiming Zhang
Date:
Subject: Re: Fast way to delete big table?