Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: optimisation for a table with frequently used query
- From: PFC <lists(at)peufeu(dot)com>
- To: danmcb <danielmcbrearty(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: optimisation for a table with frequently used query
- Date: Mon, 28 May 2007 21:37:11 +0200
SELECT * from my_table where id_1 = x and id_2 = y; Neither id_1 or id_2 or the combination of them is unique. I expect this table to become large over time.
Create an index on (id_1, id_2), or (id_2,id_1).
- Follow-Ups:
- References:
- optimisation for a table with frequently used query
- From: danmcb
- optimisation for a table with frequently used query
- Prev by Date: Re: createdb.exe prompting for password on Vista
- Next by Date: Re: createdb.exe prompting for password on Vista
- Previous by thread: optimisation for a table with frequently used query
- Next by thread: Re: optimisation for a table with frequently used query
- Indexes: