From: Manasi Save <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
Message-ID: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com> (raw)
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
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: manasi.save@artificialmachines.com
Subject: Re: using bytea data type
In-Reply-To: <20101202064246.0034uod2cif4w0so@mail.artificialmachines.com>
* 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