On 10 October 2010 11:51, AI Rumman wrote:
> I already sent the mail earlier. but added wrong explain. So I mail it
> again.
>
> I have more than 130 records in crm table and I partioned the table with
> deleted = 0 key.
> It is working fine except that after partioion query is taking more tim
I already sent the mail earlier. but added wrong explain. So I mail it
again.
I have more than 130 records in crm table and I partioned the table with
deleted = 0 key.
It is working fine except that after partioion query is taking more time
than the previous one.
I already set constraint_exclu
I have more than 130 records in crm table and I partioned the table with
deleted = 0 key.
It is working fine except that after partioion query is taking more time
than the previous one.
I already set constraint_exclusion = on; My DB version is Postgresql 8.1
I added the explain anayze for both
