ou'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 -040
> 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 u
Hi Everyone
I am new to this group and relatively new to Postgres, having used MSSQL 7
up until now.
One table in my database in returning even the simplest of queries extremely
slowly. The table is user table, and even the select userid from users takes
over 20 seconds to run. There are abou
