> The following query takes about 4s to run in a 16GB ram server. Any ideas > why it doesn´t use index for the primary keys in the join conditions?Maby random_page_cost is set too high? What version are you using?
-- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных