Skip site navigation (1) Skip section navigation (2)

Re: cluster test

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joachim Wieland <joe(at)mcknight(dot)de>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: cluster test
Date: 2007-05-26 16:14:14
Message-ID: 3649.1180196054@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Joachim Wieland <joe(at)mcknight(dot)de> writes:
> On Sat, May 26, 2007 at 11:40:52AM +0100, Heikki Linnakangas wrote:
>> Or maybe some non-default values in postgresql.conf? Like random_page_cost?

> No, I use what initdb creates:

Curiouser and curiouser.  You still get the indexscan as preferred if
you EXPLAIN the query after the regression tests complete, right?
Could you step through cost_seqscan and see how it's arriving at such
a high value?

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Joachim WielandDate: 2007-05-26 17:12:28
Subject: Re: cluster test
Previous:From: Joachim WielandDate: 2007-05-26 11:40:27
Subject: Re: cluster test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group