From: Ivan Voras <ivoras@freebsd.org>
To: pgsql-performance@postgresql.org
Subject: Re: Deteriorating performance when loading large objects
Date: Tue, 25 Nov 2008 14:17:47 +0100
Message-ID: <gggttr$ofv$1@ger.gmane.org> (raw)
In-Reply-To: <63696.85.166.86.82.1227617663.squirrel@webmailsunny.oslo.dnmi.no>
References: <63696.85.166.86.82.1227617663.squirrel@webmailsunny.oslo.dnmi.no>
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.
Attachments:
signature.asc (application/pgp-signature, 251B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ivoras@freebsd.org
Subject: Re: Deteriorating performance when loading large objects
In-Reply-To: <gggttr$ofv$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox