Re: [GENERAL] Breakpoints are not triggered in analyze.c (debugging Postgresql in Visual studio)

2014-01-16 Thread ygnhzeus
Hi Tom, I'm debugging the /backend/commends/analyze.c. I've set up a Function breakpoint in visual studio,but seems no luck, T_T 2014-01-17 ygnhzeus 发件人:Tom Lane 发送时间:2014-01-16 23:31 主题:Re: [GENERAL] Breakpoints are not triggered in analyze.c (debugging Postgresql in Visual s

Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

2014-01-13 Thread ygnhzeus
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 收件人

Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

2014-01-10 Thread ygnhzeus
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

[GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

2014-01-10 Thread ygnhzeus
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