X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 222AF9FA634 for ; Fri, 9 Jun 2006 09:29:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25954-04 for ; Fri, 9 Jun 2006 09:29:48 -0300 (ADT) X-Greylist: delayed 00:06:35.682059 by SQLgrey- Received: from grinbox.salriva (host77-191.pool8172.interbusiness.it [81.72.191.77]) by postgresql.org (Postfix) with SMTP id 6B7419FA621 for ; Fri, 9 Jun 2006 09:29:48 -0300 (ADT) Received: (qmail 5092 invoked from network); 9 Jun 2006 12:23:06 -0000 Received: from unknown (HELO PC14) (192.168.1.14) by 192.168.1.254 with SMTP; 9 Jun 2006 12:23:06 -0000 Reply-To: From: "Domenico - Sal. F.lli Riva" To: Subject: pgsql_tmp and postgres settings Date: Fri, 9 Jun 2006 14:23:04 +0200 Organization: Salumificio F.lli Riva S.p.A. MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcaLvmhLMQ2vaugQRRWudHRUm0t0LgAAMa9w X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) Message-Id: <20060609122948.6B7419FA621@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/109 X-Sequence-Number: 19466 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