Re: cluster test - Mailing list pgsql-patches

From Tom Lane
Subject Re: cluster test
Date
Msg-id 19721.1180116141@sss.pgh.pa.us
Whole thread Raw
In response to Re: cluster test  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: cluster test
List pgsql-patches
Gregory Stark <stark@enterprisedb.com> writes:
> Perhaps this comes down to 64 vs 32 bit datum and aligments and therefore
> different size tables which because the planner does the lseek to measure the
> table size shows up as different estimates for sequential scan costs?

But we've got plenty of both in the buildfarm, and none of them are
showing this failure.  So I'm curious to know what's really different
about Joachim's installation.  It seems he must have a pg_constraint
table enough larger than "normal" to discourage the seqscan, but where
did that come from?  There's only one row in pg_constraint in standard
template0 --- could he be working with a custom system that has many
more?

            regards, tom lane

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: cluster test
Next
From: Tom Lane
Date:
Subject: Re: Rewritten Index Advisor patch