Thank you! Can you please help me with any advantages/disadvantages.. my db size is less than 10gb. I am very new to this.
At 10GB you are unlikely to hit performance limitations that make you think about how to use PostgreSQL more effectively. You will have to avoid doing the sorts of things you want to avoid doing on all databases.
DB2 and PostgreSQL are both very feature-rich databases but in somewhat different directions. For example, DB2 has more storage options than PostgreSQL does. But again at 10GB it is unlikely you will have to worry about these.
Where PostgreSQL really shines is in generally workload tuning and programmability. Especially programmability. PostgreSQL is extremely extensible and this means not only can you build your own extensions for whatever you need to do (assuming some skill) but there are tons of extensions you can use for free including great ones like PostGIS.
Generally you can expect at 10GB to have to avoid needless complexity like repeated sequential scans. Indexing becomes a bit important. By 100GB you have to pay significant attention to index strategies and disk access. I am aware of single databases of up to 50TB in size used in production and federated storage environments into the petabytes.
In general I can think of no reason not to use PostgreSQL unless your salary depends on paying license fees....
On 08/19/2018 10:53 AM, Sonam Sharma wrote: > > > > > I am planning to migrate my db from db2 to postgresql. Before that I > wanted to know is postgresql better than db2? Is it completely free ? > Any performance issues or any limitations?
