Re: Fast way to delete big table?

Поиск

Список

Период

Сортировка

От	John R Pierce
Тема	Re: Fast way to delete big table?
Дата	16 мая 2016 г. 08:28:28
Msg-id	fbc9bc2a-0b3d-3a11-5aed-daff92dc4c20@hogranch.com обсуждение исходный текст
Ответ на	Re: Fast way to delete big table? (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Ответы	Re: Fast way to delete big table? (Haiming Zhang <Haiming.Zhang@redflex.com.au>)
Список	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

В списке pgsql-general по дате отправления:

От: Gavin Flower
Дата: 16 мая 2016 г., 08:24:09
Сообщение: Re: Fast way to delete big table?

От: Haiming Zhang
Дата: 16 мая 2016 г., 08:33:54
Сообщение: Re: Fast way to delete big table?