Re: Index optimization ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bo Lorentsen <bl(at)netgroup(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index optimization ?
Date: 2005-01-17 16:07:27
Message-ID: 2175.1105978047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bo Lorentsen <bl(at)netgroup(dot)dk> writes:
> To me it sounds like an index lookup is a one time a query (not per row)
> thing, but I don't understand why.

I can't explain it any more clearly than Florian did:
http://archives.postgresql.org/pgsql-general/2005-01/msg00769.php

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-17 16:10:47 Re: Use strict with plperl
Previous Message John Cunningham 2005-01-17 16:05:27 Re: pgpool