From: | "Olonichev Sergei" <olonichev(at)scnsoft(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: data addition speed or how to fast add data? |
Date: | 2002-05-21 15:53:48 |
Message-ID: | 049f01c200df$b2492400$f566a8c0@olonichev |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2002-05-21 16:06:28 | Re: [GENERAL] Psql 7.2.1 Regress tests failed on RedHat 7.3 |
Previous Message | Scott Marlowe | 2002-05-21 15:36:34 | Re: too many idle processes |