Re: pg_dump on older version of postgres eating huge
От | Steve Krall |
---|---|
Тема | Re: pg_dump on older version of postgres eating huge |
Дата | |
Msg-id | Pine.LNX.4.58.0403191029520.27168@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: pg_dump on older version of postgres eating huge amounts of memory (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: pg_dump on older version of postgres eating huge
|
Список | pgsql-general |
I've done this with the debug level all the way up... You can get the file here( 20 megs uncompressed, 130K compressed ): http://www.papajohns.com/postgres/postgres.log.bz2 While this dump was running, top reported that pg_dump was taking up around 500-550megs. Then the machine stopped responding. If you need anything else, just ask. Steve On Thu, 18 Mar 2004, Tom Lane wrote: > Steve Krall <swalker@iglou.com> writes: > > When doing a pg_dump databasename > file.dmp pg_dump eats up all the > > memory, and is eventually killed because it takes > > up a huge amount of memory. The dump file is always 0 bytes. It works > > perfectly fine on our other server. > > > When we run pg_dump in verbose mode, it is trying to get the trigger > > information. > > Can you run it with query logging turned on, so we can see what query(s) > it's issuing while it eats RAM? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: