Обсуждение: Deleting Large Objects

Поиск
Список
Период
Сортировка

Deleting Large Objects

От
John KEA
Дата:
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!

Re: Deleting Large Objects

От
Sergey Konoplev
Дата:
Hello,

You might be wrote to wrong mailing list. It is pgsql-ru-general@postgresql.org - PostgreSQL related list in Russian. I suppose you need pgsql-general@postgresql.org

On Tue, Mar 9, 2010 at 6:19 PM, John KEA <johnkea21@yahoo.com> wrote:
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!




--
Regards,
Sergey Konoplev

PostgreSQL articles in Russian and English
http://gray-hemp.blogspot.com/search/label/postgresql/

Re: Deleting Large Objects

От
Serguei Mokhov
Дата:
Hi John,

pgsql-general@postgresql.org is perhaps a better idea
to post this. You've posted the message to the regional
Russian mailing list where the audience is somewhat of
a narrower scope.

-s

On Tue, Mar 9, 2010 at 10:19 AM, John KEA <johnkea21@yahoo.com> wrote:
> <table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Dear PostgreSQL
Creators,</DIV>
> <DIV> </DIV>
> <DIV>I am frequently using PostgreSQL server to manage the data, but I am stuck ed now with a problem of large
objectsdeleting, namely it works too slow. E.g., deleting of 900 large objects of 1 Mb size takes around 2.31 minutes.
Thisdataset is not largest one which I am working with, e.g. deleting of 3000x1Mb objects takes around half an hour.
Couldyou, please, give me a few advices what do I have to do to improve the deleting time? (i've tried to extend the
memoryserver uses, but results are the same)</DIV> 
> <DIV> </DIV>
> <DIV>Best regards!</DIV></td></tr></table><br>

--
Serguei Mokhov
http://www.cs.concordia.ca/~mokhov
http://marf.sf.net | http://sf.net/projects/marf