Citus 10 brings columnar compression to Postgres
Mar 6, 2021 ... ... 1,10000000) g; VACUUM (FREEZE, ANALYZE) events_2021_feb; Copy. Later ... SELECT COUNT(*) FROM events; -- parent table scans both partitions count ...
Tablesample and Other Methods for Getting Random Tuples ...
Sep 20, 2015 ... ... SELECT 'Record #' || i FROM generate_series(1, 1000000) i;. Considering the following SQL statement for selecting 10 random rows: SELECT ...
What's new in the Citus 10.2 extension to Postgres
Sep 17, 2021 ... Improved performance for lookup queries on columnar tables. CREATE INDEX on partitioned tables that have columnar partitions. One of the ...
Tablesample In PostgreSQL 9.5 - 2ndQuadrant | PostgreSQL
Aug 7, 2015 ... INSERT INTO ts_test (title) SELECT 'Record #' || i FROM generate_series(1, 1000000) i;. SYSTEM Table Sampling. In this example our aim is to ...
Planet PostGIS
-- 29768 rows SELECT Count(*) FROM srtm_12_03;. Those binary raster tiles aren't ... CREATE TABLE a AS SELECT generate_series(1,1000000) AS i ORDER BY random ...
On the benefits of sorted paths - 2ndQuadrant | PostgreSQL
Jul 12, 2016 ... ... generate_series(1,100000000) s(i);. and three additional tables have ... SELECT branch_id, SUM(amount) FROM t_10000 GROUP BY 1. and then ...
Tracing postgresql performance with perf
Nov 4, 2013 ... T1| regress=> create table x as select a FROM generate_series(1,1000000) a; T1| regress=> T2| $ ^C T2| [ perf record: Woken up 332 times to ...