PostgreSQL

15 February 2026 17:15

Also figure out where your bloat is and target it accordingly, queries like those in https://github.com/ioguix/pgsql-bloat-estimation/tree/master and https://wiki.postgresql.org/wiki/Show_database_bloat#Query_from_check_postgres

PostgreSQL

15 February 2026 17:07

Well, you had it coming with vacuum full. Best idea would be to use pg_repack but as @Suman_PHF10073 said that requires keys

PostgreSQL

15 February 2026 17:04

Pgrepack addin you could use provided tables has primary keys

PostgreSQL

15 February 2026 16:04

Can you be a bit more specific? Is there something you struggle with?

PostgreSQL

15 February 2026 11:05

Great! will test this out.

PostgreSQL

15 February 2026 09:54

is pgBackRest incremental is more or less like pg_basebackup incremental in version 17?

PostgreSQL

14 February 2026 13:08

That's because some Oracle book wrote partitioning = 10X fast and people without any business need or natural key to partition also want to partition. I remembered old oracle blog saying if table is >2GB consider partitioning. 😂

PostgreSQL

14 February 2026 10:54

As you probably know I have a very strong opinion about hash partitioning, even for sharding. The scaling and flexibility is just too limited for me.

PostgreSQL

14 February 2026 01:49

Strictly speaking: yes. But it would require you to build the hashed table in the background. When you are ready you lock both tables and swap the names.

I would strongly advise to rethink your partitioning set up. When you use hash partitioning you can get a lot of full page writes on your index because of the random inset positions. It is also very hard to expand the number of partitions in the future.

I would recommend range based partitioning. Maybe investigate the uuidv7 data type for your partitioning column.

PostgreSQL

13 February 2026 06:59

I know a little bit, yes

PostgreSQL

13 February 2026 02:56

Looking for Postgre sql DBA support on Monday 2pm -2:45pm CST

PostgreSQL

10 February 2026 15:47

Looking for Oracle DBA opportunity with 9.5+ years of experience.... Please let me know if any openings

PostgreSQL

10 February 2026 14:20

There's also --clone now, for some filesystems. Combines the best of both worlds.

PostgreSQL

10 February 2026 12:23

Since the postgresql on-disk format is mostly static, most files will just be hardlinked

PostgreSQL

10 February 2026 12:00

The safest is using copy, it'll also as a bonus check if all the files are okay and refresh bitrot on ZFS pools / RAID arrays 😺

PostgreSQL

15 February 2026 17:08

It would be good to understand why you need a vacuum full given that a database in good health should do just fine with autovacuum

PostgreSQL

15 February 2026 17:07

Is it actually the tables that are bloated or the indexes? If the latter consider also the native REINDEX...CONCURRENTLY?

PostgreSQL

15 February 2026 16:12

I will now elaborate on my current activities. We are experiencing a significant downtime of approximately 8 hours for a full vacuum during database maintenance, given that some of our databases are around 1TB in size. This extended downtime is a considerable concern. Do you have any recommendations for reducing or eliminating this downtime?

PostgreSQL

15 February 2026 15:44

Hi Team, I’d like to understand best practices for PostgreSQL database maintenance on a live production instance with zero or minimal downtime.

PostgreSQL

15 February 2026 10:28

It is similar in its effect, but the implementation is quite different. pgBackRest is based on checksums (so it still has to read a lot on the server) while the builtin incremental method relies on a logfile tracking all changed pages.

Also, pgbackrest can't combine old backups to create new full backups, AFAIK.

PostgreSQL

14 February 2026 16:54

I usually say to do it from 100GB onwards.

PostgreSQL

14 February 2026 13:02

Seems like it is very popular in the Oracle realm. One wonders why... Probably a good source for consulting hours...

PostgreSQL

14 February 2026 08:50

Is there any serious use case for hash partitioning apart from sharding? 🤔

PostgreSQL

14 February 2026 00:07

is this possible to convert a big table into hash partitioned on-line?

PostgreSQL

13 February 2026 06:54

Hi anybody knows about pgbouncer

PostgreSQL

10 February 2026 15:47

This place is for postgresql, not Oracle.

PostgreSQL

10 February 2026 14:42

It's not received the hype coverage it deserves... also, the list of filesystems actually supporting it is rather short.
And the rsync trick for replicas doesn't work with it AFAICS, so it's not for everyone.

PostgreSQL

10 February 2026 12:32

@unfoxo thanks!

PostgreSQL

10 February 2026 12:19

link means it will create the new upgraded version with hardlinks to the old datafiles? so it will modify the older version?
copy is the safest but it takes longer to copy the hole data?

PostgreSQL

10 February 2026 11:59

I use --link because my filesystem supports snapshots, so i can go back to the old snapshots and undo the upgrade if anything happens. But if something bad happens, the files that were changed by the newer postgresql version during the upgrade will not work on the older one.