On 03/25/2015 07:30 AM, ginkgo36 wrote:
@Gary I'm working on big data, because of the demands of the job so I export/import/update data on this table every day. I guess it's possible that each query would need all 417 columns but it seems unlikely... --> Yes, not at all but 2/3 of 417 columns :)
There is also the matter of the 34 indexes, which can thought of as 34 axillary tables that need to be kept in sync with the main table.
I need gather data into one table for consistency and easy for export and import, it's ok if I split data to smaller tables, but when export/import/update, i must excute query on alot of table. And this way lead data to inconsistency if I forget update/export/import on 1 or more table. It is terrible. @John I will learing about it. Thanks alot. @All: If you have any suggestion, please let me known. Thanks for you help
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
