Re: Strange behavior of child table.

On Tue, 2011-05-31 at 10:20 +0300, Jenish wrote:
> Hi All,
>
> I have created partition on table Round_Action , which has 3 child
> partition tables.
>
>
> When I am firing a simple select query with limit on parent table it
> is taking huge time to execute. But when I am firing this query
> directly on child table it is taking few milliseconds.
>
>
> EXP.
> select * from Round_Action where action_id =50000 limit 100 →
> execution time 80 sec
> select * from Round_Action_CH1 action_id =50000 limit 100 → execution
> time 0.1 sec
>
> Round_Action is the parent table and has no record in the tables, all
> the records are lying in child tables.

Run EXPLAIN ANALYZE on each of those queries, and post the results.

See http://wiki.postgresql.org/wiki/SlowQueryQuestions for a guide on
how to give the necessary information for others to help.

Regards,
Jeff Davis