network profile
| bio | website | |
|---|---|---|
| location | Paris, France | |
| age | ||
| visits | member for | 1 year, 8 months |
| seen | Mar 13 at 7:57 | |
| stats | profile views | 1 |
|
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 |
