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

Performance problem #20

Closed
Serob opened this issue Jan 19, 2017 · 1 comment
Closed

Performance problem #20

Serob opened this issue Jan 19, 2017 · 1 comment

Comments

@Serob
Copy link

Serob commented Jan 19, 2017

Is it normal that inserting a single two-column line in a redis_fdw scalar/hash table lasts much longer than in a regular Postgres table (in average 0.6 ms vs 0.06 ms) while ram is nearly free? Almost the same situation with reading. I thought that read/write actions in in-memory database should take less (or equal) time than in Postgres (which is true for direct access) . But benchmarks show opposite!
What can cause such behavior?

My system is Ubuntu 14, Postgres 9.3, Redis 2.8.4
RAM 3GB,
Processor 4 core 2.3 GHz
HDD SATA2 with below average speed

@adunstan
Copy link
Member

There is the redis connection overhead. Also, PostgreSQL also caches tables in memory (shared_buffers). So this is not necessarily surprising.

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

2 participants