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,
=?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
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,