From: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> |
---|---|
To: | "Valoo, Julian" <Julian(dot)Valoo(at)fnb(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL performance |
Date: | 2010-08-30 19:58:52 |
Message-ID: | AANLkTi=qy-TjMiVEoH2phA28=nu+Hsq3qoam3NDRE=+i@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes. Look at the pg_statio% views in system catalog.
2010/8/30, Valoo, Julian <Julian(dot)Valoo(at)fnb(dot)co(dot)za>:
> Hi
>
>
>
> Are there any performance tuning tools for PostgreSQL, besides explain.
> Any system management views to find out missing indexes or indexes that
> are not being used.
>
>
>
> Thanks
>
>
>
>
>
>
>
> Julian Valoo
>
> SQL Database Administrator
>
> Corporate and Transactional Banking IT
>
> BankCity
>
> e-mail julian(dot)valoo(at)fnb(dot)co(dot)za
>
> www.fnb.co.za www.shine2010.co.za
>
>
>
>
>
>
> To read FirstRand Bank's Disclaimer for this email click on the following
> address or copy into your Internet browser:
> https://www.fnb.co.za/disclaimer.html
>
> If you are unable to access the Disclaimer, send a blank e-mail to
> firstrandbankdisclaimer(at)fnb(dot)co(dot)za and we will send you a copy of the
> Disclaimer.
>
--
Wysłane z mojego urządzenia przenośnego
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2010-08-30 20:11:35 | Re: MySQL versus Postgres |
Previous Message | Filip Rembiałkowski | 2010-08-30 19:55:09 | Re: Restore referencial integrity |