Re: [GENERAL] Partitioning and Table Inheritance

2017-05-12 Thread Andrew Staller
Hi Paul, How much of your data is time-series in nature? Put another way, is there a timestamp coupled with the inserted data? Andrew On Fri, May 12, 2017 at 4:38 PM, Ivan E. Panchenko < i.panche...@postgrespro.ru> wrote: > Hi > > > 12.05.2017 23:22, Justin Pryzby пишет: > >> On Mon, May 08, 20

Re: [GENERAL] Large data and slow queries

2017-04-21 Thread Andrew Staller
avel...@gmail.com> wrote: > Andrew, how would timescaledb compare to citus - and is timescaledb an > extension to postgres or is it an entirely separate system? > > On 21 April 2017 at 02:44, Andrew Staller wrote: > > Awesome thread. > > > > Samuel, >

Re: [GENERAL] Large data and slow queries

2017-04-20 Thread Andrew Staller
Awesome thread. Samuel, Just wanted you to be aware of the work we're doing at TimescaleDB ( http://www.timescale.com/), a time-series database extension for PostgreSQL. Some of how we might help you: - automatic partitioning by space (primary key - like country_id, for instance) and time. This