PostgreSQL

14 November 2025 10:46

Am i the only one that cannot get postgresql to use any brin index, ever?

PostgreSQL

12 November 2025 10:40

can someone help me with Pgbackrest?

im taking a full backup and then insert some more data
then i remove the whole data directory and restore - the issue it that the restore also apply all the WAL's created after the backup.

PostgreSQL

07 November 2025 14:13

I need python developer support.will pay for support
Please dm me

PostgreSQL

07 November 2025 05:15

Data doesn't come automatically though and your statement is invalid at smaller data lengths.

PostgreSQL

07 November 2025 04:01

So it's not automatic but triggered by data size.

PostgreSQL

06 November 2025 02:02

Trick question. No types in PostgreSQL automatically use TOAST.

PostgreSQL

04 November 2025 18:10

https://www.postgresql.org/docs/current/upgrading.html

PostgreSQL

04 November 2025 18:08

In ms sql server we have tool called dma for validating braking changes so like that is there any tools in postgres to understand what are things may chance to break ?

PostgreSQL

04 November 2025 09:51

Hi QWxp. I'm still using apgDiff since 10 years ago.

* dump production & dev ddl
* diff it with apgDiff
* roll the diff into test env ( one mirror containing full production data )
* if it pass, deploy.
* commit & tag the diff within a release.
* if something happen. rollback from that tag.

automate the process by using simple bash script. no complex ci/cd setup.

PostgreSQL

04 November 2025 05:21

Hi, I wants to try bloom index
If anyone already tried can you pls brief how it helped practically to access early

PostgreSQL

03 November 2025 05:57

yeah, sometimes i do miss solving complex problem by myself. now i prefer trade it to get higher leverage (sales, business network, etc).

PostgreSQL

03 November 2025 05:14

Btw, over the past three years, I’ve been outsourcing almost all my database problems to major LLMs — complex stuff including CTEs, window, recursive, even regex.

I just attach DDL, prompt, and done. I barely write complex queries myself anymore. Kinda weird, but, I get to watch more Lex Fridman podcasts now. LOL.

Do you guys do the same?

PostgreSQL

03 November 2025 01:42

Arman , try to write it down on your own language, than translate it to English. You may be speaking while your computer writes it down, and it is not working this way.

PostgreSQL

02 November 2025 22:44

Maybe it's just a newly developed language variant, that we, dinosauros, don't understand?

PostgreSQL

01 November 2025 17:25

You say im doing false?

PostgreSQL

12 November 2025 11:26

Hi Ram, I have sent a dm

PostgreSQL

11 November 2025 13:00

Looking for postgresql trainer anyone there pls ping me

PostgreSQL

07 November 2025 11:06

I want to connect my on prem postgres to adf but i can't use self hosted integration runtime and or any azure services, i have aleady have a vpn (office vpn) also this my main db, so there will be frequent read and write, so i want a prefect solution. Please

PostgreSQL

07 November 2025 05:03

trigger is part of automation isnt ? 😄

PostgreSQL

07 November 2025 03:44

😄 Any VARLENA type (like text, jsonb, or bytea) larger than TOAST_TUPLE_THRESHOLD / ~2 KB will automatically TOASTed. Try it by inserting a text value bigger than 2 KB.

then check toast table:

SELECT
c.relname AS main_table,
t.relname AS toast_table
FROM pg_class c
LEFT JOIN pg_class t ON c.reltoastrelid = t.oid
WHERE c.relname = 'your_sandbox_table';

PostgreSQL

04 November 2025 18:25

Read all release notes for all major releases in between, of course.

Also, make a lot of tests.

PostgreSQL

04 November 2025 18:08

Read every single major changelog between 12 and 17, and see if there are any particular notes about deprecated functions you might be still using or special upgrade steps

PostgreSQL

04 November 2025 18:06

We are planning to upgrade postgres’s 12 to 17 , could you please let us know is there any pre-migration steps need to follows?

PostgreSQL

04 November 2025 08:37

Bloom indexes have a very distinct use case. Many columns that are sparsely filled and get queried in unpredictable combinations. If your data is like that, you'll probably benefit. If it's not, bloom is probably not worth trying.

PostgreSQL

03 November 2025 09:19

Hi, try to look at citus extension, it can actually help you, but you need to do research by yourself

PostgreSQL

03 November 2025 05:31

Nope, SQL is not complex and I would do anything to avoid watching Lex Fridman podcast.

PostgreSQL

03 November 2025 05:02

Patiently waiting durov and musk to drop grok into telegram. So we can ditch this crap and have real productive talks.😅

PostgreSQL

02 November 2025 22:56

Your english is insanely non-sensial, please use another translation method from your native language for understandability.

PostgreSQL

01 November 2025 17:35

I don't understand your question.

PostgreSQL

01 November 2025 16:31

Sounds very much like trying to optimise something far to early.

For transaction reporting, I would have thought building the report from the *actual* transaction data is the most important. For auditability you want the least complexity here and definitely don't want duplicated data.

If you're so concerned by the 'size' of your main transaction record, then you're likely better off splitting that.

But it's very hard for people here to give any actual advice if you don't at least share table structures (via a pastebin site).