Re: big database with very small dump !?

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: big database with very small dump !?
Date: 2008-08-12 11:49:44
Message-ID: 48A178D8.30004@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joao Ferreira gmail wrote:
> On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote:
>
> If I try cluster, I'm guessing I'll choose the big index and forget
> about the smaller ones... is this right ?
>

CLUSTER will sort out all the indexes, even though you're just
clustering on on.

--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ries van Twisk 2008-08-12 12:13:35 Re: different results based solely on existence of index (no, seriously)
Previous Message Joao Ferreira 2008-08-12 11:49:04 text .vs. varchar