From: Domenico - Sal. F.lli Riva <domenico.mozzanica@fratelliriva.it>
To: pgsql-performance@postgresql.org
Subject: pgsql_tmp and postgres settings
Date: Fri, 9 Jun 2006 14:23:04 +0200
Message-ID: <20060609122948.6B7419FA621@postgresql.org> (raw)
Hello,
During insert or update, potgresql write in pgsql_tmp directory and so
performance are very poor.
My configuration is:
Work mem 10240
Effective_cache_size 30000
Shared buffers 9000
Max_fsm_pages 35000
Wal Buffers 24
Autovacuum on
Manual vacuum analyze and vacuum full analyze every day
Server:
1 Xeon processor
2500 MB ram
Red Hat Enterprise ES 3
Postgresql (RPM from official website) 8.1.0
Tables are vacuumed frequently and now fsm is very low (only 3000 pages).
Updates and inserts on this database are infrequent, and files to import
aren't so big (7-50 Mb for 2000-20000 record in a txt file).
On this server are installed and active also Apache - Tomcat - Java 1.4.2
which provide data to import.
Tables interested have only max 4 index.
Are parameters adapted?
Thanks
Domenico Mozzanica
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: domenico.mozzanica@fratelliriva.it
Subject: Re: pgsql_tmp and postgres settings
In-Reply-To: <20060609122948.6B7419FA621@postgresql.org>
* 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