Slow select, insert, update

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


<bold><fontfamily><param>Arial</param><x-tad-bigger>count</x-tad-bigger><x-tad-bigger>

</x-tad-bigger></fontfamily></bold><fontfamily><param>Arial</param><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></fontfamily>
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

count
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.