Re: Multicolumn Primary Key

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multicolumn Primary Key
Date: 2004-08-31 21:44:44
Message-ID: F8CA3122-FB96-11D8-A557-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ennio-Sr 2004-08-31 21:46:32 Re: cannot reach http:/archives.postgresql.org
Previous Message Martijn van Oosterhout 2004-08-31 21:34:01 Re: Multicolumn Primary Key