On Fri, 2009-01-16 at 12:35 -0600, Jason Long wrote:
> The schema is not auto generated. It evolved as I created my
> inventory system.
> It is relatively easy for humans to understand. Or at least for me
> since I wrote it.
On second look, there aren't that many tables. There are just a lot of
self joins. Those are going to be hard for PostgreSQL to optimize
effectively.
Looks like it's just the query that's hard to understand. You might do
better just writing it yourself from scratch.
Regards,
Jeff Davis