| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Pandurang <pandurang(at)manas-solutions(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Optimizing DB Permormanance |
| Date: | 2002-10-21 16:24:21 |
| Message-ID: | 20021021122354.X21396-100000@torgo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jefftrout(dot)com> http://www.jefftrout.com/
Ronald McDonald, with the help of cheese soup,
controls America from a secret volkswagon hidden in the past
-------------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Will LaShell | 2002-10-21 17:07:24 | Re: Using oid with RServ w/ Postgresql 7.2 |
| Previous Message | Andrew Perrin | 2002-10-21 13:14:34 | Re: newbie qs; examining databases and tables |