Date: Fri, 4 Nov 2011 14:35:57 -0700 (PDT)
From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Message-ID: <1320442557073-4965371.post@n5.nabble.com>
In-Reply-To: <1319141411977-4922748.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>
Subject: Re: Heavy contgnous load
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Looks like I found more magic.

My table is: each record near 1kbyte, contain dozen col some text some
numeric, some of the numeric columns are indexed. The database located at
ramdisk (tmpfs) ((I hope)). The table is contignously filled with rows.

If the table has less than 4Mrec then looks like everythink is fine.
But near at 6Mrec the CPU load is go to very high and even the COUNT(*) need
8sec executing time (1sec/Mrec). The insert is slowing down too. 
But more stange if I try to search a record by indexed col then the server
bring up it very quick!

My server config is:
/
max_connections  = 24
shared_buffers  = 256MB
log_destination = 'stderr'              # Valid values are combinations of
logging_collector  = true
silent_mode = on                        # Run server silently.
log_line_prefix = '%t %d %u '
datestyle = 'iso, ymd'
lc_messages = 'hu_HU'                   # locale for system error message
lc_monetary = 'hu_HU'                   # locale for monetary formatting
lc_numeric = 'hu_HU'                    # locale for number formatting
lc_time = 'hu_HU'                               # locale for time formatting
default_text_search_config = 'pg_catalog.hungarian'
port = 9033
unix_socket_directory = standard disk
log_directory = standard disk
log_filename = 'sqld.log'
effective_cache_size = 8MB
checkpoint_segments = 16
synchronous_commit = off
/

Any idea how it possible to increase the performance?


--
View this message in context: http://postgresql.1045698.n5.nabble.com/Heavy-contgnous-load-tp4913425p4965371.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.