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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group