Re: [HACKERS] materialised view

2006-10-25 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 09:24:16AM +0530, rajesh boppana wrote:
> i want to implement materialized views in postgresql . to do as i
> want to modify the code in backend but i don't know what r the files i have
> to modify. so please help me by mentioning about the backend code.

If you're going to do this, I'd recommend looking at a modular approach.
Many of the things you need to do materialized views are also needed by
replication, such as the ability to log changes to tables and ship those
somewhere.
-- 
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] materialised view

2006-10-24 Thread Jaime Casanova

On 10/24/06, rajesh boppana <[EMAIL PROTECTED]> wrote:

 i want to implement materialized views in postgresql . to do as i
want to modify the code in backend but i don't know what r the files i have
to modify. so please help me by mentioning about the backend code.



http://www.postgresql.org/developer/coding

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
  Richard Cook

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


[HACKERS] materialised view

2006-10-24 Thread rajesh boppana
 i want to implement materialized views in postgresql . to do as i want to modify the code in backend but i don't know what r the files i have to modify. so please help me by mentioning about the backend code.