Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
4
Newest
 Supporter
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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