News for hackers. Stuff that matters.
Re:Vertically Scaling PostgreSQL by aidos on Tuesday March 19, 2019 @02:17PM (#19433792)
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).
Re:Vertically Scaling PostgreSQL by bshipp on Tuesday March 19, 2019 @03:23PM (#19434631)
Ooooh, I like that idea a lot, especially since I can assign it a tablespace on a different drive.