On Tue, 30 Oct 2001, Antonio Fiol Bonnín wrote:
> AFAIK, sorting is necessary even when you have CLUSTERed a table using an index.
Sorting is not the performance constraint in my example. Just leave out
the sorting and see what happens ...
> But if you INSERT a single row later, it will NOT get inserted to the right place. So
> SORT is still necessary.
Well rearanging the database in a cronjob after inserting new data once a day
over night would be possible - but I doubt that it makes a big difference.
In response to
pgsql-hackers by date
|Next:||From: Tille, Andreas||Date: 2001-10-30 14:09:32|
|Subject: Re: Serious performance problem|
|Previous:||From: Tatsuo Ishii||Date: 2001-10-30 13:57:55|
|Subject: Re: pgsql-committers?|