Re: SSI patch version 8

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: SSI patch version 8
Дата
Msg-id
4D2EBF950200002500039483@gw.wicourts.gov
Ответ на
Re: SSI patch version 8 (Heikki Linnakangas)
Список
Дерево обсуждения
SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 David Fetter <david@fetter.org>
Re: SSI patch version 8 Anssi Kääriäinen <anssi.kaariainen@thl.fi>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 Anssi Kääriäinen <anssi.kaariainen@thl.fi>
SSI patch version 10 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 Anssi Kääriäinen <anssi.kaariainen@thl.fi>
Re: SSI patch version 8 Anssi Kääriäinen <anssi.kaariainen@thl.fi>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SSI patch version 8 "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Heikki Linnakangas  wrote:
> where exactly is the extra overhead coming from?
Keep in mind that this is a sort of worst case scenario.  The data
is fully cached in shared memory and we're doing a sequential pass
just counting the rows.  In an earlier benchmark (which I should
re-do after all this refactoring), random access queries against a
fully cached data set only increased run time by 1.8%.  Throw some
disk access into the mix, and the overhead is likely to get lost in
the noise.
But, as I said, count(*) seems to be the first thing many people try
as a benchmark, and this is a symptom of a more general issue, so
I'd like to find a good solution.
-Kevin

В списке pgsql-hackers по дате отправления
От: Kevin Grittner
Дата:
Сообщение: Re: SSI patch version 8
От: Heikki Linnakangas
Дата:
Сообщение: Re: SSI patch version 8
FAQ