Postgres Pro
Downloads
Home   >   mailing lists

Re: very slow simple query - outer join makes it quicker - Mailing list pgsql-performance

From Rod Taylor
Subject Re: very slow simple query - outer join makes it quicker
Date
Msg-id 1082376074.24414.3.camel@jester
Whole thread Raw
In response to very slow simple query - outer join makes it quicker  ("Gerard Isdell" <gerard.isdell@kinetic.co.uk>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: "Gerard Isdell"
Date:
Subject: very slow simple query - outer join makes it quicker
Next
From: Dave Cramer
Date:
Subject: Re: Horribly slow hash join