Postgres Pro
Downloads
Home   >   mailing lists

Re: Index size - Mailing list pgsql-general

From Tom Lane
Subject Re: Index size
Date
Msg-id 4322.1109730368@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index size  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Index size  (Ioannis Theoharis <theohari@ics.forth.gr>)
List pgsql-general
Tree view 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> So it seems Ioannis' number was not taken immediately after a CREATE
> INDEX operation?

I would guess not, but it's up to him to say.  If it is a number derived
after some period of normal operation, then his result agrees with the
theory that says 70% is the steady-state figure ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Index size
Next
From: Keith Tsao
Date:
Subject: Replication from other SQL Server