Deleting Large Objects - Mailing list pgsql-performance

From John KEA
Subject Deleting Large Objects
Date
Msg-id 794105.77271.qm@web112509.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: Deleting Large Objects  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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!

pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Re: Extracting superlatives - SQL design philosophy
Next
From: "Kevin Grittner"
Date:
Subject: Re: Deleting Large Objects