pgsql_tmp and postgres settings

["Domenico - Sal. F.lli Riva" <domenico(dot)mozzanica(at)fratelliriva(dot)it>]

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