Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] So slow inserts... Why?

From: johan(dot)granlund(at)solid(dot)se
To: Michal Samek <webmaster(at)tony(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] So slow inserts... Why?
Date: 1999-05-26 15:16:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I removed your first mail, but if i remembered it right you was using PHP.
I have seen on my server (dual P5/100) that the "startup" cost of the
backend is rather high.
If you is using PHP and not using persistent connection (or whatever it was
called) you may have a lot of
start/stop of backends.

Whatewer the reason is, 1 transaction/sec is awfully slow. Something must
be wrong.
What other things is running on this machine. Is it highly loaded?


Michal Samek <webmaster(at)tony(dot)cz> on 99-05-26 16:15:10

To:   Johan Granlund/Solid AB
cc:   pgsql-general(at)postgresql(dot)org
Subject:  Re: [GENERAL] So slow inserts... Why?

johan(dot)granlund(at)solid(dot)se wrote:
> As i dont know anything about triggers:)
> Have you done a vacuum on the databases to clear out old transactions?

I recreated the table, so I think there is not necessary to vacuum it
(it takes unbelieveable amount of time); maybe when I'm filling the
table by sending a lot of INSERT queries I should sometimes between
inserts do a vacuum ? It looks strange for me.

And many thanks for your help; I was thinking about dropping indexes and
trigger, but It's impossible. Imagine this is not just a series of
insert queries, the process I'm using is (simplicied): For each dbase
record (the catalogue from the music label) to look-up if exist and if
so, update; if no, insert. So I can't drop indexes which are needed by
look-up function; nor can't drop trigger because it tracks inserts /
updates of my table.
I'm testing to group inserts / updates to blocks enclosed with
transaction BEGIN; END;, but it now looks that it will help only little.

PS I plan to rewrite the whole thing to Mysql (even it's no triggers, it
will be harder but possible of course) and to report the result here if
will be interesting)

Michal Samek, Tony distribuce s.r.o.
webmaster(at)tony(dot)cz  (++420659/321350)
ICQ: 38607210

pgsql-general by date

Next:From: Jackson, DeJuanDate: 1999-05-26 17:43:08
Subject: RE: [GENERAL] 6.3.2 -> 6.4.2
Previous:From: BrianDate: 1999-05-26 15:15:38
Subject: 6.3.2 -> 6.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group