forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit5caa057
committed
Doc: update the "Using EXPLAIN" examples to match current code.
A lot of the examples in this section are quite ancient and nolonger match the system's current behavior. I ran through themand updated the sample output to match what I get today.Notably, it seems that the tenk1 table got a few pages smaller backaround v12, so that a lot of the cost estimates for queries on thattable are a little different now. (This also caused some examplesto surprisingly not match others, depending on when they were made.)One mergejoin-based example no longer produces the same plan at all,so I had to work around that, including switching to a differentexample of using an enable_xxx setting.I also changed a couple of examples that were relying on nonexistenttables or indexes. IMO the premise of this section is that theexamples should be more-or-less reproducible against the regressiondatabase, so that these examples were unhelpful as given. It's notthat hard to find a corresponding example with the tables we do have.Some of the EXPLAIN ANALYZE examples were out of date in that we showmore numbers than we did at the time.Possibly chapter 68 could use similar review, but I'm out ofenergy for today.1 parent6a126d9 commit5caa057
1 file changed
+150
-130
lines changed0 commit comments
Comments
(0)