PostgreSQL

28 Aug 2025 10:05

Hi all, I wrote an article about searching on multiple columns in Postgres. It is written step-by-step from a very easy scenario all the way to a final complex one. I tried to write it from bottom up, that is, to explain every step, function and possibility of some not-so-obvious results. Feedback welcome :-D Enjoy!

https://aboutbits.it/blog/2025-08-27-multicolumn-search-in-postgres

ps. Thx @NickBluth for your valuable input.

PostgreSQL

27 Aug 2025 15:56

Those are my questions.... These are the ways we can add constraints + partitioning using pg_partman.

PostgreSQL

27 Aug 2025 15:54

Which part's link you want?

PostgreSQL

27 Aug 2025 15:28

"What is similarity? A bag of arbitrary distances..." 🧛‍♂️

PostgreSQL

27 Aug 2025 15:10

Thanks, I will think about your suggestion

PostgreSQL

27 Aug 2025 14:26

Hi all, I am currently writing an article, and I am wondering if the following explanation (in not too complicated/detailed words) is correct. I want to explain this SQL:

create extension pg_trgm;
create index person_name_idx on person using gin(name gin_trgm_ops);

PostgreSQL

25 Aug 2025 09:26

Hi Folks, with the f**** happening over at bitnami, anyone aware If there are plans to provide Helmcharts for PostgreSQL *from* PostgreSQL??

PostgreSQL

21 Aug 2025 19:17

Ssd vs. spinning rust? 🤔

PostgreSQL

20 Aug 2025 18:41

[vibe]hacking Postgres online with Andrey, Kirk https://www.youtube.com/watch?v=3MleDtXZUlM – it's live, join! Session 3 of implementing "merge" for btree in Postgres (because now it has has only split) following Lanin&Shasha paper from 1986

(and today Andrey promises some good progress and first code!)

PostgreSQL

17 Aug 2025 13:45

Any openings for postgresql in bangalore

PostgreSQL

14 Aug 2025 21:17

well, it so happens that this user now threatens and tries to harass me with two different accounts. Dunno what's wrong with people.

PostgreSQL

14 Aug 2025 16:57

https://www.postgresql.org/about/news/postgresql-176-1610-1514-1419-1322-and-18-beta-3-released-3118/

There you go

PostgreSQL

14 Aug 2025 12:29

17.6 was committed 3 days ago at git repo

PostgreSQL

13 Aug 2025 23:27

Why do we even bother? Just ban them

PostgreSQL

13 Aug 2025 21:23

DBA Stop spamming people in DMs.

PostgreSQL

27 Aug 2025 15:58

But as you have asked, here it is. Check the 1st section


https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman_howto.md#simple-time-based-1-partition-per-day

PostgreSQL

27 Aug 2025 15:55

Well, both, if you ask :)

PostgreSQL

27 Aug 2025 15:51

Mind adding a link to where in the docs you read about this?

PostgreSQL

27 Aug 2025 15:28

Hi all,

I'm reading pg_partman's document to understand the difference between below 2 cases but I'm unable to get it. Could someone please help me to understand it.
I know that template table is used as some of the properties of parent table don't get propagated to the child table by default.

1. Adding the partition key column in primary/unique constraint during table creation.

Vs

2. Creating a partition table without a primary/unique constraint.
Then create a template table.
Add primary/unique constraint to the template table.

PostgreSQL

27 Aug 2025 15:09

Sounds reasonable. Or revert the order to something like
"To teach a GIN index to break name into trigrams and to map operators like like or % (similarity operator) to use those trigrams, we must first install the extension and create the index like this: [...]"

PostgreSQL

25 Aug 2025 09:37

Hi i am Giving postgresql DBA offline interview suport in Hyderabad, call:8309555894

PostgreSQL

21 Aug 2025 20:18

Does anyone had recently issues with libpq5 on rhel systems? In my case rhel 9 with PostgreSQL 16. I found and old mail thread from 2021 with the same issue but I haven't enough working brain cells left for today to debug it further 🙈

PostgreSQL

21 Aug 2025 16:13

hello all, almost same servers, same write read statiticts of disk, almost same tables, index, size etc but one of doing datafileread with 500mb/s the other 50mb/s, what I am missing?

PostgreSQL

18 Aug 2025 08:19

Hi i am Giving postgresql DBA offline interview suport in Hyderabad, call:8309555894

PostgreSQL

14 Aug 2025 21:42

Years of mssql did a number.

PostgreSQL

14 Aug 2025 19:21

[vibe]hacking Postgres online with Andrey, Kirk https://www.youtube.com/watch?v=Ib3SXSFt8mE – it's live, join! Today we continue looking deeper at btree (aka nbtree) and see if we can implement merge (because now we have only split; so we're trying to close the gap with original Lanin&Shasha paper from 1986 https://dl.acm.org/doi/10.5555/324493.324589)

PostgreSQL

14 Aug 2025 12:30

Usually announce mailing list notify it around 15 pm cest

PostgreSQL

14 Aug 2025 10:20

Hello, today is 14.08, is it to expect release 17.6?

PostgreSQL

13 Aug 2025 21:44

Why are you spamming? DM on telegram is dominated by social engineering scammers. I report DMs from unknown people without wasting a second.

PostgreSQL

13 Aug 2025 19:47

Postgesql document please share me