| From: | Manasi Save <manasi(dot)save(at)artificialmachines(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | using bytea data type |
| Date: | 2010-12-02 11:42:46 |
| Message-ID: | 20101202064246.0034uod2cif4w0so@mail.artificialmachines.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anibal David Acosta | 2010-12-02 12:02:40 | Re: [GENERAL] How to recover a postgres installation from files |
| Previous Message | Radosław Smogura | 2010-12-02 11:22:20 | Re: [GENERAL] How to recover a postgres installation from files |