Re: import performance

Frank Wiles wrote:
> On Tue, 14 Mar 2006 12:24:22 +1100
> Chris <dmagick@gmail.com> 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/