Re: slow insert into very large table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wolfgang Gehner <wgehner(at)infonoia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow insert into very large table
Date: 2005-12-01 15:50:14
Message-ID: 11195.1133452214@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Wolfgang Gehner <wgehner(at)infonoia(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-01 16:03:42 Re: 15,000 tables
Previous Message Markus Wollny 2005-12-01 15:49:14 Queries taking ages in PG 8.1, have been much faster in PG<=8.0