memory leak while using vaccum

Поиск
Список
Период
Сортировка
От Achim Krümmel
Тема memory leak while using vaccum
Дата
Msg-id 3B83568E.96CF1CD6@dohle.com
обсуждение исходный текст
Ответы Re: memory leak while using vaccum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I am running a PostgreSQL 7.1.3 on a Intel Pentium III
My operating system is SuSE Linux 7.1 with Kernel 2.4.4 (ELF)
I compiled postgresql with gcc 2.95.2
My problem:
when using "vacuum analyze <tablename>" on very large tables (I have one
with about 30GB) the memory usage increases continues until no memory is
left and the kernel stops this process.

I suppose this problem is easy to reproduce. Just create a table, fill
very much data into it, create an index and run vacuum anayze <table>
I hope you will find a solution :-)


greetings,  Achim Kruemmel


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: low performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: memory leak while using vaccum