PostgreSQL

30 December 2025 08:34

Just curious — url was to a real udemy or some scam fishing site?

PostgreSQL

30 December 2025 08:32

Hello Nikhil, I have shared you the URL in your DM. Kindly enroll and share your valuable feedback. Thank you

PostgreSQL

30 December 2025 08:21

If you are interested to explore how to integrate PostgreSql with AI to create database assistant, where you can generate the Sql queries automatically, let me know I have my course in Udemy. Will share you the Coupon code to assess it for free, sharing this out of interest to explore together

PostgreSQL

28 December 2025 00:35

is it difficult to count isolated db size ?

PostgreSQL

27 December 2025 21:07

Is

SELECT ... FROM parent WHERE id=4 FOR UPDATE

INSERT INTO children (parent_id)  VALUES (4)

PostgreSQL

23 December 2025 18:49

PostgresTV hacking session live — join! we dig into direction of support of btree merge again (because now it has only split, hence inevitable index bloat and need to rebuild index), a hard but super interesting topic https://www.youtube.com/watch?v=c0wKWcPZnH0

PostgreSQL

23 December 2025 08:44

Probably, he is banned there.

(I would recommend to ask moderators for unban)

PostgreSQL

23 December 2025 07:13

i'm pretty sure it's English only in here

PostgreSQL

22 December 2025 12:36

If there's another edition of "Community Summit" at pgconf.dev, what are topics you would like to see discussed?

PostgreSQL

20 December 2025 15:15

You are mentioning about reconfiguring

PostgreSQL

20 December 2025 14:50

No you don't need to

PostgreSQL

18 December 2025 12:30

There is a mailing list on the postgresql website

PostgreSQL

16 December 2025 19:03

Need to convert stored procedures from plsql to redshift sql ie postgress sql anyone providing support ping me

PostgreSQL

10 December 2025 13:04

Can I ask you guys which tools you're using for ETL/migrations?
I mostly go with Apache Nifi but I wonder what other people are using for their daily work

PostgreSQL

10 December 2025 13:02

But unless it's that particular case i wouldn't find a use case for it, and it's just promoting the secondary so nothing amazing or particular

PostgreSQL

30 December 2025 08:34

Hello Mustafa, there is an issue sharing through you DM, not sure if you have any restrictions. Could you please drop me a note so that I can reply back with the details.

PostgreSQL

30 December 2025 08:22

I am very much interest can you share me the code

PostgreSQL

29 December 2025 18:28

Need to convert stored procedures from plsql to redshift sql ie postgress sql anyone providing support ping me

PostgreSQL

28 December 2025 00:08

I'd say so, yes. You might decide to delete the record in your transaction, or change the id to 9.

Use SELECT ... FOR NO KEY UPDATE.

PostgreSQL

23 December 2025 22:16

Dear Datadog:

Um, OK. So, what precise use is this metric?

The postgresql.database_size metric reports the disk space used by the database and is tagged with db. 1

However, there's an important distinction: this metric does not include TOAST data, indexes, free space map, or visibility map.

PostgreSQL

23 December 2025 08:48

Ah okay, but their number is visible. I think it's good to share their username instead :)

PostgreSQL

23 December 2025 08:05

There's a thriving russian speaking channel though.

PostgreSQL

23 December 2025 07:04

It's hard to translate so don't read this if u can't.

Постгрес.

Уровень repeatable read устраняет фантомное чтение в том смысле, что если другая транзакция во время текущей записала что-то, текущая этого не увидит и закомитит то что хочет, что может вызвать логические проблемы.

Уровень serializable не позволяет закоммитить текущую транзакцию, если какая-то другая сделала то, что для текущей транзакции бы вызвало фантомное чтение (если бы был уровень read committed).

Это так?

PostgreSQL

21 December 2025 09:54

csv, awk/sed, duckdb 😄

PostgreSQL

20 December 2025 14:51

However, depending on the database size it might be worth to stop it and resync using basebackup

PostgreSQL

20 December 2025 14:20

While performing vacuum full on primary whether we need to stop the replica

PostgreSQL

18 December 2025 12:25

Hi where I can find pg careers in Europe?

PostgreSQL

15 December 2025 07:00

Hi i am Giving postgresql DBA offline interview suport in Hyderabad, call:8309555894

PostgreSQL

10 December 2025 13:02

Simple answer: Streaming replication keeps a 1:1 copy of the cluster. No way around it. So no, it's not possible.

PostgreSQL

10 December 2025 13:01

Useful if, for example, your data sits in the same place the secondary is. WAL streaming could be faster (considering wal is chunks of compressed data) than moving the original data and adding it in the primary