Re: Thousands of partitions performance questions

2019-04-29 Thread Shai Cantor
t; On Mon, 29 Apr 2019 at 17:13, Shai Cantor wrote: > > Will the db hold 135000 (45000 * 3 months) partitions under the > assumption that I query only 1 partition? > > Should I model it differently in terms of schema, partitions etc.? > > Which PG version? > > Befor

Thousands of partitions performance questions

2019-04-28 Thread Shai Cantor
- *General* - Our system gathers data from CI builds regarding a customer's code base - *Data includes* - type - methods/lines/branches A.K.A - code elements - files - *Queries* - The data is queried for a specific build only - Queries are