|
|
|
|
|
|
by jhd3
1362 days ago
|
|
|
I was wondering if anyone had thought about using this to experiment with the planner. The engineering and support teams at Greenplum, a fork of Postgres, have a tool (minirepro[0]) which, given a sql query, can grab a minimal set of DDLs and the associated statistics for the tables involved in the query that can then be loaded into a "local" GPDB instance. Having the DDL and the statistics meant the team was able to debug issues in the optimizer (example [1]), without having access to a full set of data. This approach, if my understanding is correct, could be enabled in the browser with this Postgres WASM capability. [0] https://github.com/greenplum-db/gpdb/blob/6X_STABLE/gpMgmt/b... [1] https://github.com/greenplum-db/gpdb/issues/5740#issuecommen... (has an example output) |
|
|