Hi all, I have 1 table have: - 417 columns - 600.000 rows data - 34 indexs when i use query on this table, it so long. ex:
update master_items set temp1 = '' where temp1 <> '' --Query returned successfully: 435214 rows affected, 1016137 ms execution time. alter table master_items add "TYPE-DE" varchar default '' -- Query returned successfully with no result in 1211019 ms. update master_items set "feedback_to_de" = 'Yes' --Query returned successfully: 591268 rows affected, 1589335 ms execution time. Can you help me find any way to increase performance? Thanks all -- View this message in context: http://postgresql.nabble.com/Posgres-performance-problem-tp5843364.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
