Re: query rewrite using materialized views - Mailing list pgsql-performance

From Josh Berkus
Subject Re: query rewrite using materialized views
Date
Msg-id 200501041116.49197.josh@agliodbs.com
Whole thread Raw
In response to Re: query rewrite using materialized views  ("Wager, Ryan D [NTK]" <Ryan.D.Wager@mail.sprint.com>)
List pgsql-performance
Wagner,

>    If there is anyone that can give me some tweak parameters or design
> help on this, it would be ridiculously appreciated.  I have already
> created this in Oracle and it works, but we don't want to have to pay
> the monster if something as wonderful as Postgres can handle it.

In addition to Rod's advice, please increase your checkpoint_segments and
checkpoint_timeout parameters and make sure that the pg_xlog is on a seperate
disk resource from the database.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: query rewrite using materialized views
Next
From: "Wager, Ryan D [NTK]"
Date:
Subject: Re: query rewrite using materialized views