| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Speed of lo_unlink vs. DELETE on BYTEA |
| Date: | 2011-09-23 18:12:55 |
| Message-ID: | e5d07765-a754-48d1-ae4b-95b74bb9c954@mm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Reuven M. Lerner wrote:
> 1.1 1,000 records
> ==================
>
> Delete Dump
> ---------------+---------+--------
> Empty content 0.172s 0.057s
> bytea 0.488s 0.066s
> large object 30.833s 9.275s
How much bytea are you dumping for it to take only 0.066s?
The fact that it takes about the same time than dumping the "empty content"
looks very suspicious.
On my desktop machine, if I create a table with 1000 blobs containing strings
of 5 million 'x', which is what I understood you basically did (perhaps I
misunderstood?), then it takes about 200s to dump it with pg_dump -Fc
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-09-23 18:25:46 | Re: how to install 9.1 on non-graphical server? |
| Previous Message | Josh Kupershmidt | 2011-09-23 17:49:31 | Re: Materialized views in Oracle |