PostgreSQL

06 October 2024 09:09

Get your monthly Aurora costs multiply by 12 and use the same money to get a proper server and you'll probably get something that outperforms the cloud in every aspect and repays itself in one year

PostgreSQL

06 October 2024 08:35

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

06 October 2024 06:11

I agree with cloud ...I see people who are habituated to the cloud will get to know...I mean scalability , reliability, performance,Security are very good when compared to On-Premises

PostgreSQL

05 October 2024 22:10

Like, why did SMSS suddently become half-finished Azure Manager?? Who asked???

PostgreSQL

05 October 2024 22:09

SQL server is like playing video games for me

PostgreSQL

05 October 2024 22:08

Sql server feels like a toy database to me

PostgreSQL

05 October 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 October 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 October 2024 21:58

SQL server DBA and postgresql DBA Both are different

PostgreSQL

05 October 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 October 2024 21:53

And i thought you were a DBA :)

PostgreSQL

05 October 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 October 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 October 2024 21:49

No patching, no server maintenance, easy scalability, etc

PostgreSQL

05 October 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

06 October 2024 09:08

The issue is that you are probably comparing some sub-par sever with a cloud managed service which costs 10x as much

PostgreSQL

06 October 2024 06:14

When I was working in on-premises..I see everything dependencies ,hurdles though there are server or storage issues as a DBA we need to identify the cause and let the respective team know... Which frustrates DBA when it is production issue

PostgreSQL

05 October 2024 22:10

😂😂 somehow, but because it is a very well known company in the market, so really it has so many integration with literally everything bro

PostgreSQL

05 October 2024 22:10

And as with every Microsoft product, the more they develop it the more you lose control

PostgreSQL

05 October 2024 22:09

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

PostgreSQL

05 October 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 October 2024 22:06

I mean activities are same but process the way completely different

PostgreSQL

05 October 2024 21:58

Completely different

PostgreSQL

05 October 2024 21:57

And we don't use command line

PostgreSQL

05 October 2024 21:53

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

PostgreSQL

05 October 2024 21:53

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

PostgreSQL

05 October 2024 21:52

Yea transaction rate is high bro.

PostgreSQL

05 October 2024 21:50

We have db size in tera bytes like 5 tb

PostgreSQL

05 October 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 October 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?