Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group