Re: Adding a pgbench run to buildfarm

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Adding a pgbench run to buildfarm
Дата
Msg-id 44C44B92.4010706@paradise.net.nz
обсуждение исходный текст
Ответ на Re: Adding a pgbench run to buildfarm  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Adding a pgbench run to buildfarm  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Adding a pgbench run to buildfarm  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-hackers
Tom Lane wrote:
> "Bort, Paul" <pbort@tmwsystems.com> writes:
>> Andrew said I should solicit opinions as to what parameters to use. A
>> cursory search through the archives led me to pick a scaling factor of
>> 10, 5 users, and 100 transactions.
> 
> 100 transactions seems barely enough to get through startup transients.
> Maybe 1000 would be good.
> 

Scale factor 10 produces an accounts table of about 130 Mb. Given that 
most HW these days has at least 1G of ram, this probably means not much 
retrieval IO is tested (only checkpoint and wal fsync). Do we want to 
try 100 or even 200? (or recommend scale factor such that size > ram)?

Cheers

Mark


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: why toast tables are not reindexed while clustering?
Следующее
От: "Bort, Paul"
Дата:
Сообщение: Re: Adding a pgbench run to buildfarm