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: 2007-05-29 20:07:09
Message-ID: 1180469228.975107.248680@p47g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 :-)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-05-29 20:23:35 Re: optimisation for a table with frequently used query
Previous Message Dann Corbit 2007-05-29 19:52:55 Re: optimisation for a table with frequently used query