Relational modeling, SQL, search, analytics, and data performance.
Schemas, constraints, indexes, query plans, and operations.
0 posts · 0 solvedQueries, joins, windows, aggregation, and reporting.
0 posts · 0 solvedFull-text retrieval, relevance, typo tolerance, and discovery.
1 posts · 1 solvedMetrics, cohorts, funnels, reporting, and data quality.
1 posts · 0 solvedI need search across article titles and long bodies. Users also type incomplete words and make small spelling mistakes. Code example At roughly 300,000 rows this query is slowing down. How would you choose between a GIN full text index and pg trgm ?
I have an accounts table with created at and an events table with account id and occurred at . I need a matrix where each row is a signup month and columns show the percentage active in months 0–6. The event table has roughly 40 million rows. A query shape and indexing advice would both help.
