[GENERAL] Re: DB2 on Linux beats MS where would postgres end up?

[Gordon Runkle]

In article 033f01c0de0d$ce93fcc0$230470d1@INSPIRON, Dave Cramer
[EMAIL PROTECTED] wrote:

 http://www.zdnet.com/zdnn/stories/news/0,4586,2760874,00.html?chkpt=zdnn0516
 01
 
 It would be great if we could see where postgres fits in this benchmark

There are lies, damned lies, and benchmarks.

That said (or shamelessly cribbed from Disraeli),
I have found that for my current application (an
auditing system for the transportation industry),
PostgreSQL is 2-4 times faster than DB2 UDB 7.1
for most of our queries.  To say that I was suprised
is an understatement (no offense to the PostgreSQL
crew).

The database has a couple dozen tables, the
largest is just over 1GB with 3.5 million rows.
The database as a whole is over 6GB.

This is running PostgreSQL 7.1 under RedHat 7.1
(it was true under RH 6.2, also).

Hardware is an IBM Netfinity 7000 (4xPPro200/1M)
with 1.5GB RAM and two RAID-5E arrays.  My customer
is running on a Dell PowerEdge 2400 (2xPIII 866)
with 512MB RAM with a RAID-1 and a RAID-10 array.
This one is amazingly fast!

As always, your mileage may vary, contents may
have settled during shipment, and objects in
mirror are closer than they appear.

Gordon.
-- 
It doesn't get any easier, you just go faster.
   -- Greg LeMond

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[GENERAL] RE: MS SQL 7.0 to PostgreSQL 7.1

[Gordon Runkle]

In article 08CD1781F85AD4118E0800A0C9B8580B094A74@NEZU, Jeff Eckermann
[EMAIL PROTECTED] wrote:

 Also:
 * Watch out for embedded tabs and carriage returns in your data: these
 will cause problems during or after your COPY into PostgreSQL. *  Check
 the value used in the exported file to represent NULL values (could be
 an empty string, or NULL, or something else), and use that in your
 COPY statement: COPY table from stdin with null as 'whatever';

My experience is that MSSQL7 will export (bcp) NULLs
as an ASCII zero character.  Not pretty.  You'll want
to put together a little PERL script to fix that.

Gordon.
-- 
It doesn't get any easier, you just go faster.
   -- Greg LeMond

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster