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 16:20:12 -0400
Message-ID: <36e682920706061320k6c8eb88etf8be1ce359feda11@mail.gmail.com> (raw)
In-Reply-To: <4667157C.5000208@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>
<36e682920706061101i5d3344c2idc518c6190b0af77@mail.gmail.com>
<4667157C.5000208@emolecules.com>
On 6/6/07, Craig James <craig_james@emolecules.com> wrote:
> You didn't read my message. I said that *BOTH* Oracle
> and Postgres performed well with table-per-customer.
Yes, I did. My belief is that Oracle can handle all customers in a
single table.
> The technical question is simple: Table-per-customer or
> big-table-for-everyone. The answer is, "it depends."
I agree, it does depend on the data, workload, etc. No
one-size-fits-all answer there.
> The reason I assert (and stand by this) that "They're
> blowing smoke" when they claim Oracle has the magic
> cure, is because Oracle and Postgres are both relational
> databases, they write their data to disks, and they both
> have indexes with O(log(N)) retrieval/update times. Oracle
> doesn't have a magical workaround to these facts,
> nor does Postgres.
Agreed that they are similar on the basics, but they do use
significantly different algorithms and optimizations. Likewise, there
is more tuning that can be done with Oracle given the amount of time
and money one has to spend on it. Again, cost/benefit analysis on
this type of an issue... but you're right, there is no "magic cure".
--
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: <36e682920706061320k6c8eb88etf8be1ce359feda11@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