Re: Tuning, configuration for 7.3.5 on a Sun E4500

From: <tsarevich(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Postgres - Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning, configuration for 7.3.5 on a Sun E4500
Date: 2005-03-08 07:47:37
Message-ID: 156a90fe05030723477c3ee7d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 <josh(at)agliodbs(dot)com> wrote:
> Tsarevich,
>
> > When running queries we are experiencing much bigger result times than
> > anticipated.
> >
> > Attached is a copy of our postgresql.conf file and of our the table
> > definitions and row counts.
>
> Looks like you haven't run ANALYZE on the database anytime recently. Try that
> and re-run.
>
> --
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2005-03-08 09:05:08 Re: [PERFORM] Help with tuning this query (with
Previous Message Stephan Szabo 2005-03-08 07:03:43 Re: adding 'limit' leads to very slow query