Re: Deteriorating performance when loading large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vegard(dot)bones(at)met(dot)no
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Deteriorating performance when loading large objects
Date: 2008-11-25 13:36:46
Message-ID: 14976.1227620206@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"=?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
> operation.

> 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2008-11-25 19:37:57 Re: Monitoring buffercache...
Previous Message Ivan Voras 2008-11-25 13:17:47 Re: Deteriorating performance when loading large objects