From: | Serguei Mokhov <serguei(at)gmail(dot)com> |
---|---|
To: | John KEA <johnkea21(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | Re: [pgsql-ru-general] Deleting Large Objects |
Date: | 2010-03-09 19:48:35 |
Message-ID: | f4c8e9e31003091148q4d60b1b4n2665ab814788f5d2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-ru-general |
Hi John,
pgsql-general(at)postgresql(dot)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(at)yahoo(dot)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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rodger Donaldson | 2010-03-09 21:01:00 | Re: kernel version impact on PostgreSQL performance |
Previous Message | Ben Chobot | 2010-03-09 19:35:31 | Re: obsessive-compulsive vacuum behavior |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey N. Oktyabrski | 2010-03-10 12:53:15 | Re: Удаление Large Objects |
Previous Message | John KEA | 2010-03-09 18:57:19 | Удаление Large Objects |