Speed Performance Question - Mailing list pgsql-novice

From Kapsalis Nikos
Subject Speed Performance Question
Date
Msg-id GKEJJJPDMFAMDFOJLEBCAENDCDAA.nkapsal@bbdogroup.gr
Whole thread Raw
Responses Re: Speed Performance Question  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
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 ??

pgsql-novice by date:

Previous
From: Setyo Nugroho
Date:
Subject: Display a function
Next
From: Chris Thompson
Date:
Subject: Re: libssl