Postgres Pro
Downloads
Home   >   mailing lists

Re: data addition speed or how to fast add data? - Mailing list pgsql-general

From Tom Lane
Subject Re: data addition speed or how to fast add data?
Date
Msg-id 20515.1021991107@sss.pgh.pa.us
Whole thread Raw
In response to data addition speed or how to fast add data?  ("Olonichev Sergei" <olonichev@scnsoft.com>)
List pgsql-general
Tree view 
"Olonichev Sergei" <olonichev@scnsoft.com> writes:
> Table:
> First column is size of table in kilobytes.
> Second - speed of COPY command.

> Size, Kb | Speed, Kb
> --------------------
> 137416
> 139856 2440
> 142260 2404
> 144624 2364
> 146936 2312
> 149220 2284

How did you measure these numbers, exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: monitoring running transaction
Next
From: Denis Perchine
Date:
Subject: Re: PostgreSQL 7.1 forces sequence scan when there is no reason