From: | "Harvey, Allan AC" <HarveyA(at)OneSteel(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Performance suggestions? |
Date: | 2004-12-14 23:22:31 |
Message-ID: | 3C2CED55DF019847AB7BD7317837BDA901815DAA@ntlmsg02.onesteel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I'm after suggestions on how to keep the initial performance
of a system I've put together for longer than 2 minutes.
I have a small table about 20 rows, a constant, that is receiving
about 160 updates per second.
The table is used to share gathered data to other process asynchronously.
After 5 min it is 12 updates per second.
Performance returns after a vacuum analyse.
I'm using 7.4.5.
This is the table structure
Table "public.lastscan"
Column | Type | Modifiers
-----------+-----------------------------+-----------
pointnum | integer | not null
parameter | character varying(8) | not null
value | double precision | not null
dt | timestamp without time zone | not null
Indexes:
"lsindex" btree (pointnum, parameter)
Or should I just stick to saving the data, inserts seem to go on and on, and
use a different IPC method.
Ta
Allan
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-12-14 23:31:00 | Threading with non-shared libraries |
Previous Message | Tom Lane | 2004-12-14 23:19:00 | Re: Performance differences 7.1 to 7.3 |