Re: [HACKERS] pg_dump and thousands of schemas

От: Bruce Momjian
Тема: Re: [HACKERS] pg_dump and thousands of schemas
Дата: ,
Msg-id: 20120531150650.GG26894@momjian.us
(см: обсуждение, исходный текст)
Ответ на: Re: [HACKERS] pg_dump and thousands of schemas  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

pg_dump and thousands of schemas  ("Hugo ", )
 Re: pg_dump and thousands of schemas  (Craig James, )
  Re: pg_dump and thousands of schemas  (Jeff Janes, )
   Re: pg_dump and thousands of schemas  (Bruce Momjian, )
    Re: pg_dump and thousands of schemas  ("Hugo <Nabble>", )
     Re: pg_dump and thousands of schemas  (Ondrej Ivanič, )
     Re: pg_dump and thousands of schemas  (Tom Lane, )
      Re: pg_dump and thousands of schemas  (Bruce Momjian, )
       Re: pg_dump and thousands of schemas  (Jeff Janes, )
      Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
       Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
        Re: pg_dump and thousands of schemas  (Tom Lane, )
         Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
         Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
          Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
           Re: pg_dump and thousands of schemas  (Tom Lane, )
            Re: pg_dump and thousands of schemas  (Stephen Frost, )
             Re: pg_dump and thousands of schemas  (Tom Lane, )
            Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
           Re: pg_dump and thousands of schemas  (Bruce Momjian, )
            Re: pg_dump and thousands of schemas  (Tom Lane, )
             Re: pg_dump and thousands of schemas  (Bruce Momjian, )
             Re: [HACKERS] pg_dump and thousands of schemas  (Robert Haas, )
              Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
               Re: [HACKERS] pg_dump and thousands of schemas  (Jeff Janes, )
                Re: [HACKERS] pg_dump and thousands of schemas  (Robert Haas, )
                 Re: [HACKERS] pg_dump and thousands of schemas  (Denis, )
                  Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
                   Re: [HACKERS] pg_dump and thousands of schemas  (Denis, )
                    Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
                     Re: [HACKERS] pg_dump and thousands of schemas  (Denis, )
                      Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
                       Re: [HACKERS] pg_dump and thousands of schemas  (Denis, )
                        Re: [HACKERS] pg_dump and thousands of schemas  (Jeff Janes, )
                         Re: [HACKERS] pg_dump and thousands of schemas  (Denis, )
                          Re: [HACKERS] pg_dump and thousands of schemas  (Jeff Janes, )
                          Re: [HACKERS] pg_dump and thousands of schemas  (Andrew Dunstan, )
          Re: pg_dump and thousands of schemas  (Jeff Janes, )
           Re: pg_dump and thousands of schemas  (Jeff Janes, )
            Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
             Re: pg_dump and thousands of schemas  (Jeff Janes, )
              Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
               Re: pg_dump and thousands of schemas  ("Hugo <Nabble>", )
        Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
         Re: pg_dump and thousands of schemas  (Robert Klemme, )
          Re: pg_dump and thousands of schemas  (Tatsuo Ishii, )
           Re: pg_dump and thousands of schemas  (Robert Klemme, )
            Re: pg_dump and thousands of schemas  (Claudio Freire, )
             Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
              Re: [HACKERS] pg_dump and thousands of schemas  (Robert Haas, )
               Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
                Re: [HACKERS] pg_dump and thousands of schemas  (Bruce Momjian, )
                Re: [HACKERS] pg_dump and thousands of schemas  (Claudio Freire, )
                 Re: [HACKERS] pg_dump and thousands of schemas  (Tom Lane, )
                  Re: [HACKERS] pg_dump and thousands of schemas  (Claudio Freire, )
                Re: [HACKERS] pg_dump and thousands of schemas  (Robert Haas, )
                 Re: [HACKERS] pg_dump and thousands of schemas  (Bruce Momjian, )
      Re: pg_dump and thousands of schemas  ("Hugo <Nabble>", )
       Re: pg_dump and thousands of schemas  (Jeff Janes, )
        Re: pg_dump and thousands of schemas  (Tom Lane, )
         Re: pg_dump and thousands of schemas  ("Hugo <Nabble>", )
    Re: pg_dump and thousands of schemas  (Jeff Janes, )
     Re: pg_dump and thousands of schemas  (Tom Lane, )
      Re: pg_dump and thousands of schemas  (Jeff Janes, )
     Re: pg_dump and thousands of schemas  (Tom Lane, )
      Re: pg_dump and thousands of schemas  (Jeff Janes, )

On Thu, May 31, 2012 at 11:04:12AM -0400, Robert Haas wrote:
> On Thu, May 31, 2012 at 10:50 AM, Tom Lane <> wrote:
> > Robert Haas <> writes:
> >> On Thu, May 31, 2012 at 10:31 AM, Tom Lane <> wrote:
> >>> I'm not; Jeff Janes is.  But you shouldn't be holding your breath
> >>> anyway, since it's 9.3 material at this point.
> >
> >> I agree we can't back-patch that change, but then I think we ought to
> >> consider back-patching some variant of Tatsuo's patch.  Maybe it's not
> >> reasonable to thunk an arbitrary number of relation names in there on
> >> one line, but how about 1000 relations per LOCK statement or so?  I
> >> guess we'd need to see how much that erodes the benefit, but we've
> >> certainly done back-branch rearrangements in pg_dump in the past to
> >> fix various kinds of issues, and this is pretty non-invasive.
> >
> > I am not convinced either that this patch will still be useful after
> > Jeff's fix goes in, ...
>
> But people on older branches are not going to GET Jeff's fix.

FYI, if it got into Postgres 9.2, everyone upgrading to Postgres 9.2
would benefit because pg_upgrade uses the new cluster's pg_dumpall.

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

  + It's impossible for everything to be true. +


В списке pgsql-performance по дате сообщения:

От: Claudio Freire
Дата:
Сообщение: Re: [HACKERS] pg_dump and thousands of schemas
От: Trevor Campbell
Дата:
Сообщение: Trouble with plan statistics for behaviour for query.