On Aug 31, 2004, at 4:34 PM, Martijn van Oosterhout wrote:
> How many rows in the table? If it's a small table PostgreSQL won't
> consider using the index.
> Otherwise, have you VACUUM ANALYZEd recently?
Argh! That seems to have been it. I have pg_autovacuum running, so it
didn't occur to me.
In response to
pgsql-general by date
|Next:||From: Ennio-Sr||Date: 2004-08-31 21:46:32|
|Subject: Re: cannot reach http:/archives.postgresql.org|
|Previous:||From: Martijn van Oosterhout||Date: 2004-08-31 21:34:01|
|Subject: Re: Multicolumn Primary Key|