Auto partitioning on Postgresql – Part 1

We will share a simple approach to migrate existing tables to partitioned versions of them with Postgresql. The partitions will be created on demand with just a few lines of codes. It is useful during off-line migration, and can be used in production with applications that don’t do so much INSERT. Approach Let’s say you […]

Read more

Search engine vs Database in BI part 1: data structure

BI apps face a real data deluge these days. The engineers need new approaches to deal with this. Is a search engine, well known for handling humongous data sets, adapted to a BI context ? Business intelligence is the science of gathering and structuring data to help making decisions. We will call Business Intelligence BI […]

Read more