Thread: BUG #5588: I use a lot of the "INHERITS", results of tests found that the performance is very low.
BUG #5588: I use a lot of the "INHERITS", results of tests found that the performance is very low.
From
"runner.mei"
Date:
The following bug has been logged online: Bug reference: 5588 Logged by: runner.mei Email address: runner.mei@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?
Re: BUG #5588: I use a lot of the "INHERITS", results of tests found that the performance is very low.
From
Robert Haas
Date:
On Sun, Aug 1, 2010 at 10:16 PM, runner.mei <runner.mei@gmail.com> wrote: > > The following bug has been logged online: > > Bug reference: =A0 =A0 =A05588 > Logged by: =A0 =A0 =A0 =A0 =A0runner.mei > Email address: =A0 =A0 =A0runner.mei@gmail.com > PostgreSQL version: 8.4.4 > Operating system: =A0 windows > Description: =A0 =A0 =A0 =A0I use a lot of the "INHERITS", results of tes= ts 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. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company