From: Jonah H. Harris <jonah.harris@gmail.com>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Thousands of tables versus on table?
Date: Wed, 6 Jun 2007 14:15:48 -0400
Message-ID: <36e682920706061115i4f77c55ale3ecad5aaa31512@mail.gmail.com> (raw)
In-Reply-To: <4666EF9D.90500@emolecules.com>
References: <C289C6B1.A63%tandrews@soliantconsulting.com>
<Pine.LNX.4.64.0706041631490.11737@asgard.lang.hm>
<466593E5.1010904@g2switchworks.com>
<87sl96z0wf.fsf@oxford.xeocode.com>
<Pine.LNX.4.64.0706051325500.24361@asgard.lang.hm>
<10525.1181080765@sss.pgh.pa.us>
<Pine.LNX.4.64.0706051507120.24361@asgard.lang.hm>
<4666DF99.3010809@emolecules.com>
<4666E5A0.40604@g2switchworks.com>
<4666EF9D.90500@emolecules.com>
On 6/6/07, Craig James <craig_james@emolecules.com> wrote:
> Last time I checked, Oracle didn't have anything close to this.
When did you check, 15 years ago? Oracle has direct-path
import/export and data pump; both of which make generic COPY look like
a turtle. The new PostgreSQL bulk-loader takes similar concepts from
Oracle and is fairly faster than COPY.
Don't get me wrong, I'm pro-PostgreSQL... but spouting personal
observations on other databases as facts just boasts an
PostgreSQL-centric egotistical view of the world. If you don't tune
Oracle, it will suck. If you don't understand Oracle architecture
when you tune an application, it will suck; just like PostgreSQL.
People who don't have extensive experience in the other databases just
hear what you say and regurgitate it as fact; which it is not.
Look at how many people in these lists still go on and on about MySQL
flaws based on their experience with MySQL 3.23. Times change and it
doesn't do anyone any good to be ignorant of other databases. If
you're going to speak about another database in a comparison, please
stay current or specify the database you're comparing against.
This is nothing against you, but it always starts an avalanche of,
"look how perfect we are compared to everyone else."
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
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-performance@postgresql.org
Cc: jonah.harris@gmail.com, craig_james@emolecules.com
Subject: Re: Thousands of tables versus on table?
In-Reply-To: <36e682920706061115i4f77c55ale3ecad5aaa31512@mail.gmail.com>
* 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