Horton

Re: PostgreSQL clustering VS MySQL clustering

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

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Steve Wampler <swampler@noao.edu>
Cc: Hervé Piedvache <herve@elma.fr>, "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org
Date: 2005-01-20T15:57:43Z
Lists: pgsql-performance 
> 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'.

Chris