Hello,
Actually what I expected from the planner for this
query (select max(transid) from view) was something
like this :
select max(transid) from (select max(transid) from
archive.transaction union all select max(transid) from
public.transaction)
and to apply the max function to each query of
Le mercredi 18 octobre 2006 23:02, Ioana Danes a écrit :
> I tried the partitioning scenario but I've got into
> the same problem. The max function is not using the
> indexes on the two partitioned tables...
>
> Any other thoughts?
Did you make sure your test included table inheritance?
I'm not su
Hello,
I tried the partitioning scenario but I've got into
the same problem. The max function is not using the
indexes on the two partitioned tables...
Any other thoughts?
--- Ioana Danes <[EMAIL PROTECTED]> wrote:
> Thanks a lot I will give it a try.
>
> --- Dimitri Fontaine <[EMAIL PROTECTE
Thanks a lot I will give it a try.
--- Dimitri Fontaine <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Le mercredi 18 octobre 2006 21:51, Ioana Danes a
> écrit :
> > I am doing a test for a scenario where I have 2
> > schemas one (public) for the operational data and
> > another one (archive) for old, a
On 10/18/06, Ioana Danes <[EMAIL PROTECTED]> wrote:
# explain select max(transid) from public.transaction; QUERYPLAN
-- Result (cost=0.04..0.05 rows=1 wi
Hi,
Le mercredi 18 octobre 2006 21:51, Ioana Danes a écrit :
> I am doing a test for a scenario where I have 2
> schemas one (public) for the operational data and
> another one (archive) for old, archived data. So
> basically I want to split the data from some huge
> tables in two. All data befor
