3 ms·
Is there a way to force the temp table to have indices within the CTE definition?
by btown 4y ago
Is there a way to force the temp table to have indices within the CTE definition?
- srcreigh 4y agoNo, but this would make an incredible Postgres extension. (I’d also love one that lets Postgres use a covering index for primary storage. This can reduce data size and load less data off disk due to locality. MySQL has this by default and SQLite has it via WITHOUT ROWID tables.)