Search Members Help

» Welcome Guest
[ Log In :: Register ]

 

[ Track This Topic :: Email This Topic :: Print this topic ]

 reply to topic new topic new poll
Topic: Postgre of MySQL< Next Oldest | Next Newest >
 Post Number: 1
whtdrgn_2 Search for posts by this member.
FNG
Avatar



Group: Members
Posts: 155
Joined: Dec. 2000
PostIcon Posted on: Dec. 19 2000,15:06  Skip to the next post in this topic. Ignore posts   QUOTE
We really neeed a Geek Stuff forum.

I have been experienceing some problems with MySQL and complete locking of the database. http://www.cantonrep.com gets a incredible high amount of hits, and they run on php and MySQL. Every once and a while the MySQL database will just lock up, and I have to kill -9 it. I have been investigating PostgreeSQL 7.0.3, and so far have been impressed. Row level locking, PL, triggers, and it allows varchar over 255 (not to mention word indexing).

My main question is: Can anyone tell me why I shouldn't use PostgreSQL 7.0.3? I am looking for anything that would stop my company from deploying the aformentioned site with PostgreSQL instead of MySQL.

Cr0, what do you use and why?

Thanks,

Offline
Top of Page Profile Contact Info WEB 
 Post Number: 2
RenegadeSnark Search for posts by this member.
Old School
Avatar



Group: Members
Posts: 534
Joined: May 2000
PostIcon Posted on: Dec. 19 2000,18:19 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
Don't ask cr0 questions about sql, because well, he just doesn't know.

Postgres is about twice as slow as MySQL on all of the standard queries, but it will handle a LOT MORE LOAD. MySQL is known to lock up/die when it has a (surprisingly small) number of active sessions.


Edit: I'm dumb, I wrote 'questions' instead of 'sessions' and hit enter outside of the edit box trying to fix it. Duh!

This message has been edited by RenegadeSnark on December 19, 2000 at 01:23 PM

Offline
Top of Page Profile Contact Info 
 Post Number: 3
whtdrgn_2 Search for posts by this member.
FNG
Avatar



Group: Members
Posts: 155
Joined: Dec. 2000
PostIcon Posted on: Dec. 19 2000,19:16 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
7.0.3 is supposed to be faster.
Offline
Top of Page Profile Contact Info WEB 
 Post Number: 4
whtdrgn_2 Search for posts by this member.
FNG
Avatar



Group: Members
Posts: 155
Joined: Dec. 2000
PostIcon Posted on: Dec. 20 2000,10:34 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
I had to cut taht last one short (boss was comming). Anyway, I had been reading benchmark after benchmark that says that PostgreSQL 7.0.3 is faster then the current stable of MySQL (I think that the Beta MySQL is faster then 7.0.3 - but comany policy states no beta). The PL is really what will sell it, I am just looking for someone to say. No don't use it because it will let any stupid hacker log in as root and rm -rf * your whole system.
Offline
Top of Page Profile Contact Info WEB 
 Post Number: 5
MattimeoZ80 Search for posts by this member.
Purveyor of Untimely Wisdom
Avatar



Group: Members
Posts: 397
Joined: Nov. 2000
PostIcon Posted on: Dec. 20 2000,14:10 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
who cares, they're both free, use whats easiest to set up. i got mysql and apache and php and mod_ssl running all fine together in about an hour. (after downloading)

------------------
Ah screw it.
-------------
ICEGAMING.COM

Offline
Top of Page Profile Contact Info WEB 
 Post Number: 6
whtdrgn_2 Search for posts by this member.
FNG
Avatar



Group: Members
Posts: 155
Joined: Dec. 2000
PostIcon Posted on: Dec. 20 2000,14:26 Skip to the previous post in this topic. Skip to the next post in this topic. Ignore posts   QUOTE
When you have to run a web site that a customer is paying you thousands of dollars a month for, you damn well better care about everything. There is no room for error. Cusotmers are more fickle then women, and they will drop a company that has 10 years of perfect service over one incedent. I have a script that compiles php Apache mod_ssl, and MySQL all in one go, and I can send the tar file to anyone who wants it. But that is not the issue. I was looking for constructive coments on the benefits / downfalls of using Postgre. Read my first post, I am having problems with MySQL under high load.
Offline
Top of Page Profile Contact Info WEB 
 Post Number: 7
MinscBoo Search for posts by this member.
FNG
Avatar



Group: Members
Posts: 35
Joined: Dec. 2000
PostIcon Posted on: Dec. 23 2000,01:47 Skip to the previous post in this topic.  Ignore posts   QUOTE
MySQL is supposedly faster than PostgreSQL, more complex, and more flexible. I would go with MySQL. In addition MySQL really has the support of the open source community right now and is maturing at a fast rate, but if PostgreSQL has the features you are looking for, I say go for it, it could never hurt to try.

Edit: I really need to read what I write after I write it...

This message has been edited by MinscBoo on December 22, 2000 at 08:50 PM

Offline
Top of Page Profile Contact Info WEB 
6 replies since Dec. 19 2000,15:06 < Next Oldest | Next Newest >

[ Track This Topic :: Email This Topic :: Print this topic ]


  		reply to topic new topic new poll

» Quick Reply Postgre of MySQL
iB Code Buttons
You are posting as:

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code