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.
