Re: [PERFORM] query rewrite using materialized views

2005-01-04 Thread Wager, Ryan D [NTK]
All, I am currently working on a project for my company that entails Databasing upwards of 300 million specific parameters. In the current DB Design, these parameters are mapped against two lookup tables (2 million, and 1.5 million respectively) and I am having extreme issues getting PG to

Re: [PERFORM] query rewrite using materialized views

2005-01-04 Thread Wager, Ryan D [NTK]
avg up. Ill get some explain analysis and table structures out there pronto. -Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 1:02 PM To: Wager, Ryan D [NTK] Cc: Postgresql Performance Subject: Re: [PERFORM] query rewrite using materialized