From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Frank Wiles <frank(at)wiles(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: import performance |
Date: | 2006-03-14 01:42:21 |
Message-ID: | 44161F7D.9070707@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Frank Wiles wrote:
> On Tue, 14 Mar 2006 12:24:22 +1100
> Chris <dmagick(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-14 01:51:21 | Re: import performance |
Previous Message | Frank Wiles | 2006-03-14 01:33:18 | Re: import performance |