Horton

Re: [WIP] Zipfian distribution in pgbench

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Alik Khilazhev <a.khilazhev@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-07-07T19:59:56Z
Lists: pgsql-hackers 
Peter Geoghegan wrote:

> Here is the query:
> 
> with recursive index_details as (
>   select
>     'pgbench_accounts_pkey'::text idx
> ), [...]

Hmm, this seems potentially very useful.  Care to upload it to
https://wiki.postgresql.org/wiki/Category:Snippets ?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

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