X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C6294D1B195 for ; Fri, 9 Jul 2004 23:52:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17194-03 for ; Sat, 10 Jul 2004 02:52:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2BF6DD1B1B3 for ; Fri, 9 Jul 2004 23:52:02 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i6A2q4rp002001; Fri, 9 Jul 2004 22:52:04 -0400 (EDT) To: "Missner, T. R." Cc: pgsql-performance@postgresql.org Subject: Re: inserting into brand new database faster than old database In-reply-to: References: Comments: In-reply-to "Missner, T. R." message dated "Wed, 07 Jul 2004 11:24:11 -0600" Date: Fri, 09 Jul 2004 22:52:04 -0400 Message-ID: <2000.1089427924@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/54 X-Sequence-Number: 7445 "Missner, T. R." writes: > ... Each day a brand new set of tables is > created and eventually the old tables are dropped. You did not say which PG version you are using (tut tut) but my first thought is that it's a pre-7.4 release and your problems trace to bloat in the system-catalog indexes. The indexes on pg_class and pg_attribute would be quite likely to suffer serious bloat if you continually create and drop tables, because the range of useful table OIDs will be continually shifting. We didn't fix this until 7.4. If you are seeing this in 7.4.* then more investigation is needed... regards, tom lane