Craig James writes:
> On Wed, May 1, 2013 at 5:18 PM, Tom Lane wrote:
>> It looks like old_str_conntab is more or less clustered by "id",
>> and str_conntab not so much. You could try EXPLAIN (ANALYZE, BUFFERS)
>> (on newer PG versions) to verify how many distinct pages are getting
>> touched du
On Wed, May 1, 2013 at 5:18 PM, Tom Lane wrote:
> Craig James writes:
> > I have two tables that are nearly identical, yet the same query runs 100x
> > slower on the newer one. ...
>
> > db=> explain analyze select id, 1 from str_conntab
> > where (id >= 12009977 and id <= 12509976) order by id;
Craig James writes:
> I have two tables that are nearly identical, yet the same query runs 100x
> slower on the newer one. ...
> db=> explain analyze select id, 1 from str_conntab
> where (id >= 12009977 and id <= 12509976) order by id;
> Index Scan using new_str_conntab_pkey_3217 on str_connta
