Hi,
On Tue, Jan 04, 2005 at 10:06:18AM -0800, Josh Berkus wrote:
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within the optimizer) to use a
materialized view instead of the originating table?
Automatically, and by default, no.
Yann,
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within the optimizer) to use a
materialized view instead of the originating table?
Automatically, and by default, no. Using the RULES system? Yes, you can
already do this and the
] On Behalf Of Josh Berkus
Sent: Tuesday, January 04, 2005 12:06 PM
To: pgsql-performance@postgresql.org
Cc: Yann Michel
Subject: Re: [PERFORM] query rewrite using materialized views
Yann,
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within
Sent: Tuesday, January 04, 2005 12:06 PM
To: pgsql-performance@postgresql.org
Cc: Yann Michel
Subject: Re: [PERFORM] query rewrite using materialized views
Yann,
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within the optimizer
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
Berkus
Sent: Tuesday, January 04, 2005 12:06 PM
To: pgsql-performance@postgresql.org
Cc: Yann Michel
Subject: Re: [PERFORM] query rewrite using materialized views
Yann,
are there any plans for rewriting queries to preexisting
materialized
views? I mean, rewrite a query (within
Ryan,
I do this, PG gets forked many times, it is tough to find the max
number of times I can do this, but I have a Proc::Queue Manager Perl
driver that handles all of the copy calls. I have a quad CPU machine.
Each COPY only hits ones CPU for like 2.1% but anything over about 5
On Tue, 2005-01-04 at 14:02 -0500, Rod Taylor wrote:
1)the 250 million records are currently whipped and reinserted as a
daily snapshot and the fastest way I have found COPY to do this from
a file is no where near fast enough to do this. SQL*Loader from Oracle
does some things that I
Hi,
are there any plans for rewriting queries to preexisting materialized
views? I mean, rewrite a query (within the optimizer) to use a
materialized view instead of the originating table?
Regards,
Yann
---(end of broadcast)---
TIP 6: Have you