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

Re: Deteriorating performance when loading large objects

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Deteriorating performance when loading large objects
Date: 2008-11-25 13:17:47
Message-ID: gggttr$ofv$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-performance
Vegard Bønes wrote:
> Hi,
> 
> 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.

> So, my question for you is: Why does this happen, and what can I do about it?

Try putting a "vacuumdb -zf" command as a cron job after the data is
deleted.

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-11-25 13:36:46
Subject: Re: Deteriorating performance when loading large objects
Previous:From: Vegard BønesDate: 2008-11-25 12:54:23
Subject: Deteriorating performance when loading large objects

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