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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
