Changes between Version 9 and Version 10 of P9

Timestamp:

05/28/26 00:56:58 (4 hours ago)

Author:

193284

Comment:

--

P9

@@ -187 +187 @@
   * booking tables are joined using hash joins because of the multiple LEFT JOIN operations
 
-* HashAggregate:
+* !HashAggregate:
   * aggregation is performed after all joins are completed
 
@@ -381 +381 @@
   * attendance records are matched with event and wedding relations
 
-* HashAggregate:
+* !HashAggregate:
   * PostgreSQL groups attendance rows by venue and wedding information
 
@@ -584 +584 @@
   * guests are matched with RSVP and attendance records
 
-* HashAggregate:
+* !HashAggregate:
   * PostgreSQL groups records by wedding and event before calculating conversion metrics
 
@@ -1295 +1295 @@
 || Hash Join || PostgreSQL builds a hash table to join larger datasets ||
 || Nested Loop || PostgreSQL repeatedly scans one relation for each row of another relation ||
-|| HashAggregate || PostgreSQL performs grouping and aggregation using a hash table ||
+|| !HashAggregate || PostgreSQL performs grouping and aggregation using a hash table ||
 || Sort || PostgreSQL sorts rows for ORDER BY or aggregation operations ||
 
 For Phase 6 reports, the most common expected elements are:
 * Hash Join
-* HashAggregate
+* !HashAggregate
 * Index Scan
 * Seq Scan on small tables