pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDeleting Large Objects
2+ messages / 2 participants
[nested] [flat]
* Deleting Large Objects
@ 2010-03-09 18:44 John KEA <johnkea21@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: John KEA @ 2010-03-09 18:44 UTC (permalink / raw)
To: 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!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Deleting Large Objects
@ 2010-03-09 19:28 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: John KEA <johnkea21@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2010-03-09 19:28 UTC (permalink / raw)
To: pgsql-performance; John KEA <johnkea21@yahoo.com>
John KEA <johnkea21@yahoo.com> wrote:
> I am stuck ed now with a problem of large objects deleting,
> please, give me a few advices what do I have to do to improve the
> deleting time?
You've come to the right place, but we need more information to be
able to help. Please review this page and repost with the suggested
information.
http://wiki.postgresql.org/wiki/SlowQueryQuestions
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-03-09 19:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-09 18:44 Deleting Large Objects John KEA <johnkea21@yahoo.com>
2010-03-09 19:28 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox