Hi John, pgsql-general@xxxxxxxxxxxxxx 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@xxxxxxxxx> 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 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)</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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
