Re: updates way slower than selects?

Поиск
Список
Период
Сортировка
От Marek Pętlicki
Тема Re: updates way slower than selects?
Дата
Msg-id 20010408125530.B1578@marek.almaran.home
обсуждение исходный текст
Ответ на Re: updates way slower than selects?  (Doug McNaught <doug@wireboard.com>)
Ответы Re: updates way slower than selects?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Saturday, April, 2001-04-07 at 23:04:23, Doug McNaught wrote:
> Marek Pętlicki <marpet@linuxpl.org> writes:
>
> > Hi!
> >
> > 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?
>
> Standard first question: are you vacuuming?

this is a productio system running over half a year - yes it is
vacuumed every night. Additional question: is update speed on single
int4 value really dependant on vacuuming or are you just asking a
'standard question'?

regards and thanks

--
Marek Pętlicki <marpet@buy.pl>


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: strange query plan
Следующее
От: Justin Clift
Дата:
Сообщение: Re: [DOCS] Re: Better Features document?