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.
