Skip site navigation (1) Skip section navigation (2)

Deleting Large Objects

From: John KEA <johnkea21(at)yahoo(dot)com>
To: pgsql-ru-general(at)postgresql(dot)org
Subject: Deleting Large Objects
Date: 2010-03-09 15:19:50
Message-ID: 718068.16979.qm@web112518.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-ru-general
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!


      

Responses

pgsql-ru-general by date

Next:From: Sergey KonoplevDate: 2010-03-09 17:33:27
Subject: Re: Deleting Large Objects
Previous:From: listsDate: 2009-12-21 10:17:40
Subject: Windows & UTF-8 question

pgsql-general by date

Next:From: Greg Sabino MullaneDate: 2010-03-09 15:23:22
Subject: Re: log_statement and syslog severity
Previous:From: Bryan MontgomeryDate: 2010-03-09 15:13:30
Subject: Re: autovacuum question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group