Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Feature suggestion : FAST CLUSTER
- From: "Alexander Staubo" <alex(at)purefiction(dot)net>
- To: PFC <lists(at)peufeu(dot)com>
- Cc: "Jim C. Nasby" <decibel(at)decibel(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Feature suggestion : FAST CLUSTER
- Date: Sun, 27 May 2007 20:27:31 +0200
On 5/27/07, PFC <lists(at)peufeu(dot)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.
- Follow-Ups:
- Re: Feature suggestion : FAST CLUSTER
- From: PFC
- Re: Feature suggestion : FAST CLUSTER
- References:
- Feature suggestion : FAST CLUSTER
- From: PFC
- Re: Feature suggestion : FAST CLUSTER
- From: Jim C. Nasby
- Re: Feature suggestion : FAST CLUSTER
- From: PFC
- Feature suggestion : FAST CLUSTER
- Prev by Date: Re: Feature suggestion : FAST CLUSTER
- Next by Date: Re: Feature suggestion : FAST CLUSTER
- Previous by thread: Re: Feature suggestion : FAST CLUSTER
- Next by thread: Re: Feature suggestion : FAST CLUSTER
- Indexes: