Slow INSERT

From: Michal Táborský <michal(at)taborsky(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow INSERT
Date: 2004-06-29 12:30:30
Message-ID: 40E160E6.4080105@taborsky.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I am experiencing rather slow INSERTs on loaded server. The table I am
inserting to is:

CREATE TABLE pagestats
(
page_id int4 NOT NULL,
viewed timestamptz DEFAULT now(),
session int4 NOT NULL
) WITH OIDS;

The table is populated with 700k rows. It is VACUUM ANALYZED every
night, though it is only INSERTED to and SELECTED from, no UPDATES or
DELETES. There are no indices, triggers or constraints attached to it.
There are about 5 inserts pre second (sometimes more, but 10/s max).

The INSERT is:
INSERT INTO pagestats (page_id,session) VALUES (5701,1147421823)

Sometimes, it takes as long as 1300ms! Other queries are quite swift,
even compplex SELECTS and most of the INSERTS run fast. But occasionally
(every 50th or 100th INSERT) it takes forever (and stalls the webpage
from loading). The only special thing about this table is, it does not
have a PRIMARY KEY, but I should think that this constraint would only
slow it down even more.

Any ideas what can be wrong?

--
Michal Taborsky
http://www.taborsky.cz

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2004-06-29 13:28:13 Re: postgres 7.4 at 100%
Previous Message Dennis Bjorklund 2004-06-29 11:49:52 Re: no index-usage on aggregate-functions?