How to benchmark partition table performance

This blog is published on EDB website.

This blog briefs about the new pgbench options to partition the default pgbench table pgbench_accounts and discusses the outcome of OLTP point queries and ranged queries for the two partition types range and hash for various data sizes and partition counts.



at
Labels: , , , , , , ,

3 comments:

  1. Michael VitaleOctober 28, 2019 6:07 pm

    How can I get a copy of this version of pg_bench without waiting for PG 13?

    ReplyDelete
    Replies
    1. MBeena EmersonOctober 29, 2019 3:12 pm

      You can download from the postgres git repo and use the updated module for previous versions.

      Delete
  2. AnonymousOctober 29, 2019 3:48 pm

    Hi,
    you could compile it, or use community built packages like those available from https://wiki.postgresql.org/wiki/Apt/FAQ#Development_snapshots if running on *deb distributions.
    Anthony

    ReplyDelete

Subscribe to: Post Comments (Atom)