4 ms·
The MS SQL Server is on a different, older, cheaper machine. The PostgreSQL one is faster because it's newer and we had budget for it. We also have two differe
by elchief 12y ago
The MS SQL Server is on a different, older, cheaper machine. The PostgreSQL one is faster because it's newer and we had budget for it.
We also have two different database teams (actually more, it's a large company): IT controls the data warehouse (MS SQL) and BI controls the analysis server (PG)
As juliangoldsmith anticipated, we use PGStrom (also a FDW) so we can use our GPU for super fast scans.