Re: Optimizing DB Permormanance - Mailing list pgsql-admin

From Jeff
Subject Re: Optimizing DB Permormanance
Date
Msg-id 20021021122354.X21396-100000@torgo
Whole thread Raw
In response to Optimizing DB Permormanance  (pandurang@manas-solutions.com (Pandurang))
List pgsql-admin
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
-------------------------------------------------------------------------------



pgsql-admin by date:

Previous
From: Andrew Perrin
Date:
Subject: Re: newbie qs; examining databases and tables
Next
From: Will LaShell
Date:
Subject: Re: Using oid with RServ w/ Postgresql 7.2