Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

pgsql

SOLVED
Go to solution
jim cianciolo
Occasional Advisor

pgsql

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!
8 REPLIES
Alex Lavrov.
Honored Contributor
Solution

Re: pgsql

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.
I don't give a damn for a man that can only spell a word one way. (M. Twain)
jim cianciolo
Occasional Advisor

Re: pgsql

great!! yes a 10!
Alex Lavrov.
Honored Contributor

Re: pgsql

:)

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 :-) )
I don't give a damn for a man that can only spell a word one way. (M. Twain)
jim cianciolo
Occasional Advisor

Re: pgsql

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

Re: pgsql

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 :)
I don't give a damn for a man that can only spell a word one way. (M. Twain)
jim cianciolo
Occasional Advisor

Re: pgsql

good insight
Ted M Johnson_1
Frequent Advisor

Re: pgsql

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

Re: pgsql

http://www.mysql.com/company/legal/licensing/opensource-license.html
I don't give a damn for a man that can only spell a word one way. (M. Twain)