PostgreSQL

10 Jun 2025 18:57

PostgreSQL Documentation has a few resources to learn DBMS
https://www.postgresql.org/docs/online-resources/.

PostgreSQL

09 Jun 2025 16:55

PostgreSQL Person of the Week interview with: Teresa Lopes

https://postgresql.life/post/teresa_lopes/

PostgreSQL

07 Jun 2025 19:53

Is anyone familiar with any PII tool (open source) with GUI? Not only CLI
That works with postgres 9+

PostgreSQL

07 Jun 2025 08:23

It will work only in those sessions only not all active connection was impact

PostgreSQL

04 Jun 2025 18:43

Postgres vibe hacking session live - join! https://www.youtube.com/watch?v=OlzLF2VVZ8U

PostgreSQL

04 Jun 2025 14:29

And did you SELECT pg_reload_conf() ?

PostgreSQL

04 Jun 2025 08:59

hello all, I set log min duration statement to 1 min, but still seeing all logs of prepared sqls like bind, delete etc. what configuration should I change

PostgreSQL

02 Jun 2025 20:49

PostgreSQL Person of the Week interview with: Dilan Tek

https://postgresql.life/post/dilan_tek/

PostgreSQL

31 May 2025 13:32

Phones from 2016-2017 already have more than 6gb of ram

PostgreSQL

31 May 2025 13:31

Yeah, I'm waiting for mainline support on mine. It's almost there

PostgreSQL

31 May 2025 13:28

I host everything locally for a reason, no cloud needed 😎

PostgreSQL

31 May 2025 11:24

More like Radxa Rock 5B

PostgreSQL

30 May 2025 20:21

Next PostgreSQL cluster will be hosted on Raspberry Pis instead of a big machine with small VMs /s

PostgreSQL

30 May 2025 19:08

Virtualization will always be anything from 20 to 90% slower than bare metal in latency and speed

PostgreSQL

30 May 2025 18:02

I am curious as to whether it relates to "Fix data loss in logical replication." from last month which apparently was back-patched to 16 and triggers the "adding a new snapshot and invalidations" debug message immediately prior.

Update: Yes, probably, as I was pointed to https://www.postgresql.org/message-id/flat/CAA4eK1LMgqeT_bPZ3MH-VKvwOqpZyfJmF7knZhu1rqt2Pqsnwg%40mail.gmail.com#11afe1ad8975047112614d01ce9c4a0d when filing the bug.

PostgreSQL

10 Jun 2025 17:51

Which one is best platform for learning postgressql

PostgreSQL

09 Jun 2025 09:02

Hi guys,

Need your help,

I want to open (automatically open when I pass credentials) and do automate login (automatically connect to db) for pgadmin

How can I achieve it please help me

PostgreSQL

07 Jun 2025 08:27

If you define this in postgres conf file then this will effect globally

PostgreSQL

06 Jun 2025 09:26

Hi All, I have a function in which I want to define statement timeout for 5 sec and we are using the Pgbouncer as well with session pooling, so if I put set statement_timeout at function header will it impact any other user/query or anything ,anyhow???

PostgreSQL

04 Jun 2025 15:31

it is prepared statements logs “bind” etc

PostgreSQL

04 Jun 2025 09:42

what‘s your parmeter log_statement ?

PostgreSQL

03 Jun 2025 06:17

Actually I am working on infomix to postgresql migration project ..I am looking for support kindly let me know any one can help me

PostgreSQL

02 Jun 2025 13:07

Hi Team, is there a DB2 Admin available who can assist me…preferably from Hyderabad ?

PostgreSQL

31 May 2025 13:32

Another dream of mine is buying used phones with mainline support and put proxmox ve on them to do a cluster

PostgreSQL

31 May 2025 13:29

I have a few Rock 5Bs and with a good SSD they work pretty well, more IO than the RPis. Just a shame the software support is less good.

PostgreSQL

31 May 2025 13:25

I've tried a few times to get a talk accepted of: my Raspberry PI is faster than your cloud server :)

PostgreSQL

30 May 2025 20:23

PGLite to the rescue, run it on your browser.

https://github.com/electric-sql/pglite

PostgreSQL

30 May 2025 19:09

On my proxmox node a 3000MB/s capable SSD becomes "only" 600MB/s even with paravirtualization

PostgreSQL

30 May 2025 18:29

I’m planning to set up MySQL and PostgreSQL with high workload and I/O.
Do you recommend running them on VMware vCenter with vSAN storage, or directly on a physical server (bare-metal with local storage)?
Which one will give better performance and reliability for this use case?

PostgreSQL

30 May 2025 17:32

Good news: I can reproduce the OOM issue!
Bad news: The reproduction occurred when trying to make a new logical replica to replace the broken one. 🙃

At least I might have something more concrete to file as a bug once I do figure it out (if I don't just recompile it/patch it with a 2GB limit, or switch to physical replication).