Ask HN: Is it a good idea putting PostgreSQL inside container?

https://news.ycombinator.com/item?id=9633656

by tuyguntn • 11 years ago

4 4 11 years ago

news.ycombinator.com

most of the performance tips include putting PostgreSQL (or any DB) outside the application server, but is it a good idea to deploy PG inside OpenVZ/Docker containers in one server? And what is the your best performance tips/links for tuning PG. Most of the articles advise using XFS for PG, how does it compares to EXT4 in SSD vs XFS in SSD

elchief• 11 years ago

Christ, why?

Containers are slower and less secure than bare metal. If you're using a puny database, use SQLite.

If you're using a real database, it should be on its own computer, in its own physical network segment, on a real OS, with no other services running.

tuyguntn• 11 years ago

Because I have one server and I should utilize it as much as possible but trying to minimize performance trade-off.

lstrope• 11 years ago

Time is money. How much time are you willing to spend to make this work?

I'd spend the "time" on another dedicated box.

walterbell• 11 years ago

No containers. No virtual machines without hardware passthrough.

If you have a server where the bios and hardware support VT-d/IOMMU, you can run the database in a Xen or VMware ESX VM which has a dedicated storage controller and optional dedicated NIC, via PCI passthrough to the VM. Probably a good idea to dedicate some CPU cores to that VM.

Ask HN: Is it a good idea putting PostgreSQL inside container?

Related Stories