| From: | ginkgo36 <ginkgo56(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | :Posgres - performance problem |
| Date: | 2015-03-25 09:19:58 |
| Message-ID: | 1427275198624-5843364.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sreerama Manoj | 2015-03-25 10:03:41 | reload shared_preload_libraries |
| Previous Message | Nicolas Paris | 2015-03-25 03:50:05 | Re: Load Data with COPY |