From: | Daniel ?erud <zilch(at)home(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: What could be the reason for EXTREMELY slow INSERTs? |
Date: | 2001-04-03 14:45:26 |
Message-ID: | 986309126.128zilch@home.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On the "fast machine", I did a clean install and run my
test-project. This constist of some cpp files and a shell
script to run them.
Anyway,
I totally reinstalled postgres on the slow machine and
there was no difference. Not much anyway. And i've tried it
on both a 6.x version (comes with debian potato) and a 7.x
version.
Could a migrate from 6.x/7.x to 7.1 make a 665->13 seconds
difference?
It's actually a HP server machine.
And by the way, the SELECT test is faster on the PIII 533
than the 400 mhz. About 13 seconds / 11 seconds or
something.
This is really strange... both databases were in other
words just re-CREATEed.
Daniel Åkerud
> Daniel ?erud wrote:
> >
> > 10000 inserts takes 665 seconds on the PIII 533, while
on
> > the dual 400 it takes about 13 seconds (*GULP!*). I have
> > done a clean reinstallation (dpkg --purge postgresql,
apt-
> > get install postgresql) and tried it again. Same
results.
> > Do you guys know what could be the reason?
>
> Are you running the same version on each machine? There
was a discussion
> recently where the first thousand inserts were very fast,
the next
> thousand fast, the next thousand acceptable... until it
grinds to a halt.
>
> I think it was patched before 7.1RC1 - check the list
archives for
> details on the discussion.
>
> Oh - you don't have constraints on the one but not the
other, do you?
>
> - Richard Huxton
>
> ---------------------------(end of broadcast)-------------
--------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-03 14:47:45 | Re: Virtual domains ? |
Previous Message | Kris Van Hulle | 2001-04-03 14:41:54 | Re: Virtual domains ? |