Re: Using COPY FREEZE in pgbench
| От | Fabien COELHO |
|---|---|
| Тема | Re: Using COPY FREEZE in pgbench |
| Дата | |
| Msg-id | alpine.DEB.2.22.394.2103220844370.2898300@pseudo обсуждение исходный текст |
| Ответ на | Re: Using COPY FREEZE in pgbench (Tatsuo Ishii <ishii@sraoss.co.jp>) |
| Список | pgsql-hackers |
Hello Tatsuo-san, > 13.2 pgbench + master branch server: > done in 15.47 s (drop tables 0.19 s, create tables 0.01 s, client-side generate 9.07 s, vacuum 2.07 s, primary keys 4.13s). > > With patch on master branch: > done in 13.38 s (drop tables 0.19 s, create tables 0.01 s, client-side generate 9.68 s, vacuum 0.23 s, primary keys 3.27s). Yes, this is the kind of figures I got on my laptop. > This time current pgbench performs much faster than I wrote (15.47 s vs. > 70.78 s). I don't why. Duno. > Anyway, this time total pgbench time is reduced by 14% over all > here. I hope people agree that the patch is worth the gain. Yes, because (1) why not take +10% and (2) it exercises an option. -- Fabien.
В списке pgsql-hackers по дате отправления: