Re: optimisation for a table with frequently used query - Mailing list pgsql-general

From danmcb
Subject Re: optimisation for a table with frequently used query
Date
Msg-id 1180469228.975107.248680@p47g2000hsd.googlegroups.com
Whole thread Raw
In response to Re: optimisation for a table with frequently used query  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: optimisation for a table with frequently used query
List pgsql-general
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 :-)



pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: optimisation for a table with frequently used query
Next
From: PFC
Date:
Subject: Re: optimisation for a table with frequently used query