hi al,
On Jul 25, 2012, at 10:40 AM, AI Rumman wrote:
> Thanks. I missed to add the trigger.
> Now I added it, but still without partition taking less time compared to with
> partition query.
>
> With partition :-
>
> explain analyze
> select *
> from table1 as c
> inner join table2 as a o
hi al,
> With Parition :-
>
>
> explain analyze
> select *
> from table1 as c
> inner join table2 as a on c.crmid = a.table2id and deleted = 0
> where module ='Leads';
>
> QUERY PLAN
hi,
> I've complained many times that
> select (f()).*;
>
> will execute f() once for each returned field of f() since the server
> essentially expands that into:
>
> select f().a, f().b;
>
> try it yourself, see:
> create function f(a out text, b out text) returns record as $$
> begin
> perfo
Hi Mathias,
On Aug 22, 2008, at 8:35 AM, Mathias Stjernström wrote:
I Agree with Robert but i never heard of Cybercluster before.
Does anyone have any experience with Cybercluster? It sounds really
interesting!
Some months ago i took a look into cybercluster. At that point
cybercluster wa
