Re: [GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Martin F
On 18/03/2017 01:22, Adrian Klaver wrote: On 03/17/2017 06:07 PM, Martin F wrote: Hi, I just started last week to build postgresql from source. (So this may well be something I did wrong on my side) Do you really want to build the latest dev version? Yes, I want the latest, and I understand

[GENERAL] testcase failing on git master / how to progress

2017-03-17 Thread Martin F
Hi, I just started last week to build postgresql from source. (So this may well be something I did wrong on my side) I am on branch master Revision: f7819baa618c528f60e266874051563ecfe08207 Date: 17/03/2017 18:58:06 I did build with make clean distclean ./configure --prefix=/deploys/postg

Re: [GENERAL] odd optimizer result, index condition "is not null" on column defined as "not null"

2017-03-03 Thread Martin F
On 03/03/2017 17:33, Tom Lane wrote: Martin F writes: The select with filter choose an IMHO better plan Index Only Scan using tbl_foo_date on public.tbl_foo But the bigger picture here, which would become more obvious if you were working with a non-toy amount of data, is that you're a

Re: [GENERAL] odd optimizer result, index condition "is not null" on column defined as "not null"

2017-03-03 Thread Martin F
On 03/03/2017 17:33, Tom Lane wrote: Martin F writes: Index Cond: (tbl_foo.id IS NOT NULL) only "id" is the pk, and declared "not null". So why this index condition? You're right that we could observe that the NOT NULL is implied by a table constraint and drop it,

Re: [GENERAL] odd optimizer result, index condition "is not null" on column defined as "not null"

2017-03-03 Thread Martin F
for the "where" part) To check this I tried explain analyze verbose select min(created_at), min(id) filter(where created_at >= '2017-01-15') from tbl_foo; and it gives an index only as well. Out of interest, anyone with 9.6.2, does it yield the same results? On 03/03/2

[GENERAL] odd optimizer result, index condition "is not null" on column defined as "not null"

2017-03-03 Thread Martin F
Hi. I am new, and not sure which mailinglist this should go to, so I start with the general list. (please advice, if I should send this to a more specific list) This is tested with postgresql 9.5.5 (Maybe someone can confirm, if it is the same with later versions, saving me the work to upgrade