Re: Perfomance Tuning

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>, "mixo" <mixo(at)coza(dot)net(dot)za>
Cc: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Perfomance Tuning
Date: 2003-08-13 06:47:03
Message-ID: 1f8901c36166$b50cf6b0$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> So, group the inserts in transactions with maybe 1000 commands each. It
> will go much faster. It can then cache the rows and in the end just make
> sure all 1000 have been written out on disk.

More than that, he should be using COPY - it's 10x faster than even grouped
inserts.

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2003-08-13 10:33:47 Re: Perfomance Tuning
Previous Message Dennis Björklund 2003-08-13 06:30:12 Re: Perfomance Tuning