Speed Performance Question

From: "Kapsalis Nikos" <nkapsal(at)bbdogroup(dot)gr>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Speed Performance Question
Date: 2002-11-06 10:09:02
Message-ID: GKEJJJPDMFAMDFOJLEBCAENDCDAA.nkapsal@bbdogroup.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ??

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mattia Boccia 2002-11-06 13:09:22 html forms
Previous Message Reshat Sabiq 2002-11-06 08:03:36 Re: moving a postgreSQL DB, etc.->Thanks all