Re: CREATE TABLE slowing down significantly over time

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

To: Robert Haas <robertmhaas@xxxxxxxxx>
Subject: Re: CREATE TABLE slowing down significantly over time
From: Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
Date: Mon, 9 Nov 2009 08:40:30 +0000
Cc: Aris Samad-Yahaya <aris@xxxxxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <603c8f070911081958sbac9712k15f50b80e5419d3c@xxxxxxxxxxxxxx>
References: <008801ca6021$c1cc7630$45656290$@com> <18869.1257650960@xxxxxxxxxxxxx> <009601ca6030$0e731440$2b593cc0$@com> <603c8f070911081958sbac9712k15f50b80e5419d3c@xxxxxxxxxxxxxx>

On Mon, Nov 9, 2009 at 3:58 AM, Robert Haas <robertmhaas@xxxxxxxxx> wrote:

And maybe REINDEX, too.

yup, nevermind the mess in table, indices are getting fscked much quicker than table it self, because of its structure.

--
GJ

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

Prev by Date: Re: CREATE TABLE slowing down significantly over time
Next by Date: Re: CREATE TABLE slowing down significantly over time
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