Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2006-03-09 Thread Merlin Moncure
> > Background: > > 1. I read people were using PostGreSQL with TeraBytes of data > > sometimes, or thousands of users. These are things that could easily > > break SQL Server. - So I thought PostGreSQL might be similar fast to > > SQL Server. 2. I did some tests: Windows XP SP2 > > Several GIGs fr

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2006-03-07 Thread Russ Brown
On Thu, 25 Nov 2004 11:36:33 +0100 "Robert Soeding" <[EMAIL PROTECTED]> wrote: > Hi, this is my first question here, and also, it's somewhat delicate. > So please be patient. > My question is, CAN PostGreSQL perform in the SQL Server area when it > comes to speed? In other words, are there explan

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Richard Huxton
Shridhar Daithankar wrote: Do we have some sort of document about how caching on windows works? It is very simple on linux and BSDs but for other OSs, I haven't seen many suggestions. I am sure OS specific hints would help OP a lot. Microsoft's own resources are good for this sort of stuff (apol

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Shridhar Daithankar
On Thursday 25 Nov 2004 6:22 pm, Richard Huxton wrote: > > On the other hand, if an application has to "fight" against the file > > system, I would suppose it to increase RAM and CPU usage > > significantly. > > It shouldn't be fighting the file system, but it does use it, and rely > on it for cac

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Richard Huxton
Robert Soeding wrote: 1. What configuration changes have you made? None, both installations are default configured. You'll want to do at least some tuning on PG. Try the URL below for a quick introduction - just the basic stuff is a good start. http://www.varlena.com/varlena/GeneralBits/Tidbits/p

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Robert Soeding
mailto:[EMAIL PROTECTED] Sent: Thursday, November 25, 2004 12:34 PM To: Robert Soeding Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server Robert Soeding wrote: > Hi, this is my first question here, and also, it's somewhat delicate. > So please be

Re: [GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Richard Huxton
Robert Soeding wrote: Hi, this is my first question here, and also, it's somewhat delicate. So please be patient. My question is, CAN PostGreSQL perform in the SQL Server area when it comes to speed? In other words, are there explanations for the results I found (see below)? Faster in some cases, s

[GENERAL] Benchmark-Comparison PostGreSQL vs. SQL Server

2004-11-25 Thread Robert Soeding
ï Hi, this is my first question here, and also, it's somewhat delicate. So please be patient.   My question is, CAN PostGreSQL perform in the SQL Server area when it comes to speed? In other words, are there explanations for the results I found (see below)?   Thanks, Robert