Re: Multicolumn Primary Key

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.

300,000+

> 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.

Thanks.

-tfo