X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7D314D1B9A6 for ; Mon, 19 Apr 2004 09:37:37 -0300 (ADT) 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 88910-08 for ; Mon, 19 Apr 2004 09:37:37 -0300 (ADT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id C6ECED1B4BE for ; Mon, 19 Apr 2004 09:37:33 -0300 (ADT) Received: from [134.22.69.199] (dyn-69-199.tor.dsl.tht.net [134.22.69.199]) by tht.net (Postfix) with ESMTP id BCE1F76A76; Mon, 19 Apr 2004 08:37:38 -0400 (EDT) Subject: Re: very slow simple query - outer join makes it quicker From: Rod Taylor To: gerard.isdell@kinetic.co.uk Cc: Postgresql Performance In-Reply-To: References: <1082376074.24414.3.camel@jester> Content-Type: text/plain Message-Id: <1082378194.24414.5.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 19 Apr 2004 08:36:34 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/269 X-Sequence-Number: 6569 On Mon, 2004-04-19 at 08:26, Gerard Isdell wrote: > Thank, that has worked. > > I've been running VACUUM regularly and thought that would have done it. > > Obviously the FULL makes a big difference It shouldn't. That FULL makes a significant difference says that you're not running regular VACUUM frequently enough and/or your fsm_* settings are too low. > -----Original Message----- > From: Rod Taylor > To: gerard.isdell@kinetic.co.uk > Cc: Postgresql Performance > Date: Mon, 19 Apr 2004 08:01:15 -0400 > Subject: Re: [PERFORM] very slow simple query - outer join makes it quicker > > > > There are other tables, such as the messages table, that have 10s of > > > thousands of rows and they return records much more quickly. > > > > > There must be something seriously wrong for simple queries like this > > to take > > > so long. > > > > Have you run VACUUM recently? > > > > If not, run VACUUM FULL against the users table and see if that makes a > > difference. > > > > > ************************************************************************* > This e-mail and any attachments may contain confidential or privileged > information. If you are not the intended recipient, please contact the > sender immediately and do not use, store or disclose their contents. > Any views expressed are those of the individual sender and not of Kinetic > Information System Services Limited unless otherwise stated. > > www.kinetic.co.uk