From: Roberto Mello <rmello@cc.usu.edu>
To: Mathijs Brands <mathijs@ilse.nl>
Cc: beloshapka@mnogo.ru
Cc: pgsql-php@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?)
Date: Mon, 19 Nov 2001 08:35:47 -0700
Message-ID: <20011119083547.A22031@cc.usu.edu> (raw)
In-Reply-To: <20010418202814.B16143@ilse.nl>
References: <B5CDCF382265D311BF33009027A8FE9401E6F3BC@pmrmsg.edsn.com>
<5.0.2.1.0.20010418223233.00a68170@mail.e-magine.com.au>
<20010418073430.B12408@cc.usu.edu>
<20010418164436.A41431@ilse.nl>
<20010418085424.A13383@cc.usu.edu>
<20010418173727.A5021@rakete.joerdens.de>
<20010418202814.B16143@ilse.nl>
On Wed, Apr 18, 2001 at 08:28:14PM +0200, Mathijs Brands wrote:
>
> I've seen both MySQL and PostgreSQL give up (MySQL just hung, pgsql
> cored) when I tried simple selects from a couple of hundred concurrent
> connections; no transactions or other fancy stuff there. I think I was
> using MySQL 3.22.?? and pgsql 6.5.3, so more modern versions may well be
> able to cope with these numbers of connections. It's been more than a
> year since I last tried it.
PG 7.0 was released almost 2 years ago, so you had a very old version when
you tried.
> I don't know what the current state of affairs is, but it is my
> understanding that, while pgsql performs admirably on tasks which mostly
> read data, pgsql isn't really able to cope (performance wise) with an
> application that has a very high insert to select ratio, such as OLTP.
This is simply not true. It may have been true in the past, but not since
PG 7.0 came out.
A mistake that I see MySQL users do frequently is that when they have a
bulk of inserts to do, they don't use the COPY command to bulk load the
data and/or they don't wrap the inserts into one (or several) transaction
blocks, leaving each INSERT in its own transaction, which obviously will
hurt performance.
They do that because they usually have no idea of what a database is for,
besides being an SQL interface to their file systems. Exactly what MySQL
was until very recently (and thanks to the work of third-parties, because
the MySQL team itself couldn't care less about real features).
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
TAFB -> Text Above Fullquote Below
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, mathijs@ilse.nl, beloshapka@mnogo.ru, pgsql-php@postgresql.org
Subject: Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?)
In-Reply-To: <20011119083547.A22031@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox