Re: [COMMITTERS] pgsql: Some further performance tweaks for planning large inheritance - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [COMMITTERS] pgsql: Some further performance tweaks for planning large inheritance
Date
Msg-id 200704222120.l3MLKFj11440@momjian.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Some further performance tweaks for planning large inheritance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Does this eliminate problems with using a large number of tablespaces?
>
> No, it doesn't have anything particular to do with tablespaces.
> It gets rid of some bottlenecks that become noticeable with a
> large number of child tables.

Yes, but I thought the problem with many tablespaces was the cost of
referencing them as child tables.  Simon?

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] parser dilemma
Next
From: Koichi Suzuki
Date:
Subject: Re: [HACKERS] Full page writes improvement, code update