Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group