topic Re: pgsql in Operating System - Linux

pgsql

jim cianciolo — Mon, 07 Mar 2005 13:08:21 GMT

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!

Re: pgsql

Alex Lavrov. — Mon, 07 Mar 2005 13:15:45 GMT

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.

Re: pgsql

jim cianciolo — Mon, 07 Mar 2005 13:23:57 GMT

great!! yes a 10!

Re: pgsql

Alex Lavrov. — Mon, 07 Mar 2005 13:29:34 GMT

:)

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 :-) )

Re: pgsql

jim cianciolo — Mon, 07 Mar 2005 13:35:30 GMT

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..

Re: pgsql

Alex Lavrov. — Mon, 07 Mar 2005 13:56:25 GMT

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 :)

Re: pgsql

jim cianciolo — Mon, 07 Mar 2005 14:32:16 GMT

good insight

Re: pgsql

Ted M Johnson_1 — Tue, 08 Mar 2005 09:42:16 GMT

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

Re: pgsql

Alex Lavrov. — Tue, 08 Mar 2005 09:48:02 GMT

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