Re: join on three tables is slow

Hello

1) increase statistics on res_partner_address.type (about 100)

alter table ...
ALTER [ COLUMN ] column SET STATISTICS integer

do analyze, and look again on plans. There are difference

-> Seq Scan on res_partner_address a (cost=0.00..88.40
rows=16 width=552) (actual time=0.106..3.521 rows=559 loops=510)
Filter: ((("type")::text = 'default'::text) OR ("type" IS
NULL))

2) I thing so index on res_partner.addr can help or use better column
for identification (varchar isn't best) and partial index

rep_partner_address.type is 'default' or resp_partner_address.type is null.

Regards
Pavel Stehule