Re: Problem on Linux - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Problem on Linux
Date
Msg-id 1053623630.628.6.camel@billy
Whole thread Raw
In response to Problem on Linux  ("Molenda, Mark P" <mark.molenda@eds.com>)
List pgsql-novice
Am Don, 2003-05-22 um 16.33 schrieb Molenda, Mark P:

> Is there a better way?  And how do I tune the stock RedHat version?  I
> really don't want to have to load it again from scratch (source).

Did you try a: "VACUUM ANALYZE" ?
It calculates indexes etc. automatically (depending on your usage).

Also you could try "EXPLAIN <your query>" to get a hint how postgresql
handles it and maybe to improve the querys manually.

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de


pgsql-novice by date:

Previous
From: Renê Salomão
Date:
Subject: Re: Installing PlPerl
Next
From: Nabil Sayegh
Date:
Subject: Re: timestamp data type?