AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
How to Migrate to a Postgres Database System
Performance is a big part of some of these migrations. If you've got thousands of different queries going through your system, a few of them are probably going to be slower in Postgres than Oracle without some tuning. So it's quite common for that to be a part. We'll if fair, SQL Server and Oracle optimization code is much more complex, sophisticated, bigger than Postgres. It doesn't mean that in Postgres we cannot make things work well. And it's improving also. But on the other side, Oracle has hints and tendency to use them quite a lot.