Postgresql

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?

Yes, yes, depends

--
Adrian Klaver
adrian.klaver@aklaver.com

Thank you! Can you please help me with any advantages/disadvantages.. my db
size is less than 10gb. I am very new to this.

On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 08/19/2018 10:56 AM, Sonam Sharma wrote:

Thank you! Can you please help me with any advantages/disadvantages.. my
db size is less than 10gb. I am very new to this.

I would start here:

https://www.postgresql.org/about/

On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

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?

Yes, yes, depends

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

On Aug 19, 2018, at 10:56, Sonam Sharma <sonams1209@gmail.com> wrote:

Thank you! Can you please help me with any advantages/disadvantages.. my db size is less than 10gb. I am very new to this.

That's a topic far too broad for a simple mailing list thread. PostgreSQL is extremely feature-complete, but how it performs on any particular database will vary considerably.

The good news is that for a database of that size, it's easy to install it and test it against your workload. That's really the only practical way of telling if it will be suitable for you.

--
-- Christophe Pettus
xof@thebuild.com

On Sun, Aug 19, 2018 at 7:57 PM Sonam Sharma <sonams1209@gmail.com> wrote:

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 Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

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?

Yes, yes, depends

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Best Wishes,
Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more

You might find this comparision useful:
https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html