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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Olonichev Sergei" <olonichev(at)scnsoft(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: 21 мая 2002 г. 17:25
Subject: Re: [GENERAL] data addition speed or how to fast add data?

> "Olonichev Sergei" <olonichev(at)scnsoft(dot)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