| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Manasi Save <manasi(dot)save(at)artificialmachines(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: using bytea data type |
| Date: | 2010-12-04 15:51:03 |
| Message-ID: | 1291477863.3568.0.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Imre Oolberg | 2010-12-05 22:29:10 | failing to compile v. 9.0.1 on debian squeeze with readline |
| Previous Message | Kevin Grittner | 2010-12-04 15:01:11 | Re: [ADMIN] syntax error for no apparent reason |