pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Heavy contgnous load
Date: Wed, 9 Nov 2011 11:48:13 -0800 (PST)
Message-ID: <1320868093111-4978893.post@n5.nabble.com> (raw)
In-Reply-To: <1320442557073-4965371.post@n5.nabble.com>
References: <1318939765661-4913425.post@n5.nabble.com>
	<CAMkU=1yXGNzyFdAwzMVjJ11-P=Y-pF1cqjc2F1CtX7zRwrCyxQ@mail.gmail.com>
	<1319141411977-4922748.post@n5.nabble.com>
	<1320442557073-4965371.post@n5.nabble.com>

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.

view thread (11+ messages)  latest in thread

Message-ID: <1320868093111-4978893.post@n5.nabble.com>
Permalink:  ../1320868093111-4978893.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1320868093111-4978893.post@n5.nabble.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: kzsoltkzsolt@freemail.hu
  Subject: Re: Heavy contgnous load
  In-Reply-To: <1320868093111-4978893.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox