On Monday 19 February 2007 11:58, Israel Shikler wrote: > Hi , > > I see your post here concerning PostgresQL. > We are using RedHat & Mysql. > Is there any advantages using PostgresQL over Mysql?
There are advantages both ways. You will need PostgreSQL when: 1) You need a database that can handle a very large load of queries per a small unit of time (secs,minutes). 2) You need a database that can handle transactions in an efficient manner, plus, you require a transactional system that has many features like save points in a middle of a transaction and you can role back to a savepoint instead of the whole transaction. 3) You need a very wide and extendable syntax and operations. 4) You need an RDBMS that can handle itself in catastrophies such as point in time recovery. i.e. using the transactions log to reconstract the last queries, etc... All of the above requires investment of resources which are wasted if you don't need those advantages. MySQL will serve you better for a small load of queries. It has a less extensive tranactional support. It's syntax is suited for smaller applications. Finally, PostgreSQL exists in various forms for 20 year so it is a beast of a thing that is very mature. MySQL has only matured in features in the last years. This race to features left much to be desired. There is no reason to use PostgreSQL for small apps or small load apps, in fact perhaps even MySQL is an overkill and there are even more efficient databases. > > Regards, > > Israel Shikler > Softkol Ltd > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tzahi Fadida > Sent: Monday, February 19, 2007 11:44 AM > To: Amos Shapira > Cc: Linux-IL > Subject: Re: PostgresQL database on raw partition (and something about > Access conversion) > > On Monday 19 February 2007 05:26, Amos Shapira wrote: > > Hello, > > > > Is it possible to configure PostgresQL to use raw disk partition, like > > Oracle does? > > If not - is there any recommendation for favourite filesystem type to > > use? > > Most certainly not. > PostgreSQL relies on the OS and FileSystems it inhabits for all I/O > operations. Raw partition are not worth the extra effort anycase on an OS > such as linux which is already efficient with files and extents of those > files. If you want you can use XFS to increase efficiency at the expense of > more chance for data loss in case of a crash since it has a large caching > mechanisms. You can also use raid to increase performance. Additionally you > may try to put the transactions log, which is the bottleneck in databases, > on > a ram memory that is backed by a battery. I think i saw a battery PCI card > at > asus for 50$. Add 128mb ram and you are good to go. > > > So far google'ing around haven't revealed anything about the subject. > > > > And BTW - I found the following link which also mentions procedures to > > convert MS Access databases to Psql: > > http://www.postgresql.org/docs/techdocs.3 > > > > Cheers, > > > > --Amos > > -- > Regards, > Tzahi. > -- > Tzahi Fadida > Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info > WARNING TO SPAMMERS: see at > http://members.lycos.co.uk/my2nis/spamwarning.html > > ================================To unsubscribe, send mail to > [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
