I am using Postgres 7.1.3 with :
PIII 800Mhz
Memory 256Mb
HD 20 Gb 7200 rpm
on a Redhat 7.2
I have a Database that has about 12 tables.
In one of these tables called X_TABLE there are about 13000 records.
When I am trying to execute a query from the psql prompt :
:> UPDATE X_TABLE SET ytd=0;
It takes more than 1 minute to finish.
Is that time OK ??