Skip site navigation (1) Skip section navigation (2)

Re: CLUSTER command

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-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?



In response to

pgsql-performance by date

Next:From: Michael EngelhartDate: 2002-12-12 22:50:55
Subject: PerformPortalClose warning in 7.3
Previous:From: Jean-Luc LachanceDate: 2002-12-12 22:39:44
Subject: Re: [PERFORM] CLUSTER command

pgsql-interfaces by date

Next:From: Michael EngelhartDate: 2002-12-12 22:50:55
Subject: PerformPortalClose warning in 7.3
Previous:From: Jean-Luc LachanceDate: 2002-12-12 22:39:44
Subject: Re: [PERFORM] CLUSTER command

pgsql-general by date

Next:From: Michael EngelhartDate: 2002-12-12 22:50:55
Subject: PerformPortalClose warning in 7.3
Previous:From: Timothy GrantDate: 2002-12-12 22:44:13
Subject: Re: Restoring a pg_dumped file...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group