Re: data addition speed or how to fast add data?

cd $PGDATA
while (( 1 )); do du -k .../searchdb; sleep 30; done


Sergei

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Olonichev Sergei" <olonichev@scnsoft.com>
Cc: <pgsql-general@postgresql.org>
Sent: 21 мая 2002 г. 17:25
Subject: Re: [GENERAL] data addition speed or how to fast add data?


> "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