Image by ElasticComputeFarm

Data sampling in PostgreSQL

Working with big data you often have to apply different sampling techniques for your analysis — select a representative subset of data to identify patterns and trends in the larger data set. For example, if you need to pull a subset of some type of returning/not active/churned/etc users for a specific product and then to profile them, or simply randomly choose some user distribution % for any deep-dive analysis.