PostgreSQL 11.22 Documentationimplicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2732 页 | 12.44 MB | 1 年前3- PostgreSQL 14.10 Documentationthe optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A similar behavior can also be approximated with hash:0 码力 | 3032 页 | 13.27 MB | 1 年前3
- PostgreSQL 14.10 Documentationthe optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A similar behavior can also be approximated with hash:0 码力 | 2871 页 | 13.38 MB | 1 年前3
- PostgreSQL 13.13 Documentationimplicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2782 页 | 13.00 MB | 1 年前3
- PostgreSQL 12.17 Documentationimplicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2786 页 | 12.72 MB | 1 年前3
- PostgreSQL 11.22 Documentationparameter comes in handy: 1980 pgbench \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2883 页 | 12.34 MB | 1 年前3
- PostgreSQL 12.17 Documentationimplicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2943 页 | 12.61 MB | 1 年前3
- PostgreSQL 13.14 Documentationimplicit seed parameter comes in handy: \set k1 abs(hash(:r, :default_seed + 123)) % 1000000 \set k2 abs(hash(:r, :default_seed + 321)) % 1000000 As an example, the full definition of the built-in TPC-B-like0 码力 | 2940 页 | 12.89 MB | 1 年前3
- PostgreSQL 16.1 Documentationthe optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A similar behavior can also be approximated with hash:0 码力 | 3133 页 | 14.10 MB | 1 年前3
- PostgreSQL 16.1 Documentationthe optional seed parameter comes in handy: \set k1 1 + permute(:r, :size, :default_seed + 123) \set k2 1 + permute(:r, :size, :default_seed + 321) A similar behavior can also be approximated with hash:0 码力 | 2974 页 | 14.22 MB | 1 年前3
共 14 条
- 1
- 2