[PERFORM] Slow select, insert, update

[Paul Langard]

Having trouble with one table (see time to count records below!).

Fairly new to postgres so any help much appreciated.

It only contains 9,106 records - as you can see from:


select count(id) from project

<x-tad-bigger>count</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>9106
1 row(s)
Total runtime: 45,778.813 ms


There are only 3 fields:

id
integer
nextval('id'::text)

projectnumber
text

description
text


There is one index:

id_project_ukey
CREATE UNIQUE INDEX id_project_ukey ON project USING btree (id)

... the database is regularly vaccuumed.</x-tad-bigger>