From: | "Scott V(dot) McGuire" <svmcguir(at)syr(dot)edu> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | scaling |
Date: | 2000-01-26 21:45:17 |
Message-ID: | 20000126164517.A1092@syr.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)syr(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Sarah Officer | 2000-01-26 22:01:53 | ugly name clash |
Previous Message | dw_remote | 2000-01-26 20:31:28 | ODBC Connection problem |