On Sun, Aug 1, 2010 at 10:16 PM, runner.mei <runner....@gmail.com> wrote: > > The following bug has been logged online: > > Bug reference: 5588 > Logged by: runner.mei > Email address: runner....@gmail.com > PostgreSQL version: 8.4.4 > Operating system: windows > Description: I use a lot of the "INHERITS", results of tests found > that the performance is very low. > Details: > > Hello, I try to build a cmdb database with using postgresql , I use a lot of > the "INHERITS", results of tests found that the performance is very low, > there are 2,000,000 pieces of data when the data when a data query, it was > however spent 1672 ms, I was wrong it?
Please refer to the following wiki page for information about getting help with this problem. http://wiki.postgresql.org/wiki/SlowQueryQuestions You'll need to provide more details to get help, and it would also be a good idea to post to the correct mailing list, which is pgsql-performance. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs