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: danmcb <danielmcbrearty(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: optimisation for a table with frequently used query
- Date: 29 May 2007 13:07:09 -0700
I just did some checks on two seperate indexes c.f. one combined one. I saw almost no difference between making select statements. Haven't tried what happens with many updates - makes sense that more indexes will slow that down though. again thanks - bit of a noob question I know, but it's good to learn :-)
- Follow-Ups:
- References:
- optimisation for a table with frequently used query
- From: danmcb
- Re: optimisation for a table with frequently used query
- From: PFC
- Re: optimisation for a table with frequently used query
- From: Lew
- Re: optimisation for a table with frequently used query
- From: Dann Corbit
- optimisation for a table with frequently used query
- Prev by Date: Re: optimisation for a table with frequently used query
- Next by Date: Re: optimisation for a table with frequently used query
- Previous by thread: Re: optimisation for a table with frequently used query
- Next by thread: Re: optimisation for a table with frequently used query
- Indexes: