Re: CREATE TABLE slowing down significantly over time

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

To: Anj Adu <fotographs@xxxxxxxxx>
Subject: Re: CREATE TABLE slowing down significantly over time
From: Robert Haas <robertmhaas@xxxxxxxxx>
Date: Mon, 9 Nov 2009 10:49:35 -0500
Cc: Aris Samad-Yahaya <aris@xxxxxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <f2fd819a0911090646w159e6e4bu309742528554068f@xxxxxxxxxxxxxx>
References: <008801ca6021$c1cc7630$45656290$@com> <18869.1257650960@xxxxxxxxxxxxx> <009601ca6030$0e731440$2b593cc0$@com> <603c8f070911081958sbac9712k15f50b80e5419d3c@xxxxxxxxxxxxxx> <f2fd819a0911090646w159e6e4bu309742528554068f@xxxxxxxxxxxxxx>

On Mon, Nov 9, 2009 at 9:46 AM, Anj Adu <fotographs@xxxxxxxxx> wrote:
> Why is reindex needed ?

VACUUM FULL does not fix index bloat, only table boat.

...Robert

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

References:
- CREATE TABLE slowing down significantly over time
  - From: Aris Samad-Yahaya
- Re: CREATE TABLE slowing down significantly over time
  - From: Tom Lane
- Re: CREATE TABLE slowing down significantly over time
  - From: Aris Samad-Yahaya
- Re: CREATE TABLE slowing down significantly over time
  - From: Robert Haas
- Re: CREATE TABLE slowing down significantly over time
  - From: Anj Adu

Prev by Date: Re: CREATE TABLE slowing down significantly over time
Next by Date: Re: random_page_cost for tablespace
Previous by thread: Re: CREATE TABLE slowing down significantly over time
Next by thread: Re: CREATE TABLE slowing down significantly over time
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux