pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

using bytea data type
2+ messages / 2 participants
[nested] [flat]

* using bytea data type
@ 2010-12-02 11:42  Manasi Save <manasi.save@artificialmachines.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Manasi Save @ 2010-12-02 11:42 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: using bytea data type
@ 2010-12-04 15:51  Peter Eisentraut <peter_e@gmx.net>
  parent: Manasi Save <manasi.save@artificialmachines.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2010-12-04 15:51 UTC (permalink / raw)
  To: Manasi Save <manasi.save@artificialmachines.com>; +Cc: pgsql-admin

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-12-04 15:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-02 11:42 using bytea data type Manasi Save <manasi.save@artificialmachines.com>
2010-12-04 15:51 ` Peter Eisentraut <peter_e@gmx.net>

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