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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
