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