From: Peter Eisentraut <peter_e@gmx.net>
To: Manasi Save <manasi.save@artificialmachines.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: using bytea data type
Date: Sat, 04 Dec 2010 17:51:03 +0200
Message-ID: <1291477863.3568.0.camel@vanquo.pezone.net> (raw)
In-Reply-To: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com>
References: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, manasi.save@artificialmachines.com
Subject: Re: using bytea data type
In-Reply-To: <1291477863.3568.0.camel@vanquo.pezone.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox