[aidos]

More recently I’ve got into the habit of creating a new schema when I’m analysing / patching data so I can pull out the data I need into new tables and index accordingly. Because I do it from vim and have a plugin to execute the queries, I just create a record as I go (and I set the path to hit my new schema first so any new tables go there).

[bshipp]

Ooooh, I like that idea a lot, especially since I can assign it a tablespace on a different drive.