Re: Equivalent praxis to CLUSTERED INDEX?
От
Christopher Kings-Lynne
Тема
Re: Equivalent praxis to CLUSTERED INDEX?
Дата
Msg-id
412D39E1.2040304@familyhealth.com.au
Ответ на
Equivalent praxis to CLUSTERED INDEX? (Mischa Sandberg)
Список
Дерево обсуждения
Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg <mischa.sandberg@telus.net>
Re: Equivalent praxis to CLUSTERED INDEX? "J. Andrew Rogers" <jrogers@neopolitan.com>
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian <pgman@candle.pha.pa.us>
Re: Equivalent praxis to CLUSTERED INDEX? "J. Andrew Rogers" <jrogers@neopolitan.com>
Re: Equivalent praxis to CLUSTERED INDEX? "Jim C. Nasby" <decibel@decibel.org>
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg <ischamay.andbergsay@activestateway.com>
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus <josh@agliodbs.com>
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg <ischamay.andbergsay@activestateway.com>
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus <josh@agliodbs.com>
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola <mendola@bigfoot.com>
Re: Equivalent praxis to CLUSTERED INDEX? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg <ischamay.andbergsay@activestateway.com>
> I see that PG has a one-shot CLUSTER command, but doesn't support > continuously-updated clustered indexes. > > What I infer from newsgroup browsing is, such an index is impossible, > given the MVCC versioning of records (happy to learn I'm wrong). > > I'd be curious to know what other people, who've crossed this same > bridge from MSSQL or Oracle or Sybase to PG, have devised, > faced with the same kind of desired performance gain for retrieving > blocks of rows with the same partial key. I just run clusterdb each weekend in a cron job... Chris
В списке pgsql-performance по дате отправления
