Re: [PERFORM] Primary key index partially used

2016-01-26 Thread Igor Neyman
From: Igor Neyman Sent: Tuesday, January 26, 2016 11:01 AM To: 'Florian Gossin' ; pgsql-performance@postgresql.org Subject: RE: [PERFORM] Primary key index partially used From: pgsql-performance-ow...@postgresql.org<mailto:pgsql-performance-ow...@postgresql.org> [mailto:pgsq

Re: [PERFORM] Primary key index partially used

2016-01-26 Thread Igor Neyman
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Florian Gossin Sent: Tuesday, January 26, 2016 10:52 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] Primary key index partially used Hi all, I'm using PostgreSQL 9.4.5

[PERFORM] Primary key index partially used

2016-01-26 Thread Florian Gossin
Hi all, I'm using PostgreSQL 9.4.5 and I have a weird issue. I have the following three tables: visit ( nb bigint NOT NULL, CONSTRAINT visit_pkey PRIMARY KEY (nb) ) with ~ 750'000 rows invoice ( id bigint NOT NULL, CONSTRAINT invoice_pkey PRIMARY KEY (id) ) with ~ 3'000'000 rows visit_invo