Skip site navigation (1) Skip section navigation (2)

Re: Large databases, performance

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Cc: "pankaj M(dot) Tolani" <pankaj(at)pspl(dot)co(dot)in>
Subject: Re: Large databases, performance
Date: 2002-10-03 16:35:24
Message-ID: 3D9CBF24.4516.AA1560C@localhost (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performancepgsql-sql
On 3 Oct 2002 at 12:26, Robert Treat wrote:

> On Thu, 2002-10-03 at 12:17, Shridhar Daithankar wrote:
> > On 3 Oct 2002 at 11:57, Robert Treat wrote:
> > May be it's time to rewrite famous myth that postgresql is slow. 
> 
> That myth has been dis-proven long ago, it just takes awhile for
> everyone to catch on ;-)

:-)

> Hmm... been awhile since I dug into mysql internals, but IIRC once the
> table was locked, you had to wait for the insert to complete so the
> table would be unlocked and the select could go through. (maybe this is
> a myth that I need to get clued in on)

If that turns out to be true, I guess mysql will nose dive out of window.. May 
be time to run a test that's nearer to real world expectation, especially in 
terms on concurrency..

I don't think tat will be an issue with mysql with transaction support. The 
vanilla one might suffer.. Not the other one.. At least theoretically..

> My thinking was that if your just doing inserts, you need to update the
> statistics but don't need to check on unused tuples. 

Any other way of doing that other than vacuum analyze? I thought that was the 
only way..

Bye
 Shridhar

--
"Even more amazing was the realization that God has Internet access.  Iwonder 
if He has a full newsfeed?"(By Matt Welsh)


In response to

pgsql-performance by date

Next:From: Manfred KoizarDate: 2002-10-03 16:44:09
Subject: Re: Large databases, performance
Previous:From: Shridhar DaithankarDate: 2002-10-03 16:30:18
Subject: Re: [HACKERS] Large databases, performance

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-10-03 16:36:01
Subject: Re: anoncvs and diff
Previous:From: Shridhar DaithankarDate: 2002-10-03 16:30:18
Subject: Re: [HACKERS] Large databases, performance

pgsql-sql by date

Next:From: Manfred KoizarDate: 2002-10-03 16:44:09
Subject: Re: Large databases, performance
Previous:From: Shridhar DaithankarDate: 2002-10-03 16:30:18
Subject: Re: [HACKERS] Large databases, performance

pgsql-general by date

Next:From: Bruce MomjianDate: 2002-10-03 16:37:03
Subject: Re: schemas in 7.3b1
Previous:From: Shridhar DaithankarDate: 2002-10-03 16:30:18
Subject: Re: [HACKERS] Large databases, performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group