Analyze has been run on the database quite frequently during the
course of us trying to figure out this performance issue. It is also
a task that is crontabbed nightly.
On Mon, 7 Mar 2005 09:31:06 -0800, Josh Berkus wrote:
> Tsarevich,
>
> > When running queries we are exper
Env: Sun E4500 with 8 gig of RAM in total. Database is stored
locally (not on a network storage devise). A copy of the
postgresql.conf file is attached.
When running queries we are experiencing much bigger result times than
anticipated.
Attached is a copy of our postgresql.conf file and of our
