Re: [HACKERS] whether I can see other alternative plantrees for one query?

2014-07-28 Thread Kyotaro HORIGUCHI
Hi, > hi, all > NOTE: Version is 8.4 Fedora 20 X86_64 Why don't you play on 9.3 or later? 8.4 is now on the edge to EOL. > for understanding optimizer's internals, I set debug_print_plan=on > and created two tables as follows : > > create table Reserves (sid integer, bid integer,day date,

Re: [HACKERS] whether I can see other alternative plantrees for one query?

2014-07-28 Thread Tom Lane
=?UTF-8?B?5Zyf5Y2c55q/?= writes: > NOTE: Version is 8.4 Fedora 20 X86_64 You do realize that's five years out of date? Not sure why you're running an end-of-life database on a bleeding-edge OS. > for understanding optimizer's internals, I > *set debug_print_plan=on* > ... > but from the l

[HACKERS] whether I can see other alternative plantrees for one query?

2014-07-28 Thread 土卜皿
hi, all NOTE: Version is 8.4 Fedora 20 X86_64 for understanding optimizer's internals, I *set debug_print_plan=on* and created two tables as follows : *create table Reserves (sid integer, bid integer,day date,rname char(25));create table Sailors(sid integer,sname char(25),rating integer,