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

From Olonichev Sergei
Subject Re: data addition speed or how to fast add data?
Date
Msg-id 049f01c200df$b2492400$f566a8c0@olonichev
Whole thread Raw
In response to data addition speed or how to fast add data?  ("Olonichev Sergei" <olonichev@scnsoft.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: too many idle processes
Next
From: Doug Fields
Date:
Subject: ERROR: value too long for type character varying(255)