Performance suggestions?

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

Responses

Browse pgsql-general by date

  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