scaling

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/

Responses

Browse pgsql-general by date

  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