n0derunner

    Postgres pgbench scale-factors and WSS

    Published: (Updated: ) in Postgres, , by gary.

    Scale factor to workingset size lookup for tiny databases

    Scale Factor      Working Set Size
1                 23M
10                157M
100               1.7GB
1000              15GB
2500              37GB
5000              74GB
10000             147GB

    Comments

    Leave a Comment