Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Multicolumn Primary Key
- From: Thomas F.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: Tue, 31 Aug 2004 16:44:44 -0500
- Message-id: <F8CA3122-FB96-11D8-A557-000D93AE0944(at)sitening(dot)com>
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
- Follow-Ups:
- Re: Multicolumn Primary Key
- From: Matthew T. O'Connor
- Re: Multicolumn Primary Key
- References:
- Multicolumn Primary Key
- From: Thomas F . O'Connell
- Re: Multicolumn Primary Key
- From: Martijn van Oosterhout
- Multicolumn Primary Key
- Prev by Date: Re: cannot reach http:/archives.postgresql.org
- Next by Date: Re: Large Databases
- Previous by thread: Re: Multicolumn Primary Key
- Next by thread: Re: Multicolumn Primary Key
- Indexes: