| From: | David Gardner <david(at)gardnerit(dot)net> |
|---|---|
| To: | |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Optimization support |
| Date: | 2009-01-04 06:44:09 |
| Message-ID: | 49605AB9.9080901@gardnerit.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
As an addition to that, I would recommend pgadmin3's graphical explain
tool, the diagrams it generates are (in my opinion) fantastic and help
me quickly spot problems in my schema/query.
Also take a look at:
http://www.postgresql.org/docs/8.3/static/kernel-resources.html
in regards to SHMMAX in Linux you should be able to check your current
setting by doing:
cat /proc/sys/kernel/shmmax
Did you vacuum and analyze the database tables?
>> Any support appreciated.
>>
>
> Use 'explain analyse <your query>' to get the execution plan.
>
>
> Andreas
>
--
David Gardner
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2009-01-05 13:47:24 | Re: How does "createlang" interact with different schemas? |
| Previous Message | Andreas Kretschmer | 2009-01-03 18:21:25 | Re: Optimization support |