Re: performance... - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: performance...
Date
Msg-id 20010129134222.D26076@fw.wintelcom.net
Whole thread Raw
In response to Re: performance...  (adb <adb@Beast.COM>)
List pgsql-general
* adb <adb@Beast.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.

pgsql-general by date:

Previous
From: adb
Date:
Subject: Re: performance...
Next
From: "Steven Lacroix"
Date:
Subject: Could not flush socket buffer- what does this mean???