Re: PostgreSQL clustering VS MySQL clustering - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 41EFD4F7.1040900@familyhealth.com.au
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Steve Wampler <swampler@noao.edu>)
Responses Re: PostgreSQL clustering VS MySQL clustering
List 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

pgsql-performance by date:

Previous
From: amrit@health2.moph.go.th
Date:
Subject: Which PARAMETER is most important for load query??
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering