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,
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 thing
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
IL PROTECTED]
> Sent: Tuesday, January 04, 2005 1:02 PM
> To: Wager, Ryan D [NTK]
> Cc: Postgresql Performance
> Subject: Re: [PERFORM] query rewrite using materialized views
>
> > 1)the 250 million records are currently whipped and reinserted as a
> > "dail
inal Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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
>
> Yan
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 addi
inal Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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,
>
PROTECTED]
[mailto:[EMAIL PROTECTED] 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 material
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
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 sea
10 matches
Mail list logo
