Rails: Postgres Native Partitioning

After researching for a while, most everything I read recommended using native declarative postgres partitioning for performance reasons.Faster WritesThe old way of partitioning involved triggers to put data in the right table. Native partitioning doesn't do this. No triggers means faster writes. Every little bit adds up.Faster ReadsYou don't just get faster writes though. Reads are also faster (sometimes). Native knowledge of partitioning means faster reads because postgres can use query conditions to prune partitions that wouldn't have matching data.For both reads and writes, the fastest query is the one you don't make.
Rails: Postgres Native Partitioning #ruby #rails #rubyonrails #bosnia #programming #tutorials #rubydeveloper #railsdeveloper

Nezir Zahirovic

Contractor Ruby On Rails (7+ years) / MCPD .Net / C# / Asp.Net / CSS / SQL / (11 years)

related articles