Re: Optimization support

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