"=?iso-8859-1?Q?Vegard_B=F8nes?=" <vegard(dot)bones(at)met(dot)no> writes:
> I have a problem with large objects in postgresql 8.1: The performance of
> loading large objects into a database goes way down after a few days of
> I have a cron job kicking in twice a day, which generates and loads around
> 6000 large objects of 3.7MB each. Each night, old data is deleted, so
> there is never more than 24000 large object in the database.
Are you sure you're deleting the large objects themselves (ie,
lo_unlink), and not just deleting some references to them?
A manual "vacuum verbose" on pg_largeobject might be informative.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Mark Kirkwood||Date: 2008-11-25 19:37:57|
|Subject: Re: Monitoring buffercache...|
|Previous:||From: Ivan Voras||Date: 2008-11-25 13:17:47|
|Subject: Re: Deteriorating performance when loading large objects|