PostgreSQL

06 Oct 2024 17:42

In my experience the cloud can cause just as many issues.

The cloud is not magic, it's just somebody else's computer, that you're renting.

Which comes with it's own sets of limitations and tradeoffs.

Engineering is about finding a solution which balances those tradeoffs within your constraints.

PostgreSQL

06 Oct 2024 17:33

Hope u r not so..if ur not emerging as per the technology..

PostgreSQL

06 Oct 2024 17:32

Who r u to state about me...

PostgreSQL

06 Oct 2024 17:16

I totally agree 💯..

PostgreSQL

06 Oct 2024 17:10

I have multi loud, that was just an example

PostgreSQL

06 Oct 2024 17:08

U can't compare one cloud provider with others as I have been using Amazon for the past 3 Years and I don't have issues with it.and moreover i need to pay money for the space which i have utilized instead i need not to buy space for future use..

PostgreSQL

06 Oct 2024 17:03

I have experience horrible issues with Oracle cloud

PostgreSQL

06 Oct 2024 17:01

Till now we have faced many issues.. atleast by using cloud we are safe ..

PostgreSQL

06 Oct 2024 16:54

Buying the server and maintaining it doesn't mean we did cost optimization..we need to consider other factors like.. network,scalability options in future , Performance and moreover deploying the team for doing all these activities..

PostgreSQL

06 Oct 2024 13:53

I am working with a table that stores SQL queries, and I need to classify them based on whether they are intended for data extraction or data modification. Specifically, I need to:
Mark queries as "Extract" if:

They are standalone SELECT queries used to retrieve data.
They are part of a WITH ... SELECT Common Table Expression (CTE).
They are COPY statements.

Mark queries as "non-extract" if:
The SELECT is combined with data modification operations like INSERT INTO, UPDATE, or DELETE.
The query involves aggregations like COUNT etc.
Additionally, I need to avoid false positives when keywords like insert, count, or delete appear in table or column names (e.g., insertbase, countless).How can I write a SQL query to correctly classify these queries in PostgreSQL?

PostgreSQL

06 Oct 2024 09:11

And remember that postgresql ages well, aka with new versions optimizations are introduced and performance increases

PostgreSQL

06 Oct 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 Oct 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 Oct 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 Oct 2024 22:10

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

PostgreSQL

06 Oct 2024 17:34

It's not huge...it is in the permissible limits

PostgreSQL

06 Oct 2024 17:33

At a very hefty price, yes

PostgreSQL

06 Oct 2024 17:32

You're not an engineer at all.

(I've seen a lot of people like you).

PostgreSQL

06 Oct 2024 17:15

Yes correct. Migrating a database to the cloud can resolve many issues, such as performance bottlenecks, scalability limitations, and infrastructure maintenance concerns. Cloud databases often offer built-in redundancy, automated backups, and enhanced security features, which can further improve reliability and uptime.

PostgreSQL

06 Oct 2024 17:09

Each has their own perspective..but that shouldn't be commented..

PostgreSQL

06 Oct 2024 17:03

While I'm all sound with my on prem which is easily scalable, less expensive and I have control over it

PostgreSQL

06 Oct 2024 17:02

As in a fraction of seconds we can obtain either horizontal or vertical scaling..

PostgreSQL

06 Oct 2024 16:59

How do you think we've done network scalability until now?

PostgreSQL

06 Oct 2024 16:49

Just with this u can't blame..even though I am an experienced Dba ..I am not a half-knowledger person to post the info here.. without Knowing about it...

PostgreSQL

06 Oct 2024 11:58

1. Mobile App Developer Internship
https://rb.gy/9ajw2d

2. Product Management Internship
https://shorturl.at/15rIM

3. Backend Developer Internship
https://rb.gy/4ngfk5

4. Technical Operations Internship
https://shorturl.at/Nn8Ie

5. Frontend Developer Internship
https://shorturl.at/1Gf9Q

6. Fullstack Developer Internship
https://rb.gy/e052g9

7. QA Engineer Internship
https://rb.gy/0g6sfy

PostgreSQL

06 Oct 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 Oct 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 Oct 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 Oct 2024 22:10

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

PostgreSQL

05 Oct 2024 22:09

SQL server is like playing video games for me