Deleting Large Objects

Поиск
Список
Период
Сортировка
От John KEA
Тема Deleting Large Objects
Дата
Msg-id 718068.16979.qm@web112518.mail.gq1.yahoo.com
обсуждение исходный текст
Ответы Re: Deleting Large Objects  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Deleting Large Objects  (Serguei Mokhov <serguei@gmail.com>)
Список pgsql-ru-general
Dear PostgreSQL Creators,
 
I am frequently using PostgreSQL server to manage the data, but I am stuck ed now with a problem of large objects deleting, namely it works too slow. E.g., deleting of 900 large objects of 1 Mb size takes around 2.31 minutes. This dataset is not largest one which I am working with, e.g. deleting of 3000x1Mb objects takes around half an hour. Could you, please, give me a few advices what do I have to do to improve the deleting time? (i've tried to extend the memory server uses, but results are the same)
 
Best regards!

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

Предыдущее
От: lists@kambanaria.org
Дата:
Сообщение: Windows & UTF-8 question
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Deleting Large Objects