Re: Statistics Import and Export
| От | Hari Krishna Sunder |
|---|---|
| Тема | Re: Statistics Import and Export |
| Дата | |
| Msg-id | CAAeiqZ2CnY92Te_LJWXO0PMB9kxtLFGYeAyx_CUyquO6BAmhzg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Statistics Import and Export (Corey Huinker <corey.huinker@gmail.com>) |
| Ответы |
Re: Statistics Import and Export
|
| Список | pgsql-hackers |
To improve the performance of pg_dump can we add a new sql function that can operate more efficiently than the pg_stats view? It could also take in an optional list of oids to filter on.
This will help speed up the dump and restore within pg18 and future upgrades to higher pg versions.
Thanks
Hari Krishna Sunder
On Fri, Mar 7, 2025 at 7:43 PM Corey Huinker <corey.huinker@gmail.com> wrote:
I tried to generalize that requirement to all of
{schema|data|statistics} for consistency, but that resulted in 9
options.9 options that resolve to 3 boolean variables. It's not that hard.And if we add a fourth option set, then we have 12 options. So it's O(3N), not O(N^2).People have scripts now that rely on the existing -only flags, and nearly every other potentially optional thing has a -no flag. Let's leverage that.
В списке pgsql-hackers по дате отправления: