Deleting Large Objects

From: John KEA <johnkea21(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Deleting Large Objects
Date: 2010-03-09 18:44:50
Message-ID: 794105.77271.qm@web112509.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-03-09 19:28:36 Re: Deleting Large Objects
Previous Message Dave Crooke 2010-03-09 16:13:30 Re: Extracting superlatives - SQL design philosophy