| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: CLUSTER command |
| Date: | 2002-12-12 22:49:12 |
| Message-ID: | 5.1.0.14.1.20021213063727.0278b270@mbox.jaring.my |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces pgsql-performance |
Splitting table files by indexed value may not help if the operating system
doesn't manage to keep the tables unfragmented on disk. I suppose the O/S
should know how to do it though.
Cheerio,
Link.
At 04:31 PM 12/12/02 -0500, Jean-Luc Lachance wrote:
>Hi all,
>
>I just read about the cluster command and was a little (very)
>disapointed.
>Clustered tables do not remain clustered after inserts.
>Clustered tables are usefull when the table is very large and there are
>few different keys.
>
>
>Because the table file is already extended (2G limit) using different
>files extension (.N)
>how complicated (modifying the code) would it be to have the table files
>split according to the cluster key?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Engelhart | 2002-12-12 22:50:55 | PerformPortalClose warning in 7.3 |
| Previous Message | Timothy Grant | 2002-12-12 22:44:13 | Re: Restoring a pg_dumped file... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Engelhart | 2002-12-12 22:50:55 | PerformPortalClose warning in 7.3 |
| Previous Message | Jean-Luc Lachance | 2002-12-12 22:39:44 | Re: [PERFORM] CLUSTER command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Engelhart | 2002-12-12 22:50:55 | PerformPortalClose warning in 7.3 |
| Previous Message | Jean-Luc Lachance | 2002-12-12 22:39:44 | Re: [PERFORM] CLUSTER command |