Re: [HACKERS] SpeedComparison

2006-02-12 Thread Tom Lane
Kenneth Marshall <[EMAIL PROTECTED]> writes: > If the heads of the disk are in the right location, you could easily do > more than 1 commit per disk revolution so the values over 2 seconds could > actually be valid. 9 seconds would be worst case of 1 commit per revolution. No, because a commit in

Re: [HACKERS] SpeedComparison

2006-02-12 Thread Mark Woodward
> On 2/11/06, Andrej Ricnik-Bay wrote: >> Has anyone here seen this one before? Do the values >> appear realistic? >> >> http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison > > The values appear to originate from an intrsinsically flawed test setup. > > Just take the first test. The database has t

Re: [HACKERS] SpeedComparison

2006-02-12 Thread Kenneth Marshall
On Sat, Feb 11, 2006 at 09:21:43PM +0100, Jochem van Dieten wrote: > On 2/11/06, Andrej Ricnik-Bay wrote: > > Has anyone here seen this one before? Do the values > > appear realistic? > > > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison > > The values appear to originate from an intrsinsic

Re: [HACKERS] SpeedComparison

2006-02-12 Thread Pavel Stehule
Andrej Ricnik-Bay wrote: > Has anyone here seen this one before? Do the values > appear realistic? > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison Some of the particularly bad test results for PostgreSQL may be related to using the default memory configuration and never having run ANALY

Re: [HACKERS] SpeedComparison

2006-02-11 Thread Jim C. Nasby
On Sat, Feb 11, 2006 at 08:06:56PM -0500, Tom Lane wrote: > Jochem van Dieten <[EMAIL PROTECTED]> writes: > > On 2/11/06, Andrej Ricnik-Bay wrote: > >> http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison > > > The values appear to originate from an intrsinsically flawed test setup. > > > Just ta

Re: [HACKERS] SpeedComparison

2006-02-11 Thread Tom Lane
Jochem van Dieten <[EMAIL PROTECTED]> writes: > On 2/11/06, Andrej Ricnik-Bay wrote: >> http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison > The values appear to originate from an intrsinsically flawed test setup. > Just take the first test. The database has to do 1000 commits. That > means 100

Re: [HACKERS] SpeedComparison

2006-02-11 Thread Peter Eisentraut
Andrej Ricnik-Bay wrote: > Has anyone here seen this one before? Do the values > appear realistic? > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison Some of the particularly bad test results for PostgreSQL may be related to using the default memory configuration and never having run ANALYZ

Re: [HACKERS] SpeedComparison

2006-02-11 Thread Jochem van Dieten
On 2/11/06, Andrej Ricnik-Bay wrote: > Has anyone here seen this one before? Do the values > appear realistic? > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison The values appear to originate from an intrsinsically flawed test setup. Just take the first test. The database has to do 1000 co

[HACKERS] SpeedComparison

2006-02-11 Thread Andrej Ricnik-Bay
Has anyone here seen this one before? Do the values appear realistic? http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings