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
Hi everyone,
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 before 2006 in archive and all
data after and including 2006
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 before
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 width=0) InitPlan -Limit(cost=0.00..0.04 rows=1
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 PROTECTED]
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 sure