Re: Deleting Large Objects

Hello,

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

On Tue, Mar 9, 2010 at 6:19 PM, John KEA <johnkea21(at)yahoo(dot)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/