On Mon, 29 Apr 2019 at 19:20, Shai Cantor wrote:
> Some notes I haven't shared or were not clear enough on the previous post.
>
> Data is inserted using the copy command only and in an offline manner.
> Meaning, no user action creates or updates the data. An offline job runs is.
> Number of inse
Thanks a lot for your feedback.
We're gonna user PG 11 on AWS RDS.
I will do some workload simulations.
Some notes I haven't shared or were not clear enough on the previous post.
1. *Data is inserted using the copy command only* and in an offline
manner. Meaning, no user action creates or up
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?
Before PG11 the query planner pruned unneeded par
- *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