X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F0916D1C7F7 for ; Thu, 14 Aug 2003 17:56:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 09884-07 for ; Thu, 14 Aug 2003 14:55:53 -0300 (ADT) Received: from ctg-msnex01.staff.berbee.com (msn-office1.binc.net [64.73.12.254]) by svr1.postgresql.org (Postfix) with ESMTP id A33F2D1B52C for ; Thu, 14 Aug 2003 14:55:51 -0300 (ADT) Received: from localhost ([172.30.254.220] RDNS failed) by ctg-msnex01.staff.berbee.com with Microsoft SMTPSVC(5.0.2195.5329); Thu, 14 Aug 2003 12:55:37 -0500 From: "Jeremy M. Guthrie" Reply-To: jeremy.guthrie@berbee.com Organization: Berbee Information Networks To: pgsql-performance@postgresql.org Subject: Vacuum performance question Date: Thu, 14 Aug 2003 12:55:32 -0500 User-Agent: KMail/1.5.3 MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200308141255.36225.jeremy.guthrie@berbee.com> X-OriginalArrivalTime: 14 Aug 2003 17:55:37.0238 (UTC) FILETIME=[444E0360:01C3628D] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/263 X-Sequence-Number: 3079 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 My database is approximately 8gb in size. My application is 24/7. I'm=20 constantly cycling through data. I analyze every 15 minutes but I'm notici= ng=20 that during a vacuum the database becomes extremely sluggish. In some cases the operation of my software goes from 1-3 second runtime to= =20 300+ seconds during a vacuum. Should I expect this with a vacuum? I've done reading online where people = say=20 they see only a 10% decrease in speed. Is this supposed to be the norm? I've allocated 196MB of RAM to vacuums. The system is a dual P4-2.4ghz w/ 1.5 gig of RAM w/ 36 gig of RAID mirrored= =20 disk. I'm runing 7.3.2 and I am upgrading to 7.3.3 next week. Please advise. - --=20 Jeremy M. Guthrie Systems Engineer Berbee 5520 Research Park Dr. Madison, WI 53711 Phone: 608-298-1061 Berbee...Decade 1. 1993-2003 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/O80UqtjaBHGZBeURAqmLAJ9kxh0DyaZm3pAP77XGlDTq5JcsowCfeqpC 36SjIo5XW44bEkmHnbwXXBQ=3D =3DoozQ -----END PGP SIGNATURE-----