Frank Wiles wrote:
On Tue, 14 Mar 2006 12:24:22 +1100
Chris <dmagick@xxxxxxxxx> wrote:
Gavin Sherry wrote:
On Tue, 14 Mar 2006, Chris wrote:
Hi all,
I'm trying to work out why my 8.1 system is slower than my 7.4
system for importing data.
The import is a lot of "insert into" commands - it's a converted
database from another system so I can't change it to copy commands.
Are you on the same hardware specifically in your disk subsystem?
Anything else different about how the two servers are used?
Different hardware.
7.4 is running on a 500MHz computer with 256M compared to 8.1 running on
a 2.6GHz with 512M.
The only notable config variables on that machine (the rest are logging):
commit_delay = 10000
checkpoint_segments = 10
checkpoint_warning = 300
insert times:
Time: 63.756 ms
INSERT 13584074 1
Time: 46.465 ms
INSERT 13584075 1
Time: 70.518 ms
INSERT 13584077 1
Time: 59.864 ms
INSERT 13584078 1
Time: 35.984 ms
Tons of difference :/
--
Postgresql & php tutorials
http://www.designmagick.com/
