Thread: Optimizing DB Permormanance

Optimizing DB Permormanance

From
pandurang@manas-solutions.com (Pandurang)
Date:
Hi there,
I am having a postgres DB on Linux Server.
The size of DB is near abt 1.5GB and also my site is on the same
server. I am having problem that my site is very slow.
I checked size on my HDD using df -h command its showing me only 15%
disk space is allocated. But when I saw the memory allcated by the
processes using top command it shows me that CPU % is reaching near
abt 90 - 90% for postmaster.

In my PHP code there is lots of SELECT stmts also while generating
report insert and updates stmts are also there. BUT on my local PC it
works fine for fewer records. while on my production server records
are near abt 5211 it is very very slow. Sometimes I get Page not found
error.

1. So can anybody tell me what will be the reason postmaster is taking
lot of CPU usage??

2. If I created CLUSTERed Index is it feasible ?  Can it improve my
speed of Retriving records ?

Or if there is any other solution please let me know...

Thank you in advance
Regards
Pandurang

pandurang@manas-solutions.com

Re: Optimizing DB Permormanance

From
Jeff
Date:
On 21 Oct 2002, Pandurang wrote:

> 1. So can anybody tell me what will be the reason postmaster is taking
> lot of CPU usage??
>
> 2. If I created CLUSTERed Index is it feasible ?  Can it improve my
> speed of Retriving records ?
>
> Or if there is any other solution please let me know...
>

Can you please post relavant database info - version, tables, queries?


------------------------------------------------------------------------------
Jeff Trout <jeff@jefftrout.com>                  http://www.jefftrout.com/
   Ronald McDonald, with the help of cheese soup,
       controls America from a secret volkswagon hidden in the past
-------------------------------------------------------------------------------