Joe, a Postgres query optimization bot

Re:Joe, a Postgres query optimization bot by aspyct on Sunday March 01, 2020 @01:25PM (#22458254)

Well you sure need a representative dataset to optimize your queries. Often, that means a replica of the production server, with real PII data in there.

[ Parent | on HN ]

Re:Joe, a Postgres query optimization bot by SahAssar on Sunday March 01, 2020 @02:39PM (#22458761)

I usually try to use mocked data as far as possible, but I guess the last validating step usually involves real data. Perhaps this can be used to optimize up to a certain point and then you can validate against production data as a last step.

[ Parent | on HN ]