scaling - Mailing list pgsql-general

From Scott V. McGuire
Subject scaling
Date
Msg-id 20000126164517.A1092@syr.edu
Whole thread Raw
List pgsql-general
Hi,

I'm surprised about how long certain things are taking.  Here's what
I'm doing:

1. create a temp_table which is 5-7 columns by 1e4 - 1e5 rows.
This part is pretty quick.

2. when its done, copy it into the big table which is 7 columns by
about 5e7 rows.

What I'm surprised about is that the 10,000 row copies take < 1
minute while the 50000 row copies take > 10 minutes.

I don't really know what information is relevant here, so tell me and
I'll provide any other details.  (I'd describe the whole application
but didn't want to waste peoples time.)

Thanks,
--
Scott V. McGuire <svmcguir@syr.edu>
GnuPG key available at http://physics.syr.edu/~svmcguir
GnuPG key fingerprint: 21EA 4999 3620 3E1D 71EC  98A9 5B9B EF52 1258 6D53
GnuPG is at http://www.gnupg.org/


pgsql-general by date:

Previous
From: "dw_remote"
Date:
Subject: ODBC Connection problem
Next
From: Sarah Officer
Date:
Subject: psql bug?