From: | Bosco Rama <postgres(at)boscorama(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Large object performance |
Date: | 2011-01-13 02:17:08 |
Message-ID: | 4D2E60A4.5020006@boscorama.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi folks,
I've been using large objects in 8.4.x for some time now and have noticed that
some operations on large objects appear to take an inordinate amount of time.
For example, the \lo_list command in psql seems slow for what it does (many
seconds before first printed line with only a few thousand loid's).
Also, when dropping the existing objects using the following (or similar table-
specific) syntax:
select lo_unlink(loid) from (select distinct(loid) from pg_largeobjects) as loidtmp;
can take many minutes and sometimes hours depending on loid count.
The machine the server is running on is no slouch either. Dual Quad-core
Opteron 2356's with 32GB of memory.
So, I was wondering if this is normal or if we have done something silly on
our end (or failed to do something smart) that would cause this.
TIA.
Bosco.
From | Date | Subject | |
---|---|---|---|
Next Message | Wohld, Adam | 2011-01-13 03:26:40 | Re: Large object performance |
Previous Message | zab08 | 2011-01-13 01:06:08 | Re: My DataBase can't accept conntecion |