X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DFA2F3A45D6 for ; Mon, 1 Nov 2004 15:02:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49059-07 for ; Mon, 1 Nov 2004 15:02:40 +0000 (GMT) Received: from frog.mt.lv (frog.mt.lv [159.148.172.197]) by svr1.postgresql.org (Postfix) with ESMTP id 1EBF73A45BB for ; Mon, 1 Nov 2004 15:02:41 +0000 (GMT) Received: from [10.5.8.106] (edgars@[10.5.8.106]) by frog.mt.lv (8.12.11/8.12.11/Debian-3) with ESMTP id iA1F2dTD023175 for ; Mon, 1 Nov 2004 17:02:39 +0200 Message-ID: <41864FC9.8050608@inbox.lv> Date: Mon, 01 Nov 2004 17:01:29 +0200 From: Edgars User-Agent: Mozilla Thunderbird 0.7.1 (X11/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: postgres gets slower after some while Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-mikrotik.com-Virus_kerajs: Not scanned. X-mikrotik.com-Virus_un_spam-kerajs: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200411/12 X-Sequence-Number: 15397 Hey, make some futher testings regarding my previous post (subj) and discovered that even on v7.4.2 is the same problem, it means the problem is somewhere in the configuration. On another box this works ok. The only way how i'm solving it for now is by dumping the whole structure and data from DB, dropping it and creating again. Then everything works for some time (till one day). Please can someone assist me in this! Edgars