Re: Feature suggestion : FAST CLUSTER - Mailing list pgsql-performance

From Alexander Staubo
Subject Re: Feature suggestion : FAST CLUSTER
Date
Msg-id 88daf38c0705271127x3fb1e83cp7d42e417cf046840@mail.gmail.com
Whole thread Raw
In response to Re: Feature suggestion : FAST CLUSTER  (PFC <lists@peufeu.com>)
Responses Re: Feature suggestion : FAST CLUSTER  (PFC <lists@peufeu.com>)
List pgsql-performance
On 5/27/07, PFC <lists@peufeu.com> wrote:
>         PostgreSQL humiliates InnoDB on CPU-bound workloads (about 2x faster
> since I run it on dual core ; InnoDB uses only one core). However, InnoDB
> can automatically cluster tables without maintenance.

How does it know what to cluster by? Does it gather statistics about
query patterns on which it can decide an optimal clustering, or does
it merely follow a clustering previously set up by the user?

Alexander.

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: Feature suggestion : FAST CLUSTER
Next
From: PFC
Date:
Subject: Re: Feature suggestion : FAST CLUSTER