pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I have a question about Database management
4+ messages / 4 participants
[nested] [flat]

* I have a question about Database management
@ 2006-10-31 11:05 nineday <nine9day@gmail.com>
  2006-11-06 18:54 ` Re: I have a question about Database management imad <immaad@gmail.com>
  2006-11-07 01:06 ` Re: I have a question about Database management Tomeh, Husam <htomeh@firstam.com>
  2006-11-07 04:38 ` Re: I have a question about Database management Bruno Wolff III <bruno@wolff.to>
  0 siblings, 3 replies; 4+ messages in thread

From: nineday @ 2006-10-31 11:05 UTC (permalink / raw)
  To: pgsql-admin

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 ~~

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: I have a question about Database management
  2006-10-31 11:05 I have a question about Database management nineday <nine9day@gmail.com>
@ 2006-11-06 18:54 ` imad <immaad@gmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: imad @ 2006-11-06 18:54 UTC (permalink / raw)
  To: nineday <nine9day@gmail.com>; +Cc: pgsql-admin

You need to vacum (probably re-index) your tables
periodically to get the best performance.

These vacuming and indexing tools should already
be there with your PostgreSQL installation.

--Imad
www.EnterpriseDB.com


On 10/31/06, nineday <nine9day@gmail.com> wrote:
> 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 ~~



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: I have a question about Database management
  2006-10-31 11:05 I have a question about Database management nineday <nine9day@gmail.com>
@ 2006-11-07 01:06 ` Tomeh, Husam <htomeh@firstam.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Tomeh, Husam @ 2006-11-07 01:06 UTC (permalink / raw)
  To: nineday <nine9day@gmail.com>; pgsql-admin

Without knowing more details about what version of postgres and type of
activities going on,etc, it may be hard to figure out what's going out.
However, one maintenance operation that you want to make sure it happens
to is to run vacuum/analyze periodically so that expired tuples can be
re-used, and your statistics get updated in the db system catalog.
 
--
  Husam 
 

________________________________

From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of nineday
Sent: Tuesday, October 31, 2006 3:06 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] I have a question about Database management


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 ~~

**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: I have a question about Database management
  2006-10-31 11:05 I have a question about Database management nineday <nine9day@gmail.com>
@ 2006-11-07 04:38 ` Bruno Wolff III <bruno@wolff.to>
  2 siblings, 0 replies; 4+ messages in thread

From: Bruno Wolff III @ 2006-11-07 04:38 UTC (permalink / raw)
  To: nineday <nine9day@gmail.com>; +Cc: pgsql-admin

On Tue, Oct 31, 2006 at 19:05:58 +0800,
  nineday <nine9day@gmail.com> wrote:
> 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 ~~

You should probably also upgrade. The version of Postgres that came with
RH9 is going to be very old now. You should probably upgrade the OS as
well. While RH9 is supported by the Legacy project, they haven't exactly
been cranking out lots of fixes, so you should be very careful if that
system is exposed to attack over a network.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-11-07 04:38 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-31 11:05 I have a question about Database management nineday <nine9day@gmail.com>
2006-11-06 18:54 ` imad <immaad@gmail.com>
2006-11-07 01:06 ` Tomeh, Husam <htomeh@firstam.com>
2006-11-07 04:38 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox