UPDATE

Поиск
Список
Период
Сортировка
От c k
Тема UPDATE
Дата
Msg-id d8e7a1e30902190515s3dc3e8fh6d1aec08fba865eb@mail.gmail.com
обсуждение исходный текст
Ответы Re: UPDATE  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
I am using PG on windows for development. While testing some queries I found that updates are much slower as compared to other database systems. (On avarage MySQL updates 4-5 times faster than PG in a single unique index on primary key) Why?
Another thing that I noticed is when any single column in a table is updated and having no index many (in my case 7) indexes on different columns, It takes about 180-200 secs. But when any single column in a table is updated and having many (in my case 7) indexes on different columns, but does not have index on the column that is being updated, It takes about 800-900 secs. Why?
What can be done for such updates to make them faster?
Thanks
CPKulkarni

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: \l of psql 8.4 looks ... unreadable on 80char default
Следующее
От: Harald Armin Massa
Дата:
Сообщение: Re: \l of psql 8.4 looks ... unreadable on 80char default