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 <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: Postgresql Performance <[EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
