Speed/Performance with pg_restore

Поиск
Список
Период
Сортировка
Искать
От
Matthew Rudolph
Тема
Speed/Performance with pg_restore
Дата
Msg-id
5790CEEF83581444838043A480BDABD7012196D6@exchange01.zetec.com
Список
Дерево обсуждения
Speed/Performance with pg_restore Matthew Rudolph <mrudolph@zetec.com>
Re: Speed/Performance with pg_restore Richard Huxton <dev@archonet.com>
I am currently unable to search the archive so I will ask even though I
am sure something similar has been asked before.

I am wondering why a pg_restore is so slow. I have a db that was dumped
with columns and inserts, which I Know is slower than using the copy
statements but why are inserts so slow and is there anything I can
do to make it faster. Is there any documentation that talks about this?

I have a db that as plain text is 6.2MB, not much, but when I restore it
(using psql for plain text) it takes over 6 min.
That same db created with pg_dump -DFc and then run through pg_restore 
takes over 12 minutes. 

My machine is an AMD xp2000 with 500MB ram running win2000 and 
postgresql 7.3.2, obviously through cygwin.

I just can't imagine a multi gigabyte database being able to be restored
via pg_restore. 

The reason I think I need to use insert statements is for longevity. The
customers may need to go on a witch hunt years down the road and my 
thinking was that if this was just SQL, it will always work.

Thanks,
Matthew Rudolph

-----------------------------------------------------------------------
DISCLAIMER:  Information contained in this message and/or
attachment(s) may contain confidential information of Zetec, Inc.
If you have received this transmission in error, please notify
the sender by return email.
-----------------------------------------------------------------------
В списке pgsql-general по дате отправления
От: Avi Schwartz
Дата:
От: Diana Duncan
Дата:
FAQ