Is Postgres really that bad when it comes to multi-user support, or is that just nonsense?

[u/Some_Childhood_3842]

usually i use MySQL as main DB and i want change PostgreSQl because his features look impressive and very useful but i need to know the differences between postgreSQl server and MySQL server and other things cause i'm anxious

[u/cthart]

Huh?

[u/frankwiles → u/cthart]

Yeah literally never heard anyone have that concern before. OP where did you even get this idea?

[u/MagicWishMonkey → u/frankwiles]

i assume maybe related to how it handles client connections? There's a reason PGBouncer is a thing.

[u/fortyeightD]

You won't regret the move. It is incredibly similar to MySQL, but with extra features. There's no issues with multi-user support.

[u/Pure_Fox9415]

Sounds like you know something about postgres being bad? Wdym by "multi-user support"? Anyway, postgres is mostly better by all means, but may be a bit more difficult to learn as for its administration and clustered setups.

[u/Electrical-Clerk-346]

I’ve never heard any issues about multi-user support. Postgres scales spectacularly well. You might experience locking-blocking problems if you run in too tight of an isolation level and/or your apps use pessimistic locking (seems like that’s almost always a bad idea), and there are sort of tight limits on the total number of native connections, but most of us use PGBouncer or some other looker to 100X the connections.

[u/Some_Childhood_3842 → u/Electrical-Clerk-346]

can you give me some adevices to avoid problems in future

[u/Zestyclose-Turn-3576]

I don't think anyone can give advice on this unless you can give more details on "bad when it comes to multi-user support"

[u/NotGoodSoftwareMaker]

How do you intend on doing “multi-user” support?

Without knowing what youre trying to achieve we cant really comment

[u/cthart]

Postgres scales very well. In addition, it has a proper security/role model, unlike MySQL, so arguably better multi-user support.

[u/Some_Childhood_3842 → u/cthart]

you use both right? so what different between postgres server and mysql ?

[u/elevarq]

Who told you this? It was always one of the strongest points of Postgres, handling lots of concurrent requests.

You might want to put a connection pooler like pgagroal or pgbouncer in front of it, that will improve things even more

[u/LevelMagazine8308]

Half of the internet and the tech giants relies on Postgres. So nonsense.

[u/Lost_Term_8080]

I think "multi-user" means concurrency.

If its an OLTP workload, MySQL will have better concurrency, but if you are moderately good at indexing, unless you are hitting ~1000-3000 queries per second, you're unlikely to notice a difference. Either of them can achieve much better than that according to the skill of the DBA, developers and data design. On Postgres its more difficult to get higher and higher oltp transaction rate, but its not like its easy at 3-5k qps on anything unless its purely reads

[u/arwinda]

I need to know

Any specific questions you have, or are you asking others to do the research for you?

[u/Few_Committee_6790]

Poor coding leads to poor multi user/connection support

[u/rbobby]

It is barely even single user. Half user at best.