Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5C6B81337B53 for ; Sat, 4 Dec 2010 11:51:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55552-07 for ; Sat, 4 Dec 2010 15:51:07 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id B30261337B47 for ; Sat, 4 Dec 2010 11:51:06 -0400 (AST) Received: (qmail invoked by alias); 04 Dec 2010 15:51:04 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp006) with SMTP; 04 Dec 2010 16:51:04 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/Urmg1Z9DUfgeszbSTeZ3TRr/Fo8nLdu4JhBQIV9 ScI7AtIIF9OS0c Subject: Re: using bytea data type From: Peter Eisentraut To: Manasi Save Cc: "pgsql-admin@postgresql.org" In-Reply-To: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com> References: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com> Content-Type: text/plain; charset="UTF-8" Date: Sat, 04 Dec 2010 17:51:03 +0200 Message-ID: <1291477863.3568.0.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/33 X-Sequence-Number: 36262 On tor, 2010-12-02 at 06:42 -0500, Manasi Save wrote: > Can anyone provide me any input using the bytea data type for storing binary data provides how much benefit on performance as I have millions rows in a table using bytea data type also it is index. So how indexing really works on bytea columns? Benefit relative to what alternative? > As I have read in some forum mentioning that one should not use bytea data type. That sounds like nonsense to me.