X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75183D1B4A6 for ; Fri, 2 Jan 2004 14:43:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44686-10 for ; Fri, 2 Jan 2004 10:42:40 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id E4E09D1B4CE for ; Fri, 2 Jan 2004 10:42:30 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i02EgS19005631; Fri, 2 Jan 2004 09:42:28 -0500 (EST) To: =?iso-8859-15?q?Herv=E9=20Piedvache?= Cc: pgsql-performance@postgresql.org Subject: Re: Why memory is not used ? Why vacuum so slow ? In-reply-to: <200401021042.57714.herve@elma.fr> References: <200401021042.57714.herve@elma.fr> Comments: In-reply-to =?iso-8859-15?q?Herv=E9=20Piedvache?= message dated "Fri, 02 Jan 2004 10:42:57 +0100" Date: Fri, 02 Jan 2004 09:42:28 -0500 Message-ID: <5630.1073054548@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/7 X-Sequence-Number: 5182 =?iso-8859-15?q?Herv=E9=20Piedvache?= writes: > Second point ... after importing my dump ... I make a vacuum full analyze of > my base (in same time because of my caculation of the day before for my > aggregats and stats tables about 200 000 row deleted and/or inserted for more > than 20 tables (each)) ... but It takes about 5 hours ... Don't do vacuum full. You should not need it in ordinary circumstances, if you are doing plain vacuums on a reasonable schedule and you have the FSM parameters set high enough. (You do not BTW ... with 175000 pages in this table alone, 10000 FSM pages for the whole database is surely too low.) regards, tom lane