X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CF00AD1D108 for ; Sun, 7 Mar 2004 01:32:09 +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 58537-08 for ; Sat, 6 Mar 2004 21:32:10 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 7346ED1D779 for ; Sat, 6 Mar 2004 21:32:06 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bob.samurai.com (Postfix) with ESMTP id 81FE21D99; Sat, 6 Mar 2004 20:32:09 -0500 (EST) Received: from bob.samurai.com ([127.0.0.1]) by localhost (bob.samurai.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 17502-01-7; Sat, 6 Mar 2004 20:32:09 -0500 (EST) Received: from samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by bob.samurai.com (Postfix) with ESMTP id 7C8A61D8A; Sat, 6 Mar 2004 20:32:08 -0500 (EST) Message-ID: <404A7B98.7090401@samurai.com> Date: Sat, 06 Mar 2004 20:32:08 -0500 From: Neil Conway User-Agent: Mozilla Thunderbird 0.5 (X11/20040304) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mike Nolan Cc: Rod Taylor , Josh Berkus , Bill Moran , Jeff , Postgresql Performance Subject: Re: Fixed width rows faster? References: <200403070116.i271GWPS005869@gw.tssi.com> In-Reply-To: <200403070116.i271GWPS005869@gw.tssi.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/80 X-Sequence-Number: 5936 Mike Nolan wrote: > Is there a way to copy a table INCLUDING the check constraints? If not, > then that information is lost, unlike varchar(n). "pg_dump -t" should work fine, unless I'm misunderstanding you. -Neil