If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem but solved it and generated a patch then e-mail it to [EMAIL PROTECTED] instead. Please use the command "diff -c" to generate the patch. You may also enter a bug report at http://www.postgresql.org/ instead of e-mail-ing this form. ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Achim Kruemmel Your email address : [EMAIL PROTECTED] System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium III 1000MHz Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.4 ELF PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3 Compiler used (example: gcc 2.95.2) : gcc 2.95.2 Please enter a FULL description of your problem: ------------------------------------------------ when using "vacuum analize <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. In my machine there is only 128MB of memory and 250MB swap space which is also used, so there is about 350MB space to work for postgres. Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- create a table and fill several GB of data into it. Then run vacuum analyze tablename. If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- I hope you will find a solution :-) greetings, Achim Kruemmel ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
