* 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.