Works best on desktop. I'm guessing that some things get spun down when cold. It would be more helpful if I knew configurations, because this postgresql-indexed is returning abysmally slow to what...
Works best on desktop.
I'm guessing that some things get spun down when cold.
It would be more helpful if I knew configurations, because this postgresql-indexed is returning abysmally slow to what I'd expect, especially relative to MSSQL (edit: Oh MSSQL is configured for column store for this table, that explains). Running a local postgres instance on my little micro workstation, and I'm getting aggregate queries of similiar dataset size in half the time or less.
The big takeaway if not a DB person: Column databases rock for aggregates. Row databases rock for picking out individual rows.
DB performance is also so incredibility variant based on load it's a bit of a crapshoot.
Still, it's interesting, and I'm still playing instead of writing the SQL I should be.
Works best on desktop.
I'm guessing that some things get spun down when cold.
It would be more helpful if I knew configurations, because this postgresql-indexed is returning abysmally slow to what I'd expect, especially relative to MSSQL (edit: Oh MSSQL is configured for column store for this table, that explains). Running a local postgres instance on my little micro workstation, and I'm getting aggregate queries of similiar dataset size in half the time or less.
The big takeaway if not a DB person: Column databases rock for aggregates. Row databases rock for picking out individual rows.
DB performance is also so incredibility variant based on load it's a bit of a crapshoot.
Still, it's interesting, and I'm still playing instead of writing the SQL I should be.