Postgres Pro
Downloads
Home   >   mailing lists

Re: slow insert into very large table - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow insert into very large table
Date
Msg-id 11195.1133452214@sss.pgh.pa.us
Whole thread Raw
In response to slow insert into very large table  (Wolfgang Gehner <wgehner@infonoia.com>)
List pgsql-performance
Tree view 
Wolfgang Gehner <wgehner@infonoia.com> 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

pgsql-performance by date:

Previous
From: "Markus Wollny"
Date:
Subject: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Next
From: Tom Lane
Date:
Subject: Re: 15,000 tables