| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2010-03-09 15:23:22 | Re: log_statement and syslog severity |
| Previous Message | Bryan Montgomery | 2010-03-09 15:13:30 | Re: autovacuum question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2010-03-09 17:33:27 | Re: Deleting Large Objects |
| Previous Message | lists | 2009-12-21 10:17:40 | Windows & UTF-8 question |