From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Kapsalis Nikos <nkapsal(at)bbdogroup(dot)gr> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Speed Performance Question |
Date: | 2002-11-07 14:33:55 |
Message-ID: | 20021107143355.GA6881@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Nov 06, 2002 at 12:09:02 +0200,
Kapsalis Nikos <nkapsal(at)bbdogroup(dot)gr> wrote:
> 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 ??
That time sounds high.
Have you done anything to optimize your hard drive accesses? On at least
earlier versions of RH (with a 2.2 kernel) you can get a large (x20)
increase in disk I/O throughput by using hdparm. The default is to be
very conservative about assumptions on what a disk can do, but other than
ancient disks, you can push them a lot harder. It is possible this information
is outdated now and that IDE device detection and configuration is improved.
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Kreisler | 2002-11-07 15:14:03 | Re: enforcing alphabetic/numeric content in "char" column |
Previous Message | Joel Rodrigues | 2002-11-07 14:07:23 | enforcing alphabetic/numeric content in "char" column |