Re: slow insert into very large table

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

To: Wolfgang Gehner <wgehner@xxxxxxxxxxxx>
Subject: Re: slow insert into very large table
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 01 Dec 2005 10:50:14 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to Wolfgang Gehner <wgehner@xxxxxxxxxxxx> message dated "Thu, 01 Dec 2005 13:33:21 +0100"
In-reply-to: <438EED91.9080302@xxxxxxxxxxxx>
References: <438EED91.9080302@xxxxxxxxxxxx>

Wolfgang Gehner <wgehner@xxxxxxxxxxxx> writes:
> This is with PostgreSQL 8.0 final for WindowsXP on a Pentium 1.86 GHz, 
> 1GB Memory. HD is fast IDE.

Try something more recent, like 8.0.3 or 8.0.4.  IIRC we had some
performance issues in 8.0.0 with tables that grew from zero to large
size during a single session.

			regards, tom lane

References:
- slow insert into very large table
  - From: Wolfgang Gehner

Prev by Date: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Next by Date: Re: 15,000 tables
Previous by thread: Re: slow insert into very large table
Next by thread: 15,000 tables
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