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 (Andres Freund)
Список
Дерево обсуждения
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 по дате отправления