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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
