PostgreSQL

17 November 2025 00:32

Then, you can query using the <@ operator

PostgreSQL

17 November 2025 00:27

How would u design a chat app?
Like i made something like user(id, name, etc…)
Chat(id, name)
Message( chat_id, user_id, etc..)
But i don’t know how to implement like group permissions (owner, admin…)
Or showing the messages of a group for a user before leaving the group

PostgreSQL

14 November 2025 11:55

random_page_cost = 4

PostgreSQL

14 November 2025 11:54

You could probably determine the "point of indifference" quite easily now...

PostgreSQL

14 November 2025 11:53

I assume it thinks it's gonna return many rows so better do a seq scan anyway

PostgreSQL

14 November 2025 11:52

Index scan backwards?
Planner realizes that the PK and the timestamp are strongly correlated and assumes it will match your searched timestamp quicker that reading one or two block ranges of 128 pages each, I guess.

PostgreSQL

14 November 2025 11:40

Did you try with >= and < instead? Maybe the planner just doesn't realize it can use the BRIN index for BETWEEN?

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

17 November 2025 00:30

Have a table "joins" that tracks visibility, with chat_id, user_id, and the "timestamptz" between join and leave (which might not have a upper bound if the user is still inside). https://www.postgresql.org/docs/current/rangetypes.html

PostgreSQL

14 November 2025 11:56

Ah nvm i confused it with seq_page_cost, which is currently 1.0

PostgreSQL

14 November 2025 11:55

Try set enable_seqscan off and compare the costs.

PostgreSQL

14 November 2025 11:54

Seems reasonable. Index access + reading 128 blocks per range is a lot of random IO.

PostgreSQL

14 November 2025 11:53

Using created_at > '2024-11-13', i get a seq scan, even though i have

29577096 rows created before that date
8652158 rows created after

PostgreSQL

14 November 2025 11:51

Ah, it's using the pkey now

PostgreSQL

14 November 2025 11:37

I have a TABLE containing logs that looks something like this:

CREATE TABLE IF NOT EXISTS lm.log
(
    id bigint NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
    created_at timestamp with time zone NOT NULL,
    content text COLLATE pg_catalog."default" NOT NULL,
    file_position bigint NOT NULL,
    file_id bigint NOT NULL,
    CONSTRAINT log_pkey1 PRIMARY KEY (created_at, file_position, file_id),
    CONSTRAINT log_file_id_fkey FOREIGN KEY (file_id)
        REFERENCES lm.file (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
        NOT VALID
)

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?