also check for application logic that loops when you could retrieve a
single result with a group by statement, perform nightly
maintaince/recreation of indexes, and vacuums.
a beowulf cluster will not help with postgres due to the use of shared
memory.
checking the logs to see that you're not recycling wal files too often
is also useful.
On Fri, 1 Nov 2002 09:56:09 -0800
Gary DeSorbo <isasitis@uchicago.edu> wrote:
> I need to find a way to increase performance on my server.
>
> We are currently using postgres as a back-end to our web-based
> corporate wide application. The application is used for everything
> from collecting large amount of data, updating current data and
> creating large reports based on this data. At this point we have
> about 3000 users on the system and this is going to grow rapidly.