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: (view raw or whole 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.


> 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-SrDate: 2004-08-31 21:46:32
Subject: Re: cannot reach http:/
Previous:From: Martijn van OosterhoutDate: 2004-08-31 21:34:01
Subject: Re: Multicolumn Primary Key

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