I think maybe a SAN in conjunction with tablespaces might be the answer. Still need one honking server.
Rick
Stephen Frost
<[EMAIL PROTECTED]> To: Christopher
Kings-Lynne <[EMAIL PROTECTED]>
Sent by: cc: Hervé
Piedvache <[EMAIL PROTECTED]>, pgsql-performance@postgresql.org
[EMAIL PROTECTED] Subject: Re: [PERFORM]
PostgreSQL clustering VS MySQL clustering
tgresql.org
01/20/2005 10:08 AM
* Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
> PostgreSQL has replication, but not partitioning (which is what you
want).
It doesn't have multi-server partitioning.. It's got partitioning
within a single server (doesn't it? I thought it did, I know it was
discussed w/ the guy from Cox Communications and I thought he was using
it :).
> So, your only option is Oracle or another very expensive commercial
> database.
Or partition the data at the application layer.
Stephen
(See attached file: signature.asc)
signature.asc
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
