From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Heavy contgnous load
Date: Fri, 4 Nov 2011 14:35:57 -0700 (PDT)
Message-ID: <1320442557073-4965371.post@n5.nabble.com> (raw)
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>
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.
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: <1320442557073-4965371.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