From: | Terry Fielder <terry(at)greatgulfhomes(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Insert speed |
Date: | 2007-07-02 19:35:42 |
Message-ID: | 4689538E.8060408@greatgulfhomes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a user application use log.
Under pg 7.x the system performed fine.
In 8.1, the insert statements seem to take a long time sometimes, upto
several seconds or more.
Here is the table:
CREATE TABLE user_app_use_log
(
user_id int4 NOT NULL,
access_stamp timestamptz NOT NULL DEFAULT now(),
app_name char(50) NOT NULL,
url char(150) NOT NULL,
form_params text,
division_id char(3),
url_params text,
ip_address varchar(31)
)
WITHOUT OIDS;
There is no primary key, but the table is never updated, only inserted.
I removed the only index, with no improvement in performance (in case
the 8.2 "resolves index locking issues" was the concern for an 8.1 install.
Should I add a primary key column of serial? Will that help?
If anyone has any ideas it would be appreciated.
--
Terry Fielder
terry(at)greatgulfhomes(dot)com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-02 20:25:54 | Re: Restart after poweroutage |
Previous Message | Simon Riggs | 2007-07-02 18:50:05 | Re: recovery_target_time ignored or recoveryalwaysrecovers to end of WAL |