Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2001-01-02 Thread Gordan Bobic
> Advanced tools do have advanced safety features, but are sold "ready > for most use", not "safely disabled until you read all of the manuals > so you can figure out how to make it work decently". I agree that > reading the manuals is an important part of learning a new tool, > but it shouldn't b

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2001-01-02 Thread Gordan Bobic
[tuning analogies snipped] > > Likewise with self-proclaimed computer tuners. You have no idea how much I agree with you there. > > I really don't understand why people expect computers to do everything > > for them, the burden of using tools properly belongs to the user. > > I of course agree i

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Marten Feldtmann
"Dominic J. Eidson" schrieb: > > ... > > What if I do a SELECT to check for a row. Then I do a INSERT. But between > > SELECT and INSERT someone else inserted a row. NO I do not think that "good > > programming" will solve this. > > Good design, together with good implementation, gets you a lo

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Ron Chmara
John Burski wrote: > > I really don't understand why people expect computers to do everything > > for them, the burden of using tools properly belongs to the user. > Let the congregation say "Amen!" The counterpoints: (Complex tool) A car comes assembled, from the factory, tuned to accelerate, a

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Ron Chmara
Jarmo Paavilainen wrote: > > Just curious, what kind of tables did you set up in MySQL? My > Ehh... there are more than one kind... I did not know. Still with > transactions on PostgreSQL (unsafe method?) MySQL was 2 times as fast as > PostgreSQL. I will check this out, and return to this list wi

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread John Burski
> > > > I really don't understand why people expect computers to do everything > for them, the burden of using tools properly belongs to the user. > Let the congregation say "Amen!" -- John Burski Chief IT Cook and Bottlewasher 911 Emergency Products, St. Cloud, MN (320) 656 0076 www.911ep

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Lamar Owen
Alfred Perlstein wrote: > Lamar Owen wrote: > > But, then again, if the default settings are so bad performance-wise, > > why _are_ they the default anyway? There should be good reason, of > > course, but I think maybe the defaults could or should be revisited as > > to applicability. > I can un

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Alfred Perlstein
* Lamar Owen <[EMAIL PROTECTED]> [001229 13:13] wrote: > Jarmo Paavilainen wrote: > > I run both MySQL and PostgreSQL as they are (minimum switches, no tuning, as > > default as it can be). That is MySQL as the .rpm installed it > > (--datadir --pid-file --skip-locking) and PostgreSQL with -i -S -