PostgreSQL

16 Apr 2025 07:29

Did you even check/search the documentation?

PostgreSQL

15 Apr 2025 20:14

Third option would be to enable timeout at application end or postgres statement timeout so large sort doesn't run long enough to fill disk.

PostgreSQL

15 Apr 2025 20:04

Hello All,
My postgres database is frequently crashing due to data filesystem disk full . . When analyzed it shows when there is a particular select query is running this happens.

What do i do to restrict from outage. The queries can be hit on db at any time by any process but is there a way to set limit for temporary storge when the sorts are huge?

PostgreSQL

15 Apr 2025 17:54

Usually restore to another host to avoid any accidents. On new host you can use whatever data directory you want.

PostgreSQL

15 Apr 2025 17:02

Hi Team,
Can we restore a database on new drive other than existing data directory in same server on window's?

PostgreSQL

15 Apr 2025 16:37

We understand....speak abt the qtn being raised and not something else

PostgreSQL

15 Apr 2025 16:28

I prefer righful answer

PostgreSQL

15 Apr 2025 16:26

How can we knw about the bottlenecks

PostgreSQL

13 Apr 2025 05:33

Backdoor Immediate Requirement
Technology: MySQL, PostgreSQL,MongoDB
Experience: 3 to 10 years
Company: JP MORGAN
Package: 13 to 40 Lpa
Contact on WhatsApp: 7799000409
(Resources need to go for onsite for 2 years)
Message me directly

Work Location: India, USA, Germany

PostgreSQL

11 Apr 2025 06:18

HI
But why you need super user permission to be given to any user.
what is the actual need

PostgreSQL

11 Apr 2025 06:16

Hi ,
I want to learn performance optimization techniques
Can anyone suggest some documentation or video lectures
Like how to change a sequential scan to index scan when it's taking time

PostgreSQL

10 Apr 2025 20:56

I don't know why developers continue using large object data types instead of bytea ( when they usually store less than 1gb) and after they ask for a replication method as fast as cdc.
I am checking etl tools but most of the open-source one have been closed recently like talend (qlik bought them), pentaho community ( hivati changed).., have you got any recommendations?. Source and target database are postgres and I was going to use pg_logical or postgres native pub/sub.

PostgreSQL

10 Apr 2025 18:27

I wonder if they mean permission to create objects on public schema...

PostgreSQL

10 Apr 2025 18:12

Hello everyone..I have migrated postgres version from 13 to 16 which is running on azure. After migration my existing scripts are failing where I am trying to grant postgres to my application users. I have seen in the official documentation that this is some change hapnd in 16 version which needs some admin option. Any one have any solution available. as it is azure I don't have any super user access. Anyone aware of this please help

PostgreSQL

10 Apr 2025 15:38

It seems to me that 90% or more of those are inadequate "DBAs" that were assigned a Postgres database and have no idea what they are doing. And they have zero interest in participating in the community either online or at events. They just want to get free stuff because that's what free software is all about right?

PostgreSQL

16 Apr 2025 04:44

Thanks. Any ways to set limit on db settings? Like the temp size limit available in db2 and mysql

PostgreSQL

15 Apr 2025 20:12

Write better queries, check explain plan and avoid unnecessary hash/merge joins on large tables, avoid unnecessary sorting, aggregation etc.

Or get bigger disk, increase memory then increase work_mem

PostgreSQL

15 Apr 2025 18:06

Generally, why not?

Well, however, how could WE know what you can and what you can not?

PostgreSQL

15 Apr 2025 17:41

Your question is too generic and something even a simple chatgpt or google search can reveal.

PostgreSQL

15 Apr 2025 16:39

If u don't hav , there are still 2.5 members in this grp where in any one can answer...as simple as that

PostgreSQL

15 Apr 2025 16:33

Unfortunately, the use of obscene language is prohibited here.

PostgreSQL

15 Apr 2025 16:27

Hire an experienced software engineer.

PostgreSQL

15 Apr 2025 16:25

Guys can u tell me about explain analyze

PostgreSQL

12 Apr 2025 18:04

What are you trying to achieve by giving app users or any kind of users establishing database connection to give Postgres Super user permission???

By doing so, really ur making ur environment out of control and mayhem, and won't be able to manage and administer your database performance, access, permission, etc...

PostgreSQL

11 Apr 2025 06:17

That's a terrible idea anyway.
Time to re-think which permissions your users really require, I'd say.

PostgreSQL

11 Apr 2025 05:02

Making member of postgres..GRANT postgres to newuser;

PostgreSQL

10 Apr 2025 20:46

Cloud providers usually don't give superuser access or it could be not same as usual postgres. Better create support case for cloud vendor. Anyway you must be paying for it.

PostgreSQL

10 Apr 2025 18:15

What do you mean by "grant postgres"?

PostgreSQL

10 Apr 2025 16:44

Absolutely. And non-engineering companies' management won't give 1% of care either if their employees wanted to.

PostgreSQL

10 Apr 2025 13:55

I'm so tired of no actual discussions happening, just people coming here and dumping whatever query they have without bothering to read documentation or explain themselves