Re: Fast way to delete big table?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fast way to delete big table?
Date: 2016-05-16 05:28:12
Message-ID: fbc9bc2a-0b3d-3a11-5aed-daff92dc4c20@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Haiming Zhang 2016-05-16 05:33:45 Re: Fast way to delete big table?
Previous Message Gavin Flower 2016-05-16 05:23:50 Re: Fast way to delete big table?