Search Postgresql Archives

Re: Index bloat of 4x

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Ed L." <pgsql@xxxxxxxxxxxxx>
Subject: Re: Index bloat of 4x
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 19 Jan 2007 12:45:03 -0500
Cc: Csaba Nagy <nagy@xxxxxxxxxxxxxx>, Postgres general mailing list <pgsql-general@xxxxxxxxxxxxxx>, Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx>, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>
Comments: In-reply-to "Ed L." <pgsql@xxxxxxxxxxxxx> message dated "Fri, 19 Jan 2007 10:19:52 -0700"
In-reply-to: <200701191019.52768.pgsql@xxxxxxxxxxxxx>
References: <20070117093223.bcdb302e.wmoran@xxxxxxxxxxxxxxxxxxxxxxx> <200701181842.00696.pgsql@xxxxxxxxxxxxx> <1169197877.11526.10.camel@xxxxxxxxxxxxxxxxxxxxxx> <200701191019.52768.pgsql@xxxxxxxxxxxxx>

"Ed L." <pgsql@xxxxxxxxxxxxx> writes:
> Online index creation definitely helps us toward 24x7.  But 
> wouldn't we still have to drop the old index, thus blocking 
> production queries?

Yes, but only for a very short period.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Index bloat of 4x
  - From: Jeremy Haile

References:
- Index bloat of 4x
  - From: Bill Moran
- Re: Index bloat of 4x
  - From: Ed L.
- Re: Index bloat of 4x
  - From: Csaba Nagy
- Re: Index bloat of 4x
  - From: Ed L.

Prev by Date: Re: trigger question
Next by Date: Re: Can't use passwords for users
Previous by thread: Re: Index bloat of 4x
Next by thread: Re: Index bloat of 4x
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux