6 ms·
> our main data warehouse is on MS SQL Server, but not super fast MSSQL on similar capacity hardware as PostgreSQL? Is the data restructured once in PG for spe
by bsg75 12y ago
> our main data warehouse is on MS SQL Server, but not super fast
MSSQL on similar capacity hardware as PostgreSQL? Is the data restructured once in PG for specific queries?
Curious as to why MSSQL is slower given it has some advantages for data warehouse workloads such as query parallelism?
- juliangoldsmith 12y agoHe may be using GPU acceleration, with something like PGStrom.
- elchief 12y agoThe 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.