X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 6D69F9DCBD7
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  3 Dec 2005 17:29:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 78686-07
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  3 Dec 2005 17:29:21 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47])
	by postgresql.org (Postfix) with ESMTP id A30D49DCBAF
	for <pgsql-performance@postgresql.org>;
	Sat,  3 Dec 2005 17:29:22 -0400 (AST)
Received: from 172.16.1.26 by mail.Mi8.com with ESMTP (- Welcome to Mi8
	Corporation www.Mi8.com (D1)); Sat, 03 Dec 2005 16:29:11 -0500
X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774
Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by
	D01HOST01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Sat, 3 Dec
	2005 16:29:02 -0500
Received: from 138.9.25.91 ([138.9.25.91]) by MI8NYCMAIL06.Mi8.com (
	[172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com (
	[172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Sat, 3 Dec
	2005 21:29:01 +0000
User-Agent: Microsoft-Entourage/11.2.1.051004
Date: Sat, 03 Dec 2005 13:29:01 -0800
Subject: Re: Database restore speed
From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
cc: "Stephen Frost" <sfrost@snowman.net>, "David Lang" <dlang@invendra.net>,
	"Steve Oualline" <soualline@stbernard.com>,
	pgsql-performance@postgresql.org
Message-ID: <BFB74E1D.14FE4%llonergan@greenplum.com>
Thread-Topic: [PERFORM] Database restore speed
Thread-Index: AcX4SLi6X8mqbN8iT72BA9fyqJfGrgAB9sLS
In-Reply-To: <2404.1133641940@sss.pgh.pa.us>
MIME-Version: 1.0
X-OriginalArrivalTime: 03 Dec 2005 21:29:02.0819 (UTC)
	FILETIME=[94D81B30:01C5F850]
X-WSS-ID: 6F8CD1944PK899018-01-01
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=1.253 required=5 tests=[RCVD_NUMERIC_HELO=1.253]
X-Spam-Score: 1.253
X-Spam-Level: *
X-Archive-Number: 200512/105
X-Sequence-Number: 15926

Tom,

On 12/3/05 12:32 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> "Luke Lonergan" <llonergan@greenplum.com> writes:
>> Last I looked at the Postgres binary dump format, it was not portable or
>> efficient enough to suit the need.  The efficiency problem with it was that
>> there was descriptive information attached to each individual data item, as
>> compared to the approach where that information is specified once for the
>> data group as a template for input.
> 
> Are you complaining about the length words?  Get real...

Hmm - "<sizeof int><int>" repeat, efficiency is 1/2 of "<int>" repeat.  I
think that's worth complaining about.

- Luke