Re: Heavy contgnous load

From: kzsolt <kzsoltkzsolt(at)freemail(dot)hu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Heavy contgnous load
Date: 2011-11-09 19:48:13
Message-ID: 1320868093111-4978893.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2011-11-09 19:50:28 Re: Subquery in a JOIN not getting restricted?
Previous Message Greg Smith 2011-11-09 16:06:46 Re: WAL partition filling up after high WAL activity