Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DE5C837C759 for ; Tue, 30 Sep 2008 12:44:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63096-02 for ; Tue, 30 Sep 2008 12:44:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from viefep15-int.chello.at (viefep18-int.chello.at [213.46.255.22]) by postgresql.org (Postfix) with ESMTP id BA44237C754 for ; Tue, 30 Sep 2008 12:44:06 -0300 (ADT) Received: from edge01.upc.biz ([192.168.13.236]) by viefep15-int.chello.at (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20080930154404.HQNL26988.viefep15-int.chello.at@edge01.upc.biz> for ; Tue, 30 Sep 2008 17:44:04 +0200 Received: from [192.168.1.103] ([89.134.230.13]) by edge01.upc.biz with edge01 id M3js1a00z0Hzgy1013jtQw; Tue, 30 Sep 2008 17:44:04 +0200 X-SourceIP: 89.134.230.13 Message-ID: <48E24938.4010704@shopzeus.com> Date: Tue, 30 Sep 2008 17:43:52 +0200 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to specify fillrate after pg_restore? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.125 tagged_above=0 required=5 tests=DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: ** X-Archive-Number: 200809/352 X-Sequence-Number: 30445 Hello, I've been reading previous posts and I think I have some tables in my database that would better be stored with fillfactor=90 or less. We are going to upgrade and reinstall our server soon. I thought this would be a good time to change fillfactor. Just I don't know how. First I need to dump the old database with pg_dump. Then I need to restore it on the new server with pg_restore. What will this do? ALTER TABLE tbl SET FILLFACTOR = 90; Will it restucture the table, or is it just a setting and I should perform a VACUUM to actually reach fillfactor=90? Thanks, Laszlo