Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0996E9FB1CC for ; Tue, 31 Oct 2006 07:06:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 87679-03 for ; Tue, 31 Oct 2006 11:06:00 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id 8032B9F9FE1 for ; Tue, 31 Oct 2006 07:06:00 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so1532998nzi for ; Tue, 31 Oct 2006 03:05:59 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=iWTYuQEHDzJTvFg/go2Y1ncd3PS+APE6ODmeT+zDs4T0NCvpRWv21EJSY0I1UERYfkB/sKFK4PXntPVbWPiCRMjTin6nvEtztXQMr/pxrmy39hmntQvuGQZ0TjMOCZYWZYgWXm07UakX2m83s7IbxOCDAQ4kNjSH4Q0t7SBv8jU= Received: by 10.65.249.10 with SMTP id b10mr6547534qbs; Tue, 31 Oct 2006 03:05:58 -0800 (PST) Received: by 10.65.196.2 with HTTP; Tue, 31 Oct 2006 03:05:58 -0800 (PST) Message-ID: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com> Date: Tue, 31 Oct 2006 19:05:58 +0800 From: nineday To: pgsql-admin@postgresql.org Subject: I have a question about Database management MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3575_24278238.1162292758848" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/24 X-Sequence-Number: 23551 ------=_Part_3575_24278238.1162292758848 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I have a trouble. My DBMS is PostgreSQL which is accessory to Red hat 9.0. At the initial stages, it was very quick when select ,but operated for several months , it become to very slow ,especially in a pivotal table. So,I exported data ,and recreate tables , finally import data, it get right . I do not know why. and what is the solution to my trouble Thank you very much ~~ ------=_Part_3575_24278238.1162292758848 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
I have a trouble.
My DBMS is PostgreSQL which is accessory to Red hat 9.0.
At the initial stages, it was very quick when select ,but operated for several months , it  become to very slow ,especially in a pivotal table.
So,I exported data ,and recreate tables , finally import data, it get right .
 
I do not know why. and what is the solution to my trouble 
                    Thank you very much ~~
------=_Part_3575_24278238.1162292758848--