robinhood icon indicating copy to clipboard operation
robinhood copied to clipboard

Enhancement: PostgreSQL support in RHPE

Open azet opened this issue 12 years ago • 3 comments

PostgreSQL support (wrapper and headers) would be greatly appreciated in conjunction with this project.

Is anyone planning on implementing support or other users interested in it?

azet avatar Mar 25 '13 23:03 azet

We started to do a quick port to postgresql (for testing purpose, not fully functionnal) a few months ago. We cancelled it as the performance was significantly lower than MySQL.

tl-cea avatar Jun 18 '13 06:06 tl-cea

Interesting, in my experience Postgres outperforms MySQL in most cases, did you do Postgres and DB tuning? (see: http://www.amazon.com/books/dp/184951030X)

azet avatar Jun 18 '13 09:06 azet

Some caching parameters have been tuned for the testing: shared_buffers = 2GB work_mem = 512MB

tl-cea avatar Jun 19 '13 07:06 tl-cea