Home / server / Questions / 450890
Accepted
orokusaki
Asked: 2012-11-22 07:09:25 +0800 CST

What is the most efficient way to connect my application on one VM to my Postgres DB on another VM?

  • 772

I have 1 physical machine with 2 VMs (VMWare esxi) - one for database (PostgreSQL 9.2.1), and one for application. I'd like my application to connect to my database in an efficient way, and I've heard that using a file system socket is more efficient than a network socket (TCP overhead, IIRC).

  1. Is there a way to use a file system socket with the aforementioned setup? Or...
  2. Is there another, efficient connection method you'd recommend?
virtual-machines

1 Answers

  1. Best Answer

    1. No, file system sockets (formally Unix Domain Sockets) only work within the same operating system (and while it's technically true that they're more efficient than network sockets, it's a pretty small difference unless you're sending tons of tiny requests).

    2. TCP should work just fine here. If it doesn't after some testing, worry about it then. If you do have problems, they're more likely due to poor query design than the communication protocol between the application and server.

    • 4