Re: support create index on virtual generated column. - Mailing list pgsql-hackers

From ZizhuanLiu X-MAN
Subject Re: support create index on virtual generated column.
Date
Msg-id tencent_FDF76D24B43F1338DF739626D4DD8DCFF008@qq.com
Whole thread
In response to Re: support create index on virtual generated column.  ("ZizhuanLiu X-MAN" <44973863@qq.com>)
Responses Re: support create index on virtual generated column.
List pgsql-hackers
Hi everyone,

Referring to the regress test feedback from CFBot against the V5 patch, I have reverted
the modifications made to `btcostestimate()`, and revised `genericcostestimate()` as follows:
When `numIndexTuples` gets recalculated within this function, `indexSelectivity` will be
re-estimated based on `index->rel->tuples`, ensuring that `numIndexTuples` and `indexSelectivity`
are mutually consistent.

I have verified the fix against the previously failing regression tests listed by CFBot,
specifically `generated_stored`, `generated_virtual`, `subselect` and `select_parallel`,
and all of them now pass successfully.


regards,
--
ZizhuanLiu (X-MAN) 
44973863@qq.com

Attachment

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Proposal: new file format for hba/ident/hosts configuration?
Next
From: Peter Eisentraut
Date:
Subject: Re: for loop variable fixes