PostgreSQL

04 September 2025 21:11

What is the best channel on YouTube to watch advance topics

PostgreSQL

04 September 2025 19:02

There might be other issues of course - anything that corrupts data in the OS or hardware could also corrupt an index.

PostgreSQL

04 September 2025 18:56

Perhaps you have upgraded the version of glibc(?) and that changed the sorting weights so that indexes are invalid? If so it is necessary to immediately reindex or else things like that can happen.

PostgreSQL

01 September 2025 16:16

(row or column-level filtering may require specific versions)

PostgreSQL

01 September 2025 16:11

You can of course make a physical replica and create a logical replica from it. Synchronisation of switching from that replica to the primary might be tricky but perhaps something could be done with slots if they exist that far back.

In my experience your best bet is to remove or exclude indexes from the structural backup and add any necessary after the initial replica is created. Importing large tables with many resulting index updates can be very slow vs. just creating the index after.

PostgreSQL

01 September 2025 11:47

Hi I am looking for a course please let me know if any one

PostgreSQL

28 August 2025 10:27

Ah! The wording input! ;-)

PostgreSQL

28 August 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 August 2025 15:56

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

PostgreSQL

27 August 2025 15:54

Which part's link you want?

PostgreSQL

27 August 2025 15:28

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

PostgreSQL

27 August 2025 15:10

Thanks, I will think about your suggestion

PostgreSQL

27 August 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 August 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 August 2025 19:17

Ssd vs. spinning rust? 🤔

PostgreSQL

04 September 2025 21:08

Index is currently being used and is not invalid. If I insert the duplicate record it will not allow.

PostgreSQL

04 September 2025 18:57

Fixing it can be tricky, because you may need to target the invalid data without using an index. There are debug settings you can use to prevent e.g. index scans being used. https://www.postgresql.org/docs/15/runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE

PostgreSQL

04 September 2025 18:49

I found that postgres is having some problem with the primary key as it violate sometimes and duplicate records are created in the table. Has anyone else observed the same. I am using postgres 15.7. Is there any solution to this problem pls let me know.

PostgreSQL

01 September 2025 16:15

You could also exclude some data, possibly, if you don't need a complete replica for your purposes. Maybe some tables (or columns/rows within them) are unnecessary, merely containing transient data of temporary use.

PostgreSQL

01 September 2025 12:02

Question regard logical replication in version 10-13:
is it possible to set up the replication from pg_basebackup instead of waiting for the CREATE SUBSCRIPTION to start sync initial data?
what are my options to make the replica be ready as fast as possible?

PostgreSQL

28 August 2025 10:30

Hi All ,

I am looking for Postgresql 17 pre and post installation standards on windows. Can any one share ref docs please..

PostgreSQL

28 August 2025 10:25

You're welcome, albeit I don't remember giving input ;-)

PostgreSQL

27 August 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 August 2025 15:55

Well, both, if you ask :)

PostgreSQL

27 August 2025 15:51

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

PostgreSQL

27 August 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 August 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 August 2025 09:37

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

PostgreSQL

21 August 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 August 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?