logoalt Hacker News

glzone1today at 6:00 AM1 replyview on HN

Running postgresql is an order of magnitude more complicated than sqlite.

130k tps even with unlogged is not always super easy especially if getting hit concurrently. Postgresql connection overhead alone can be pretty brutal if you are setting up and tearing down connections or have 1,000 writers etc.

Postgresql generally requires good network connectivity. Folks doing sqlite distributed tend to have everything independent, you literally don't need to worry about connection / security / firewall / permissioning / internode escape or data leaking etc, can even have problems in local side networking and services can still serve.


Replies

jklmnopqrstuvwtoday at 10:21 AM

even with wal, postgresql can easily reach 130k tps in pipeline mode.

show 1 reply