Обсуждение: Deleting Large Objects
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! |
Hello,
--
Regards,
Sergey Konoplev
PostgreSQL articles in Russian and English
http://gray-hemp.blogspot.com/search/label/postgresql/
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/
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