Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Zero freshness score for PostgreSQL-SR 14 #5

Open
Rucchao opened this issue Jul 14, 2023 · 0 comments
Open

Zero freshness score for PostgreSQL-SR 14 #5

Rucchao opened this issue Jul 14, 2023 · 0 comments

Comments

@Rucchao
Copy link

Rucchao commented Jul 14, 2023

Hi there!

I try to reproduce the paper results for the freshness evaluation over PG 14 with streaming replication. As stated in the paper, PG-SR could have up to 5 seconds over SF10. However, I currently always got zero freshness. I tried to increase the ac and tc to 100 but had been in vain.

Did I do something wrong? I used the following benchmarking command with synchronous_commit="on":

./HATtrickBench -run -dsn hattrick1 -dsn2 hattrick2 -usr userName -pwd Password -wd 180 -td 360 -ac 100 -tc 100 -db postgres -t sp

Note that hattrick1 is the primary node and hattrick2 is the secondary node.

Any comments would be appreciated!

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant