Re: updates way slower than selects?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: updates way slower than selects?
Дата
Msg-id 4393.987179446@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: updates way slower than selects?  (Marek Pętlicki <marpet@buy.pl>)
Ответы Re: updates way slower than selects?  (Marek Pętlicki <marpet@buy.pl>)
Список pgsql-general
> I've got a question: has anybody noticed in your production
> tables, that updates on existing rows take longer than inserts
> into those same tables?

Updates naturally take longer than inserts.  Especially if you haven't
provided an index that allows the row(s) to be updated to be found
easily.  Have you checked the EXPLAIN results for your problem queries?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Repairing bad table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question about SELECT FOR UPDATE in transaction, isolation level