PostgreSQL

13 August 2025 11:04

I get >800MB/s reads and writes unless I'm loading very old data, then I'm limited by the 300MB/s of the spinning drives

PostgreSQL

13 August 2025 11:02

Yeh, there looked some nice ideas in there.

PostgreSQL

13 August 2025 11:02

What I like is the flexibility, compared to zfs where you cannot grow with your data needs bcachefs is more like "add or remove drives and data flows automatically in the safest/fastest way"

PostgreSQL

13 August 2025 11:00

I had some data loss due to some undetected hardware corruption that in turn triggered a bug from an old kernel version

PostgreSQL

13 August 2025 10:53

Snapshotting is implemented fs-side (bcachefs), so if anything goes wrong i rollback the snapshots, else i commit and keep going on

PostgreSQL

13 August 2025 10:52

Yeh. I use a plpgsql function and a table to implement execute once migrations. Then the schema can become a bunch of files to concat together.

PostgreSQL

13 August 2025 10:50

I would advise against relying on db diffing for any form of schema management. It will only end in pain. And just reinforces a lack of good process.

PostgreSQL

13 August 2025 09:18

https://www.red-gate.com/products/redgate-pgcompare/

I haven't tested it but looks promising

PostgreSQL

12 August 2025 23:00

PostgreSQL Person of the Week interview with: Curt Kolovson

https://postgresql.life/post/curt_kolovson/

PostgreSQL

12 August 2025 18:53

Just search you’re questions in the group. There is a search function b

PostgreSQL

12 August 2025 14:30

SQL server DBA Can you please stop messaging people? Thanks.

PostgreSQL

11 August 2025 23:29

Hello, Have anyone experienced the "select set_config (*)" takes seconds instead of ms to complete?

I have not been able to reproduce it but trace in the code captured it. Any clue?

PostgreSQL

11 August 2025 14:03

Yes, pgaudit extension and aurora specific functionalities provide the same capabilities

PostgreSQL

10 August 2025 14:26

Ain't there a proper logfile somewhere? One that tells you the actual error? Or a few more lines of the output above that? "An error has occurred" doesn't really help...

PostgreSQL

04 August 2025 20:07

PostgreSQL Person of the Week interview with: Shlok Kumar Kyal

https://postgresql.life/post/shlok_kumar_kyal/

PostgreSQL

13 August 2025 11:03

My setup is 2x 6T SSDs that work as a "foreground" target and caching devices, and a bunch of drives in raid where data slowly spills in background so all random read and writes are turned into sequential

PostgreSQL

13 August 2025 11:02

Drive speeds are continuously logged and used to decide what device to prioritise for writes, for reads and so on...

PostgreSQL

13 August 2025 11:01

Lead dev helped me recover the files, I wrote a bunch of scripts to carve postgresql files, at the end everything turned well

PostgreSQL

13 August 2025 10:54

How are you finding bcachefs? I've been intrigued for a while, but the lead dev of it does not fill me with confidence.

PostgreSQL

13 August 2025 10:52

Something like "20250813_change_implicit_smd_reel_position_to_explicit.sql"

PostgreSQL

13 August 2025 10:51

"DIY" it's a bunch of date-coded well-written migration scripts. A simple table tracks the last executed script (aka the schema version)

PostgreSQL

13 August 2025 10:49

The same way you do with code. I prefer to have an sql file per entity and a simple script to concat together. Makes reading changes in git very easy.

Otherwise look at something like pgroll.

PostgreSQL

13 August 2025 07:42

how do you guys version control your database?
possibly something to integrate with ci/cd (syncing local version with prod)

PostgreSQL

12 August 2025 18:53

For instance by searching “started”

PostgreSQL

12 August 2025 16:21

can anyone provide complete guidence of Postgresql DBA.

PostgreSQL

12 August 2025 08:41

I'd reckon some lock on the catalog?

PostgreSQL

11 August 2025 18:11

Can anyone please share me the script to setup index optimization job for Postgresql

PostgreSQL

11 August 2025 13:52

Can we do database audit in Aurora postgresql

PostgreSQL

09 August 2025 15:36

Friends, please help, when installing PostgreSQL, an error occurs, which I have attached below. I tried changing the access rights to the folder, I tried disabling the antivirus, I tried creating a new account. I've tried everything. nothing helps... Has anyone encountered such an error?

Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.

PostgreSQL

04 August 2025 18:30

Using odbc driver for Postgresql