Re: PostgreSQL clustering VS MySQL clustering

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: PostgreSQL clustering VS MySQL clustering
Дата
Msg-id 41EFD4F7.1040900@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: PostgreSQL clustering VS MySQL clustering  (Steve Wampler <swampler@noao.edu>)
Ответы Re: PostgreSQL clustering VS MySQL clustering
Список 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 по дате отправления:

Предыдущее
От: amrit@health2.moph.go.th
Дата:
Сообщение: Which PARAMETER is most important for load query??
Следующее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: PostgreSQL clustering VS MySQL clustering