Re: [GENERAL] A question about plans and multi-key pks

2015-05-01 Thread Tom Lane
Steve Rogerson writes: > Why does the plan come up with 67 rows, when by definition there can be at > most one as we are searching on the pk? The rowcount estimate is made by combining selectivities of the WHERE conditions; what you're seeing is a consequence of not having very good knowledge abo

[GENERAL] A question about plans and multi-key pks

2015-05-01 Thread Steve Rogerson
We have a table: sjr_local1db=# \d cons_refs Table "public.cons_refs" Column | Type | Modifiers ---++-- code | bigint | not null ... ref_type