Quick questions:
For big tables with frequent insert, no update, and frequent read
(using indexes), will clustering help?
what should be done on such table other than regular analyze?
comments are appreciated.
On 8/16/05, Kevin Murphy <murphy@genome.chop.edu> wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>