I try to found out more information. Looks like the COUNT(*) is not the
strongest part of pgr therfore I do a worakround. After this I have the
folwing result:
Below the 1Mrec the row insert time is ~23msec. Above the 7Mrec the insert
time is ~180msec.
I belive I use the fastest index type (default).
So any idea to make postgres faster at higher number of records?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Heavy-contgnous-load-tp4913425p4978893.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.