Re: Partitioning options

Hi, Justin. The example link has self-contained DDL to create the partitions (in flat vs composite mode for comparison) and then making the FK's on each showing the marked speed difference for the same net number of partitions (1200 flat vs 80x15 = 1200 composite): https://www.postgresql.org/messa

How to schema-qualify "IS DISTINCT FROM" on trigger definition? (I created a db that cannot be dump/restored)

I've created a database which my vendor (Supabase) cannot dump/restore/upgrade. Ultimately, it comes down to this trigger statement, and the fact that the underlying operations needed to perform the `IS DISTINCT FROM` comparison in the WHEN clause need to be found in the `public` schema. During the

Re: How to schema-qualify "IS DISTINCT FROM" on trigger definition? (I created a db that cannot be dump/restored)

Vick Khera writes: > I've created a database which my vendor (Supabase) cannot > dump/restore/upgrade. Ultimately, it comes down to this trigger statement, > and the fact that the underlying operations needed to perform the `IS > DISTINCT FROM` comparison in the WHEN clause need to be found in the

Discover PostgreSQL's Graph Power with Apache AGE!

Hello PostgreSQL Community, Excited to share how Apache AGE enhances PostgreSQL with smooth graph features! Handles complex data, and supports SQL and Cypher. Join our awesome community, check tutorials, and let's dive into those data projects! More info.: Apache AGE GitHub

How do you optimize the disk IO when you cannot assume a file will start at a boundary then?

Hi All, I understand the storage layer in databases goes to great lengths to ensure: - a row does not cross a block boundary - read/writes/allocation happen in units of blocks etc. The motivation is that at the OS level, it reads and writes pages (blocks), not individual bytes. I am only concerned