Current server has the performance issue of spatial filtering on PostGIS with large dataset. Based on simple testing, upgrading the server helps the performance.
test sql: select * from hzbuilding_tmp2 where intersect(wkb_geometry, geomfromtext('MULTIPOLYGON(......)', 4326)
hzbuilding_tmp2: 375958 points (rows; TN bulidings)
current server(maeviztestbx1): about 77 sec.
Shawn's machine (eeyore): about 29 sec.