CCI-MOC / hil

Hardware Isolation Layer, formerly Hardware as a Service
Apache License 2.0
24 stars 54 forks source link

Optimize postgres to make it run slightly faster #1013

Closed naved001 closed 6 years ago

naved001 commented 6 years ago

This patch modifies the postgres configuration file and then restarts the postgres server.

Locally this made a significant difference, but in Travis it only seems to save a minute or so. I don't know if it's worth it, but we can discuss if we want this or not.

Anybody want to test this locally too (so that we can be sure that there isn't something else going on in my local environment).

ianballou commented 6 years ago

I didn't see a significant speedup (~10 seconds) running these tests locally on my laptop, but I think it's a good idea to reduce overhead regardless

Edit: I am running Postgres 9.5

naved001 commented 6 years ago

I wonder what impact putting the database in /tmp would have; this would prevent it from needing to hit the disk at all.

Should we look into that before merging this?

zenhack commented 6 years ago

I think we can leave it as future work.

ianballou commented 6 years ago

Just need a rebase here.

naved001 commented 6 years ago

rebased

zenhack commented 6 years ago

Looks like there's a cert error on the openstack servers.

ianballou commented 6 years ago

@zenhack we're currently fixing that up