pgsql

[jim cianciolo]

i am building a pgsql database. does anyone
know if their is any logical limitation on the
database size? my / is 65 gig and i have
/var/lib/ under root. is this to big or
will it just grow to 30-40-50-etc.. gig if i let it.

thanks!

[Alex Lavrov. · Accepted solution]

Me again :)

Here you can find some very usefull info:
http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.4

According to this document, it's unlimited.

[jim cianciolo]

great!! yes a 10!

[Alex Lavrov.]

:)

A little offtopic question.

Why do you use postgresql? Usually MySQL databases are smaller (if the same amount data compared, ofcourse) and MySQL almost 10 times faster than Postgre.

Also, MySQL is way more popular than Postgre, so it's supported in more programs and it's really easy to find support for all kind of problems in the future.

(No, I don't work for MySQL :-) )

[jim cianciolo]

this was not buy choice......when i setup
hp insight manager for linux this is is what
they have choosen. i was not really familiar
with pgsql..

[Alex Lavrov.]

Oh, I see, it's for insight manager.

A little trivia facts:

Once, it was based on mysql database, I installed it before it was called Insight Manager. But then, mysql became GPL, it means that every product that uses mysql has 2 choises:
1. Become GPL too
2. If not GPL, then it must pay for mysql

Well, obviously HP prefered to go postgre, because it's still free and not GPL.

enjoy :)

[jim cianciolo]

good insight

[Ted M Johnson_1]

MySQL is offered under multiple licenses.
There is no requirement for a product using MySQL to release its code under the GPL.

[Alex Lavrov.]

http://www.mysql.com/company/legal/licensing/opensource-license.html