4 ms·

Wouldn't it still be over the network/IPC, unlike SQLite?

• unnouinceput 6y ago
  No. It will be internal port to port connection. And it also depends on the driver. You can definitely have a crappy SQLite driver for your obscure OS that can absolutely take a lot of time for those 200 queries.
  • jononor 6y ago
    It is still IPC (inter-process communication) even though it wont go over any network. Probably still order of magnitude more overhead than a function call, but quite possibly it will be acceptable.
    • unnouinceput 6y ago
      None is stopping you to write a PGSQL driver that uses memory-mapped files and then your calls are as fast as a function call. Like I said, it all depends on the driver.