Re: performance...

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: adb <adb(at)Beast(dot)COM>
Cc: chris markiewicz <cmarkiew(at)commnav(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: performance...
Date: 2001-01-29 21:42:22
Message-ID: 20010129134222.D26076@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* adb <adb(at)Beast(dot)COM> [010129 13:40] wrote:
>
> One other thing is that if you only have 1100 rows of the sizes
> you describe, even a table scan shouldn't take as long as you
> say unless the machine is either under serious load or doesn't
> have enough memory to run postgres without swapping. (or the disk is
> freaking out with io errors)

Increasing the amount of shared memory for postgresql can help.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-01-29 21:54:52 Book enters second printing
Previous Message adb 2001-01-29 21:35:57 Re: performance...