Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Some further performance tweaks for planning large inheritance

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Some further performance tweaks for planning large inheritance
Date: 2007-04-22 21:20:15
Message-ID: 200704222120.l3MLKFj11440@momjian.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-patches
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

In response to

pgsql-committers by date

Next:From: User H-saitoDate: 2007-04-23 07:34:26
Subject: libpqwce - libpqwce: Imported Sources
Previous:From: Peter EisentrautDate: 2007-04-22 21:16:18
Subject: pgsql: Make some functions immutable.

pgsql-patches by date

Next:From: Koichi SuzukiDate: 2007-04-23 00:17:21
Subject: Re: [HACKERS] Full page writes improvement, code update
Previous:From: Tom LaneDate: 2007-04-22 17:10:17
Subject: Re: [HACKERS] parser dilemma

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group