Re: sequence scan on PK

From: Jeroen van Iddekinge <iddekingej(at)lycos(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: sequence scan on PK
Date: 2005-05-08 17:49:36
Message-ID: 427E5130.7020702@lycos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>
> You could tweak with several settings to get it to do an index scan
> earlier, but these would probably break other queries. You don't need to
> tune for 100 rows, morelike 100k or 100M.

Thanks for respone.
The index scan was a little bit faster for id=1 and faster for id=99.

Which settings shoud I change for this? cpu_index_tuple_cost ,
cpu_operator_cost, cpu_tuple_cost?

Jer.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeroen van Iddekinge 2005-05-08 18:32:14 Re: sequence scan on PK
Previous Message Jim C. Nasby 2005-05-08 17:12:32 Re: COPY vs INSERT