On Fri, 20 Sep 2002, Shridhar Daithankar wrote:
On 20 Sep 2002 at 21:22, Shridhar Daithankar wrote:
Mysql takes 221 sec. v/s 1121 sec. for postgres. For postgresql,
that is around 11.5K rows per second. Each tuple has 23 fields with
fixed length of around 100 bytes
Yes, postgres is much
Have you tried this with Oracle or similar commercial database?
I have timed COPY/LOAD times for Postgresql/Mysql/Oracle/Db2 -
the rough comparison is :
Db2 and Mysql fastest (Db2 slightly faster)
Oracle approx twice as slow as Db2
Postgresql about 3.5-4 times slower than Db2
However
On 20 Sep 2002 at 18:41, Nigel J. Andrews wrote:
On Fri, 20 Sep 2002, Shridhar Daithankar wrote:
In select test where approx. 15 rows where reported with query on index field,
mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues
eclipse the result..
I don't
On 20 Sep 2002 at 10:27, Mike Benoit wrote:
On Fri, 2002-09-20 at 08:52, Shridhar Daithankar wrote:
Besides there is issue of space. Mysql takes 1.4GB space for 1.2GB text data
and postgresql takes 3.2GB of space. Even with 40 bytes per row overhead
mentioned in FAQ, that should come
Hi all,
While testing for large databases, I am trying to load 12.5M rows of data from
a text file and it takes lot longer than mysql even with copy.
Mysql takes 221 sec. v/s 1121 sec. for postgres. For postgresql, that is around
11.5K rows per second. Each tuple has 23 fields with fixed
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Shridhar
Daithankar
Sent: Friday, September 20, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: [HACKERS] Improving speed of copy
Hi all,
While testing for large databases, I am trying to load 12.5M rows of data
from
a text file
On 20 Sep 2002 at 21:22, Shridhar Daithankar wrote:
Mysql takes 221 sec. v/s 1121 sec. for postgres. For postgresql, that is around
11.5K rows per second. Each tuple has 23 fields with fixed length of around 100
bytes
I wrote a programs which does inserts in batches but none of thme
Also, did you disable fsync?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jonah H. Harris
Sent: Friday, September 20, 2002 10:15 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Improving speed of copy
Are you using copy within
On Fri, 2002-09-20 at 08:52, Shridhar Daithankar wrote:
Besides there is issue of space. Mysql takes 1.4GB space for 1.2GB text data
and postgresql takes 3.2GB of space. Even with 40 bytes per row overhead
mentioned in FAQ, that should come to around 1.7GB, counting for 40% increase
in
On Fri, 20 Sep 2002, Shridhar Daithankar wrote:
In select test where approx. 15 rows where reported with query on index field,
mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues
eclipse the result..
I don't know about anyone else but I find this aspect strange.
Nigel J. Andrews wrote:
On Fri, 20 Sep 2002, Shridhar Daithankar wrote:
In select test where approx. 15 rows where reported with query on index field,
mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues
eclipse the result..
I don't know about anyone else but I find
11 matches
Mail list logo