Large object performance

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.

Responses

Browse pgsql-general by date

  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