PostgreSQL

05 Oct 2024 22:09

I mean, it has features but it's so artificially limited it's unusable

PostgreSQL

05 Oct 2024 22:08

And also in my opinion who I used also to work on SQL server and have a great experience on it, really postgreSQL once u understand it and have a deep knowledge of its architecture and internals, I find it way faster in I/O speed and overall capabilities than sql server in my humble opinion

PostgreSQL

05 Oct 2024 22:06

I mean activities are same but process the way completely different

PostgreSQL

05 Oct 2024 21:58

Completely different

PostgreSQL

05 Oct 2024 21:57

And we don't use command line

PostgreSQL

05 Oct 2024 21:53

As a DBA, it is your job to setup an maintain a DB, not resell a cloud service

PostgreSQL

05 Oct 2024 21:53

Only tsql is same in SQL server and postgresql. But DBA task completely different in both db

PostgreSQL

05 Oct 2024 21:52

Yea transaction rate is high bro.

PostgreSQL

05 Oct 2024 21:50

We have db size in tera bytes like 5 tb

PostgreSQL

05 Oct 2024 21:49

if really ur having a heavy workload, u will experience so many issues really and the cost will kill u back then

PostgreSQL

05 Oct 2024 21:47

Surely, there is an option in amazon portal to automatically scheduling the backups like Microsoft azure managed instance... why not using amazon portal itself?

PostgreSQL

05 Oct 2024 21:46

Cloud will stay around, just as Java did. I tried to sit both out... 😏

Anyway. I'd assume Aurora (which is *not* PostgreSQL, btw.) will provide some backup schedule. As it is not PostgreSQL, chances are quite good that a pg_basebackup or even pg_dump will fail anyway. Also, where did you plan to _store_ your backups? On premise?!? ;-)

PostgreSQL

05 Oct 2024 21:43

Lower speed, higher cost, higher chance of data leak....

PostgreSQL

05 Oct 2024 21:43

I can understand for a website or something that needs to be public, but i really don't understand why you would migrate everything "on the cloud"

PostgreSQL

05 Oct 2024 21:42

That sounds stupid. Keep your internal stuff internal, offline, on prem

PostgreSQL

05 Oct 2024 22:08

Sql server feels like a toy database to me

PostgreSQL

05 Oct 2024 22:07

And btw, I am completely with everything running on linux is way better than windows for sure and much faster and smoother...

PostgreSQL

05 Oct 2024 22:06

how it is different, bro???

A DBA have two things in common: 1) how to configure and tune your database

2) is maintenance

I understand SQL server is different than postgreSQL, windows is different than linux, it is completely fine...

but once ur a DBA, u should learn how to manage databases that setups on different environments whether linux or windows... so learn linux, and start learn postgreSQL by reading books and listening to podcasts... thats simple...

PostgreSQL

05 Oct 2024 21:58

SQL server DBA and postgresql DBA Both are different

PostgreSQL

05 Oct 2024 21:55

Yes I am sql server DBA(onprem and azure sql). Also working in aurora postgresql. But not onprem postgresql linux

PostgreSQL

05 Oct 2024 21:53

And i thought you were a DBA :)

PostgreSQL

05 Oct 2024 21:52

>Flexibility
The cloud is not flexible at all, on managed instances you don't even know what's running under the hood and have no way to tune parameters for your application (e.g. if you need to increase stats sampling, change wal size for mass loading of data...)

>Optimize cost
You can run hundreds thousands of queries a second on a laptop. That's a ~20w load. Loading a small nuc with 64G of ram and putting postgresql on it will probably be faster than cloud.

>Less maintenance
There is virtually no maintenance when you use good quality HW, stable OS and stable DB. And if DB version is not supported anymore, just pg_upgrade with minimal downtime.

>automate things
What can you automate that i don't?

PostgreSQL

05 Oct 2024 21:51

it is not about size, it's about the average transactional rate on the database by the application, like how many transactions per second, server requests, server response time, etc...

PostgreSQL

05 Oct 2024 21:49

No patching, no server maintenance, easy scalability, etc

PostgreSQL

05 Oct 2024 21:47

Flexibility, optimize cost, less maintenance, automate things, just use managed as service..if you have onprem, u have to take licence based on the cores. U have to setup physical environment, u have to hire many resources to mange all the things...many more advantages to move to cloud.. wherever SQL server is running now all companies migrating to azure cloud

PostgreSQL

05 Oct 2024 21:46

just put everything on the cloud bro

PostgreSQL

05 Oct 2024 21:45

Then get an amazon linux instance to run that management tasks.

Or amazon/windows (windows task scheduler itself, btw, is a fine tool, I like it more than cron. Also a good generic service runner on windows, btw. Windows, hoewer, has a lot of deficiences as a server, especially as a cloud-based server).

PostgreSQL

05 Oct 2024 21:43

U are postgresql DBA

PostgreSQL

05 Oct 2024 21:43

Didn't see any one.

Seen, however, a lot doing exactly opposite (even helped a bit).

PostgreSQL

05 Oct 2024 21:42

Cloud to cloud communication