Re: PostgreSQL clustering VS MySQL clustering

Joshua D. Drake <jd@commandprompt.com>

View thread

From: "Joshua D. Drake" <jd@commandprompt.com>

To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

Cc: Steve Wampler <swampler@noao.edu>, Hervé Piedvache <herve@elma.fr>, pgsql-performance@postgresql.org

Date: 2005-01-20T16:04:04Z

Lists: pgsql-performance

Attachments

jd.vcf (text/x-vcard)

Christopher Kings-Lynne wrote:

>> Probably by carefully partitioning their data.  I can't imagine anything
>> being fast on a single table in 250,000,000 tuple range.  Nor can I
>> really imagine any database that efficiently splits a single table
>> across multiple machines (or even inefficiently unless some internal
>> partitioning is being done).
>
>
> Ah, what about partial indexes - those might help.  As a kind of 
> 'semi-partition'.

He could also you schemas to partition out the information within the 
same database.

J

>
> Chris



-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL