Re: Bootstrap DATA is a pita

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Bootstrap DATA is a pita
Дата
Msg-id
4981.1449881043@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Andres Freund <andres@anarazel.de>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Joe Conway <mail@joeconway.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Mark Dilger <hornschnorter@gmail.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Mark Dilger <hornschnorter@gmail.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Craig Ringer <craig@2ndquadrant.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Andres Freund  writes:
> On 2015-12-11 19:26:38 -0500, Tom Lane wrote:
>> I believe it's soluble, but it's going to take something more like
>> loading up all the data at once and then doing lookups as we write
>> out the .bki entries for each catalog.  Fortunately, the volume of
>> bootstrap data is small enough that that won't be a problem on any
>> machine capable of running modern Postgres ...

> I think that's exactly the right approach. Just building a few perl
> hashes worked well enough, in my prototype of that.

Right.  I would draw Mark's attention to src/backend/catalog/Catalog.pm
and the things that use that.  Presumably all that would have be
rewritten, but the existing code would be a useful starting point
perhaps.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
Сообщение: Re: Bootstrap DATA is a pita
От: Noah Misch
Дата:
FAQ