Re: table clustering brings joy - Mailing list pgsql-general

From Kevin Murphy
Subject Re: table clustering brings joy
Date
Msg-id 4302962C.5000709@genome.chop.edu
Whole thread Raw
In response to Re: table clustering brings joy  (Greg Stark <gsstark@mit.edu>)
Responses Re: table clustering brings joy  (Junaili Lie <junaili@gmail.com>)
List pgsql-general
Greg Stark wrote:

>All that said clustering is indeed often quite effective. Especially if it
>makes an index scan efficient enough to win over sequential scans you can see
>some huge effects. It's most useful for tables that aren't undergoing lots of
>updates and don't need to be reclustered often.
>
>
Which is my situation; most tables are read-only.  Thanks for the comments.

-Kevin

pgsql-general by date:

Previous
From: Matthew Terenzio
Date:
Subject: syntax error foreign key
Next
From: Matthew Terenzio
Date:
Subject: Re: syntax error foreign key