Home > mailing lists

Re: CREATE TABLE slowing down significantly over time - Mailing list pgsql-performance

From	Grzegorz Jaśkiewicz
Subject	Re: CREATE TABLE slowing down significantly over time
Date	November 9, 2009 04:40:41
Msg-id	2f4958ff0911090040v11389c9dud0787b0de4836a2a@mail.gmail.com Whole thread Raw
In response to	Re: CREATE TABLE slowing down significantly over time (Robert Haas <robertmhaas@gmail.com>)
List	pgsql-performance

On Mon, Nov 9, 2009 at 3:58 AM, Robert Haas <robertmhaas@gmail.com> 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

From: Robert Haas
Date: 08 November 2009, 23:59:03
Subject: Re: CREATE TABLE slowing down significantly over time

From: Robert Haas
Date: 09 November 2009, 08:22:14
Subject: Re: CREATE TABLE slowing down significantly over time