X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3C8ECD1B450 for ; Sat, 27 Dec 2003 01:07:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 65119-08 for ; Fri, 26 Dec 2003 21:06:25 -0400 (AST) Received: from gw.tssi.com (gw.tssi.com [198.147.197.1]) by svr1.postgresql.org (Postfix) with ESMTP id B77C3D1B432 for ; Fri, 26 Dec 2003 21:06:21 -0400 (AST) Received: from gw.tssi.com (nolan@gw.tssi.com [127.0.0.1] (may be forged)) by gw.tssi.com (8.12.6/8.12.6) with ESMTP id hBR16MjC002312; Fri, 26 Dec 2003 19:06:23 -0600 Received: (from nolan@localhost) by gw.tssi.com (8.12.6/8.12.6/Submit) id hBR16MLg002310; Fri, 26 Dec 2003 19:06:22 -0600 From: Mike Nolan Message-Id: <200312270106.hBR16MLg002310@gw.tssi.com> Subject: Re: What's faster? To: kbottner@comcast.net (Keith Bottner) Date: Fri, 26 Dec 2003 19:06:21 -0600 (CST) Cc: pgsql-performance@postgresql.org In-Reply-To: <008301c3cc0d$f3f337b0$7d00a8c0@juxtapose> from "Keith Bottner" at Dec 26, 2003 06:11:19 PM X-Mailer: ELM [version 2.5 PL3] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/300 X-Sequence-Number: 5160 > Because Postgres requires VACUUM ANALYZE more frequently on updated tables, > should I break this single field out into its own table, and if so what kind > of a speed up can I expect to achieve. I would be appreciative of any > guidance offered. Unless that field is part of the key, I wouldn't think that a vacuum analyze would be needed, as the key distribution isn't changing. I don't know if that is still true if that field is indexed. Tom? Even then, as I understand things vacuum analyze doesn't rebuild indexes, so I could see a need to drop and rebuild indexes on a regular basis, even if you move that field into a separate table. -- Mike Nolan