Re: [HACKERS] lseek/read/write overhead becomes visible at scale ..

Поиск
Список
Период
Сортировка
Искать
От
Tobias Oberstein
Тема
Re: [HACKERS] lseek/read/write overhead becomes visible at scale ..
Дата
Msg-id
a7fc2477-d9d6-c695-b40a-76ad341562c9@gmail.com
Ответ на
Список
Дерево обсуждения
[HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Tobias Oberstein <tobias.oberstein@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Andres Freund <andres@anarazel.de>
Re: [HACKERS] lseek/read/write overhead becomes visible at scale .. Thomas Munro <thomas.munro@enterprisedb.com>
Hi,

>> Synthetic PG workload or real world production workload?
>
> Both might work, production-like has bigger pull, but I'd guess
> synthetic is good enough.

Thanks! The box should get PostgreSQL in the not too distant future. 
It'll get a backup from prod, but will act as new prod, so it might take 
some time until a job can be run and a profile collected.

>> So how would I do a perf profile that would be acceptable as prove?
>
> You'd have to look at cpu time, not number of syscalls.  IIRC I
> suggested doing a cycles profile with -g and then using "perf report
> --children" to see how many cycles are spent somewhere below lseek.

Understood. Either profile manually or expand the function.

> I'd also suggest sharing a profile cycles profile, it's quite likely
> that the overhead is completely elsewhere.

Yeah, could be. It'll be interesting to see for sure. I should get a 
chance to collect such profile and then I'll post it back here -

/Tobias



В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата:
От: Nikita Glukhov
Дата:
FAQ