Re: Massive delete performance

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Massive delete performance
Дата
Msg-id 20051011121942.GA25543@uio.no
обсуждение исходный текст
Ответ на Massive delete performance  ("Andy" <frum@ar-sd.net>)
Список pgsql-performance
On Tue, Oct 11, 2005 at 10:47:03AM +0300, Andy wrote:
> So, I have a replication only with the tables that I need to send, then I
> make a copy of this replication, and from this copy I delete all the data's
> that are not needed.
>
> How can I increase this DELETE procedure because it is really slow???
> There are of corse a lot of data's to be deleted.

Instead of copying and then deleting, could you try just selecting out what
you wanted in the first place?

/* Steinar */
--
Homepage: http://www.sesse.net/

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

Предыдущее
От: Sean Davis
Дата:
Сообщение: Re: Massive delete performance
Следующее
От: "Andy"
Дата:
Сообщение: Re: Massive delete performance