Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0732264FC5F for ; Tue, 25 Nov 2008 09:18:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41582-08 for ; Tue, 25 Nov 2008 09:17:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mail.postgresql.org (Postfix) with ESMTP id CAFC364FC38 for ; Tue, 25 Nov 2008 09:17:59 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1L4xne-0006vM-Vu for pgsql-performance@postgresql.org; Tue, 25 Nov 2008 13:17:54 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 25 Nov 2008 13:17:54 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 25 Nov 2008 13:17:54 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Re: Deteriorating performance when loading large objects Date: Tue, 25 Nov 2008 14:17:47 +0100 Lines: 41 Message-ID: References: <63696.85.166.86.82.1227617663.squirrel@webmailsunny.oslo.dnmi.no> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig8465CFEBC6A1E06FB2AFABA2" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.17 (X11/20080925) In-Reply-To: <63696.85.166.86.82.1227617663.squirrel@webmailsunny.oslo.dnmi.no> X-Enigmail-Version: 0.95.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200811/254 X-Sequence-Number: 31985 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig8465CFEBC6A1E06FB2AFABA2 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Vegard B=C3=B8nes wrote: > Hi, >=20 > 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. >=20 > I have a cron job kicking in twice a day, which generates and loads aro= und > 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 abo= ut it? Try putting a "vacuumdb -zf" command as a cron job after the data is deleted. --------------enig8465CFEBC6A1E06FB2AFABA2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJK/r7ldnAQVacBcgRAkrtAJwN0JWmnZ1oU41Zj+kWH3wilU4JSQCgg7sP mwbmVB6HfaP8L0u0LCPIEjM= =lyjN -----END PGP SIGNATURE----- --------------enig8465CFEBC6A1E06FB2AFABA2--