Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning, configuration for 7.3.5 on a Sun E4500 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Tuning, configuration for 7.3.5 on a Sun E4500
Date
Msg-id 200503070931.06241.josh@agliodbs.com
Whole thread Raw
In response to Tuning, configuration for 7.3.5 on a Sun E4500  (<tsarevich@gmail.com>)
Responses Re: Tuning, configuration for 7.3.5 on a Sun E4500
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Help trying to tune query that executes 40x slower than in SqlServer
Next
From: Hugo Ferreira
Date:
Subject: Re: Help trying to tune query that executes 40x slower than in SqlServer