Hi All, I have created partition on table Round_Action , which has 3 inherited 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 inherited 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. Table is having index on action_id. Partition is trigger based. Postgres Version : (PostgreSQL) 8.4.6 Why there is difference in execution time? What I am doing wrong? -- Thanks & regards, JENISH VYAS
