Re: Tuning, configuration for 7.3.5 on a Sun E4500

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: <tsarevich(at)gmail(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-07 17:31:06
Message-ID: 200503070931.06241.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 Hugo Ferreira 2005-03-07 17:45:32 Re: Help trying to tune query that executes 40x slower than in SqlServer
Previous Message Josh Berkus 2005-03-07 17:28:47 Re: Help trying to tune query that executes 40x slower than in SqlServer