Re: Large object performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bosco Rama <postgres(at)boscorama(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large object performance
Date: 2011-01-13 04:43:06
Message-ID: 8831.1294893786@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bosco Rama <postgres(at)boscorama(dot)com> writes:
> 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).

That particular operation should be significantly faster in 9.0. But in
general large objects are not an area where any great amount of sweat
has been invested on performance issues.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tbazadaykin 2011-01-13 07:12:02 sprintf
Previous Message Wohld, Adam 2011-01-13 03:26:40 Re: Large object performance