Re: [HACKERS] [WIP] Zipfian distribution in pgbench

Alik Khilazhev <a.khilazhev@postgrespro.ru>

From: Alik Khilazhev <a.khilazhev@postgrespro.ru>
To: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: PostgreSQL Developers <pgsql-hackers@postgresql.org>
Date: 2017-11-19T19:53:52Z
Lists: pgsql-hackers

Attachments

Hello Fabien,

Sorry for not responding	for long time. 

> Two typos:
> - "usinng" -> "using"
> - "a rejection method used" -> "a rejection method is used"
> 
> I'm not sure of "least_recently_used_i", this naming style is not used in pgbench. "least_recently_used" would be ok.
> 
> "..nb_cells.. != ZIPF_CACHE_SIZE", ISTM that "<" is more logical,
> even if the result is the same?

Fixed.

> Maybe the cache overflow could be counted, to allow for a possible warning message in the final report?
Also done. But one question: Should it be done by printing to stdout or stderr ?

> When/if the pgbench tap test patch get through, coverage tests should
> be added.

I have added few tests and I am not sure if they OK or not. It was my first experience with perl and tests in PostgreSQL. 

Commits

  1. Add approximated Zipfian-distributed random generator to pgbench.