Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 9ECBD1337BBA
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  2 Dec 2010 07:42:54 -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 49969-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  2 Dec 2010 11:42:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail9c40.carrierzone.com (mail9c40.carrierzone.com
	[209.235.156.149])
	by mail.postgresql.org (Postfix) with ESMTP id 4ECFC1337BB7
	for <pgsql-admin@postgresql.org>; Thu,  2 Dec 2010 07:42:47 -0400 (AST)
Received: from mail9c40.carrierzone.com (localhost [127.0.0.1])
	by mail9c40.carrierzone.com (8.13.6/8.13.1) with ESMTP id
	oB2BgkAc017364
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <pgsql-admin@postgresql.org>; Thu, 2 Dec 2010 11:42:46 GMT
Received: (from webmail@localhost)
	by mail9c40.carrierzone.com (8.13.6/8.12.2/Submit) id oB2BgkRZ017363
	for pgsql-admin@postgresql.org; Thu, 2 Dec 2010 06:42:46 -0500
Received: from NSG-Static-074.18.72.182.airtel.in
	(NSG-Static-074.18.72.182.airtel.in [182.72.18.74]) by
	mail.artificialmachines.com (Webmail 5.0 V.V.I.) with HTTP for
	<manasi.save.artificialmachines.com@mail.artificialmachines.com>;
	Thu, 02 Dec 2010 06:42:46 -0500
Message-ID: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com>
From: "=?utf-8?b?TWFuYXNpIFNhdmU=?=" <manasi.save@artificialmachines.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: using bytea data type
Date: Thu, 02 Dec 2010 06:42:46 -0500
X-Priority: 3
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_5l4hc78v66m8"
Content-Transfer-Encoding: 7bit
User-Agent: Webmail 6.0
X-CSC: 0
X-CHA: v=1.1 cv=f2jdeUv9H40Onc9sxnhJMSck38AK3qdDSK3oOCRZMwE= c=1 sm=1
	a=6mBWwJEmJT4fWEzs4ffimg==:17 a=3BIiMC4AYkFOw27kzEkA:9
	a=jbSTTtSRjGhtKknUutUA:7 a=wENWFIXQWS_kldpJjLVKtOfG9M4A:4
	a=QEXdDO2ut3YA:10
	a=BTi3az9P9ezAO_0G1vcA:9 a=OygyPf02Qx8C49gCQE-snyIJeg0A:4
	a=WkljmVdYkabdwxfqvArNOQ==:117
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.92 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	FROM_EXCESS_BASE64=0.979, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201012/18
X-Sequence-Number: 36247

This message is in MIME format. 

--=_5l4hc78v66m8
Content-Type: text/plain;
	charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi All,

I have a postgresql database which has many columns in different tables with bytea data type. 

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?

As I have read in some forum mentioning that one should not use bytea data type. I really need to make my database really pro-efficient as right now I am facing major database performance issue. 

any input will be a great help. 

Thanks in advance. 

Regards,
Manasi


--=_5l4hc78v66m8
Content-Description: HTML Version of Message
Content-Type: text/html;
	charset=UTF-8
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 5sl3n9momi9s@mail.artificialmachines.com

Hi All,<br />
&nbsp;<br />
I have a postgresql database which has many columns in different tables with
bytea data type.&nbsp;<br />
&nbsp;<br />
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?<br />
&nbsp;<br />
&nbsp;<br />
As I have read in some forum mentioning that one should not use bytea data type. 
I really need to make my database really pro-efficient as right now I am facing
major database performance issue.<br />
&nbsp;<br />
any input will be a great help.<br />
&nbsp;<br />
Thanks in advance.<br />
&nbsp;<br />
Regards,<br />
Manasi<br />
&nbsp;<br />
--=_5l4hc78v66m8--