All that said, our customers demand that we use MSSQL. The issue there is the way PK's are used -- they have to be generated as non-clustered or else PK index scans will eat up CPU, which then clogs execution memory space, etc. My takeaway is that whatever backend we use demands accommodation of some sort.


Hank you may not realize that Postgres uses non-clustered primary keys. I mean that every index is non-clustered - I don't believe there is a clustered index in postgres. Just saying!

Johnf