Re: [PERFORM] Tests

2003-08-28 Thread Balazs Wellisch
Nicely done! Thanks, Balazs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomka Gergely Sent: Wednesday, August 27, 2003 5:40 AM To: [EMAIL PROTECTED] Subject: Re: [PERFORM] Tests http://mail.sth.sze.hu/~hsz/sql/ New, upgraded test results. As we s

Re: [PERFORM] The results of my PostgreSQL/filesystem performance tests

2003-08-28 Thread Balazs Wellisch
Bill, Very interesting results. I'd like to command you on your honesty. Having started out with the intentions of proving that FreeBSD is faster than Linux only to find that the opposite is true must not have been rewarding for you. However, these unexpected results serve only to reinforce the i

Re: [PERFORM] Benchmark

2003-08-15 Thread Balazs Wellisch
You might want to check out these links: http://www.loadtestingtool.com/download.html http://www.opensta.org/ http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/itsol utions/intranet/downloads/webstres.asp?frame=true http://www.softwareqatest.com/qatweb1.html Balazs -Origi

Re: [PERFORM] Tuning PostgreSQL

2003-07-26 Thread Balazs Wellisch
Since there seem to be a lot of different opinions regarding the various different RAID configurations I thought I'd post this link to the list: http://www.storagereview.com/guide2000/ref/hdd/perf/raid/index.html This is the best resource for information on RAID and hard drive performance I found

[PERFORM] Hardware performance

2003-07-16 Thread Balazs Wellisch
s, ideas, comments would be appreciated.   Thank you,   Balazs Wellisch Neu Solutions [EMAIL PROTECTED]  

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-13 Thread Balazs Wellisch
> There are many Linux and other OS distributions that will work just > fine. You may need to tweak a few kernel configuration parameters, but > that's not too difficult; see: > http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=kernel-resources.html > Yes, I looked at the online doc

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-13 Thread Balazs Wellisch
> The most important thing seems to be to increase shared_buffers. On my > RH7.3 machine here, Linux is configured with shmmax = 32MB which allows me > a value of just under 4000 for shared_buffers (3900 works, 3950 doesn't). > If your selects return large amounts of data, you'll probably also nee

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-13 Thread Balazs Wellisch
> On Sun, 2003-07-13 at 01:35, Balazs Wellisch wrote: > > Hi all, > > > > > > > > I’m in the process of initiating a movement in our company to move > > towards open source software use. As part of this movement I will be > > recommending PostgreSQL

Re: [PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-13 Thread Balazs Wellisch
> On Sunday 13 July 2003 12:05, Balazs Wellisch wrote: > > Hi all, > > However, to be able to justify the move I will have to demonstrate that > > PostgreSQL is up to par with MSSQL and MySQL when it comes to > > performance. After having read through the docs and the

[PERFORM] Pgsql - Red Hat Linux - VS MySQL VS MSSQL

2003-07-12 Thread Balazs Wellisch
Hi all,   I’m in the process of initiating a movement in our company to move towards open source software use. As part of this movement I will be recommending PostgreSQL as an alternative to the currently used MSSQL. I’m going with PostgreSQL over MySQL because of the much more complete f