Connection incredibly slow
For a <100MB db, with <100 tables and approx. 1000 stored procedures (procedures are mostly coming from postgis, geometry, and other default functions, only 7% of the procedures are custom):
Connection string used:
massive.connect is being called before each request, passing that string as connection string.
index.js) is being called every time as well as
This is performed from localhost, measured with
console.timeEnd, and using pg.connect is almost instantaneous.
Am I missing something?
Extensions being used:
postgis_topology, postgis, plv8, plpgsql, topology, fuzzystrmatch