I see, thanks, so columns of staop* are not currently used by the planner by
default, right?
The type of staop is oid, which table is related to it?
2014-01-13
ygnhzeus
发件人：Tom Lane
发送时间：2014-01-13 23:21
主题：Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL
收件人
=?GB2312?B?RmVsaXgu0Ow=?= writes:
> //line 194 : In a "most common values" slot, staop is the OID of the "="
> operator used to decide whether values are the same or not.
> //line 206 : A "histogram" slot describes the distribution of scalar data.
> staop is the OID of the "<" operator that descr
mize the join order (by setting
> > join_collapse_limit and from_collapse_limit to 1) , is there any other
> > factor that may affect the structure of execution plan regardless of the
> > data access method.
> >
> > 2014-01-10
> > ____________
&
___
> 发件人：Amit Langote
> 发送时间：2014-01-10 22:00
> 主题：Re: [GENERAL] How to specify/mock the statistic data of tables in
> PostgreSQL
> 收件人："ygnhzeus"
> 抄送："pgsql-general"
>
>
>
> AFAIK, correlation is involved in calculation o
m_collapse_limit to 1) , is there any other
> factor that may affect the structure of execution plan regardless of the data
> access method.
>
> 2014-01-10
> ygnhzeus
> 发件人：Amit Langote
> 发送时间：2014-01-10 22:00
> 主题：Re: [GENERAL] How to specify/mock the statistic data of
regardless of the data access method.
2014-01-10
ygnhzeus
发件人：Amit Langote
发送时间：2014-01-10 22:00
主题：Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL
收件人："ygnhzeus"
抄送："pgsql-general"
On Fri, Jan 10, 2014 at 6:00 PM, ygnhzeus wrote:
> Hi a
On Fri, Jan 10, 2014 at 6:00 PM, ygnhzeus wrote:
> Hi all,
>
> I want to use PostgreSQL to help me calculate the cardinality/selectivity of
> some queries, but I do not want to insert any data into these tables(since
> the data size is huge) to PostgreSQL. So I plan to calculate the statistic
> da
Hi all,
I want to use PostgreSQL to help me calculate the cardinality/selectivity of
some queries, but I do not want to insert any data into these tables(since the
data size is huge) to PostgreSQL. So I plan to calculate the statistic data by
myself (not in PostgreSQL) and manually specify the m
