Re: Review: Revise parallel pg_restore's scheduling heuristic

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Review: Revise parallel pg_restore's scheduling heuristic
Дата
Msg-id 17758.1248878038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Review: Revise parallel pg_restore's scheduling heuristic  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
>> Also, the followup to that message points out that the 8.4.0 code
>> has a potential O(N^2) dependency on the total number of TOC items
>> in the dump.  So it might be interesting to check the behavior with
>> very large numbers of tables/indexes.
> I've got 431 user tables with 578 indexes.  How high should I push
> this?  Can I just create a bunch of randomly named empty tables with
> primary keys to provoke this effect?

Yeah, just add a bunch of empty tables.  Ten thousand or so, perhaps.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Следующее
От: Gregory Stark
Дата:
Сообщение: date_part()/EXTRACT(second) behaviour with time data type