X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 81F149FB2E0 for ; Fri, 14 Jul 2006 04:05:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40888-08 for ; Fri, 14 Jul 2006 04:05:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx00.ext.bfk.de (mx00.ext.bfk.de [217.29.46.125]) by postgresql.org (Postfix) with ESMTP id 216909FB2A7 for ; Fri, 14 Jul 2006 04:05:45 -0300 (ADT) Received: from fweimer by bfk.de with local id 1G1Hjv-0005zv-RO; Fri, 14 Jul 2006 09:05:31 +0200 To: Greg Stark Cc: Tom Lane , "Steve McWilliams" , pgsql-performance@postgresql.org Subject: Re: size of pg_dump files containing bytea values References: <3985.10.1.1.126.1152729387.squirrel@portal.emprisanetworks.com> <1820.1152759205@sss.pgh.pa.us> <87k66hii11.fsf@stark.xeocode.com> From: Florian Weimer Date: Fri, 14 Jul 2006 09:05:31 +0200 In-Reply-To: <87k66hii11.fsf@stark.xeocode.com> (Greg Stark's message of "13 Jul 2006 12:30:50 -0400") Message-ID: <82k66g64zo.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/141 X-Sequence-Number: 20001 * Greg Stark: > Didn't byteas used to get printed as hex? No, they didn't. It would be useful to support hexadecimal BYTEA literals, though. Unfortunately, X'DEADBEEF' has already been taken by bit strings. -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Durlacher Allee 47 tel: +49-721-96201-1 D-76131 Karlsruhe fax: +49-721-96201-99