28 reputation
4
bio website
location Paris, France
age
visits member for 3 years, 2 months
seen Sep 3 at 20:18

Jan
30
awarded  Supporter
Jan
30
awarded  Teacher
Jan
30
answered Tilemill label and Shield are overlapping, how can this be solved?
Feb
14
awarded  Scholar
Feb
14
accepted Enhance performance of a join query for mapnik using postgis
Feb
14
comment Enhance performance of a join query for mapnik using postgis
As Nickas said it, the main issue comes from the seq scan of the table2 even if there is an index on this table. To solve this, I change the parameter random_page_cost to favor the index scan: ALTER TABLESPACE pg_global SET ( random_page_cost = 2, seq_page_cost=1); This solved my performance issue.
Feb
14
comment Enhance performance of a join query for mapnik using postgis
You're absolutely right, I just posted an answer here.
Feb
13
awarded  Student
Feb
13
asked Enhance performance of a join query for mapnik using postgis