| From: | Paul Langard <pjl(at)intercellsolutions(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Slow select, insert, update |
| Date: | 2004-08-09 16:54:00 |
| Message-ID: | B668647A-EA24-11D8-9D1D-000A95B97268@intercellsolutions.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2004-08-09 16:56:57 | Help specifying new machine |
| Previous Message | Tom Lane | 2004-08-09 16:35:10 | Re: tablespaces and ramdisks |