Re: CREATE TABLE slowing down significantly over time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Aris Samad-Yahaya" <aris(at)quickschools(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: CREATE TABLE slowing down significantly over time
Date: 2009-11-08 03:29:20
Message-ID: 18869.1257650960@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Aris Samad-Yahaya" <aris(at)quickschools(dot)com> writes:
> I'm facing a problem where running a CREATE TABLE has slowed down
> significantly over time.

System catalog bloat maybe? What are your vacuuming practices?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2009-11-08 03:47:39 Re: CREATE TABLE slowing down significantly over time
Previous Message Aris Samad-Yahaya 2009-11-08 03:15:40 CREATE TABLE slowing down significantly over time