Re: Improving pg_dump performance when handling large numbers of LOBs
| От | Wyatt Tellis |
|---|---|
| Тема | Re: Improving pg_dump performance when handling large numbers of LOBs |
| Дата | |
| Msg-id | CANCMp8wRi=v9vrf4HyvX9XHjyoxuu-gM8WRoUNnF+fBdmWGevw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Improving pg_dump performance when handling large numbers of LOBs (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Improving pg_dump performance when handling large numbers of LOBs
Re: Improving pg_dump performance when handling large numbers of LOBs Re: Improving pg_dump performance when handling large numbers of LOBs |
| Список | pgsql-general |
Yes, the LOBs themselves are tiny, but there are a lot of them (~150 million) which seem to be slowing down pg_dump. Note, we did not design/build this system and agree that use of LOBs for this purpose was not necessary.
Wyatt
On Mon, Feb 5, 2024 at 11:36 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis <wyatt.tellis@gmail.com> wrote:Hi,We've inherited a series of legacy PG 12 clusters that each contain a database that we need to migrate to a PG 15 cluster. Each database contains about 150 million large objects totaling about 250GB.250*10^9 / (150*10^6) = 1667 bytes. That's tiny.Am I misunderstanding you?
В списке pgsql-general по дате отправления: