Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Jan Wieck
On 2/20/2007 3:51 PM, Andrej Ricnik-Bay wrote: On 2/21/07, Guido Neitzer wrote: It would be more or less the same, if you compare copy against insert performance on PostgreSQL and state that insert should be as fast as copy without saying why. Btw: these guys claim to be database consultants.

Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Andrej Ricnik-Bay
On 2/21/07, Guido Neitzer wrote: It would be more or less the same, if you compare copy against insert performance on PostgreSQL and state that insert should be as fast as copy without saying why. Btw: these guys claim to be database consultants. Guess one should consider oneself lucky not to

Re: [GENERAL] Database performance comparison paper.

2007-02-20 Thread Guido Neitzer
Am 19.02.2007 um 17:49 schrieb Jan Wieck: Oh, this one wasn't about raw speed of trivial single table statements like all the others? No, it wasn't. They also tested the insert performance of a system without foreign keys and without transactions (MySQL MyISAM) against systems with forei

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Jan Wieck
On 2/16/2007 1:10 AM, Tom Lane wrote: extra points, use *only one* test case. Perhaps this paper can be described as "comparing an F-15 to a 747 on the basis of required runway length". Oh, this one wasn't about raw speed of trivial single table statements like all the others? Jan -- #===

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Geoffrey
Tom Allison wrote: Leif B. Kristensen wrote: On Friday 16. February 2007 07:10, Tom Lane wrote: Perhaps this paper can be described as "comparing an F-15 to a 747 on the basis of required runway length". There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Andrew Sullivan
On Sat, Feb 17, 2007 at 12:02:08AM +0100, Leif B. Kristensen wrote: > > There ought to be a proper name for this kind of pseudo-technical Gonzo > journalism. There is, but it's not the sort of word one uses in polite company ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reforma

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Tom Allison
Leif B. Kristensen wrote: On Friday 16. February 2007 07:10, Tom Lane wrote: Perhaps this paper can be described as "comparing an F-15 to a 747 on the basis of required runway length". There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The Internet is full of

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Guido Neitzer
Am 15.02.2007 um 13:05 schrieb Alexander Elgert: Nice, but it would be interesting which storage engine was used for mysql - ok, default is MyIsam. They used MyISAM as it is described late in the paper. cug ---(end of broadcast)--- TIP 4: Have

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Alexander Elgert
Richard Huxton schrieb: Shelby Cain wrote: Excerpt from the document: === 2. What is compared here - "Apples and Oranges" The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No op

Re: [GENERAL] Database performance comparison paper.

2007-02-18 Thread Alexander Elgert
Marc Evans schrieb: Some people may find this interesting reading. http://us.devloop.org.uk/ Nice, but it would be interesting which storage engine was used for mysql - ok, default is MyIsam. Does mysql (in the latest version) still use a single write-thread for writing? In mysql 3, a ba

Re: [GENERAL] Database performance comparison paper.

2007-02-16 Thread Leif B. Kristensen
On Friday 16. February 2007 07:10, Tom Lane wrote: > Perhaps this > paper can be described as "comparing an F-15 to a 747 on the basis of > required runway length". There ought to be a proper name for this kind of pseudo-technical Gonzo journalism. The Internet is full of it. -- Leif Biberg Kri

Re: [GENERAL] Database performance comparison paper.

2007-02-16 Thread Tom Lane
Ron Johnson <[EMAIL PROTECTED]> writes: > -BEGIN PGP SIGNED MESSAGE- >> Am 15.02.2007 um 11:21 schrieb Marc Evans: >> These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant >> databases. So why not compare an F-15 to 747? What? Apples and Oranges? > Bad analogy. Both the

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/15/07 15:29, Guido Neitzer wrote: > Am 15.02.2007 um 11:21 schrieb Marc Evans: > >> http://us.devloop.org.uk/ > > These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant > databases. So why not compare an F-15 to 747? What?

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Guido Neitzer
Am 15.02.2007 um 11:21 schrieb Marc Evans: http://us.devloop.org.uk/ These *peeep* [deleted] compared MySQL with MyISAM to ACID compliant databases. So why not compare an F-15 to 747? What? Apples and Oranges? So what? You can compare anything you want, right? Only the result mat

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Bill Moran
In response to Shelby Cain <[EMAIL PROTECTED]>: > Excerpt from the document: > === > 2. What is compared here - "Apples and Oranges" > The setups are as standard as can be. The only principle guiding the > installation of all the software is simpl

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Richard Huxton
Shelby Cain wrote: Excerpt from the document: === 2. What is compared here - "Apples and Oranges" The setups are as standard as can be. The only principle guiding the installation of all the software is simplicity. No optimization, no tweaks, no

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Alan Hodgson
On Thursday 15 February 2007 11:29, Shelby Cain <[EMAIL PROTECTED]> wrote: > === > 2. What is compared here - "Apples and Oranges" > The setups are as standard as can be. The only principle guiding the > installation of all the software is simplicit

Re: [GENERAL] Database performance comparison paper.

2007-02-15 Thread Shelby Cain
ary 15, 2007 12:21:03 PM Subject: [GENERAL] Database performance comparison paper. Some people may find this interesting reading. http://us.devloop.org.uk/ - Marc ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

[GENERAL] Database performance comparison paper.

2007-02-15 Thread Marc Evans
Some people may find this interesting reading. http://us.devloop.org.uk/ - Marc ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq