Re: Large databases, performance

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Large databases, performance
Date: 2002-10-03 17:38:49
Message-ID: 1033666730.28946.64.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance pgsql-sql

On Thu, 2002-10-03 at 11:17, Shridhar Daithankar wrote:
> On 3 Oct 2002 at 11:57, Robert Treat wrote:
>
[snip]
> > I'm curious, did you happen to run the select tests while also running
> > the insert tests? IIRC the older mysql versions have to lock the table
> > when doing the insert, so select performance goes in the dumper in that
> > scenario, perhaps that's not an issue with 3.23.52?
>
> IMO even if it locks tables that shouldn't affect select performance. It would
> be fun to watch when we insert multiple chunks of data and fire queries
> concurrently. I would be surprised if mysql starts slowing down..

What kind of lock? Shared lock or exclusive lock? If SELECT
performance tanked when doing simultaneous INSERTs, then maybe there
were exclusive table locks.

--
+------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "What other evidence do you have that they are terrorists, |
| other than that they trained in these camps?" |
| 17-Sep-2002 Katie Couric to an FBI agent regarding the 5 |
| men arrested near Buffalo NY |
+------------------------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Pfau 2002-10-03 17:40:30 Re: schemas in 7.3b1
Previous Message Justin Clift 2002-10-03 17:28:39 Re: [HACKERS] Anyone want to assist with the translationof the

Browse pgsql-hackers by date

  From Date Subject
Next Message Manfred Koizar 2002-10-03 17:39:44 Re: Correlation in cost_index()
Previous Message Justin Clift 2002-10-03 17:28:39 Re: [HACKERS] Anyone want to assist with the translationof the

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2002-10-03 20:55:35 Re: [HACKERS] Large databases, performance
Previous Message Hans-Jürgen Schönig 2002-10-03 16:58:26 unsubscribe

Browse pgsql-sql by date

  From Date Subject
Next Message Edoardo Causarano 2002-10-03 19:34:24 Rule creation
Previous Message Tom Lane 2002-10-03 17:09:38 Re: drop constraint primary key