Re: 500x speed-down: Wrong query plan?

On 1/9/06, Alessandro Baretta <a(dot)baretta(at)barettadeit(dot)com> wrote:
> Hello gentlemen,
>
> Although this is my first post on the list, I am a fairly experienced PostgreSQL
> programmer. I am writing an ERP application suite using PostgreSQL as the
> preferred DBMS. Let me state that the SQL DDL is automatically generated by a
> CASE tool from an ER model. The generated schema contains the appropriate
> primary key and foreign key constraints, as defined by the original ER model, as
> well as "reverse indexes" on foreign keys, allowing (in theory) rapid backward
> navigation of foreign keys in joins.
>
> Let me show a sample join of two tables in the database schema. The information
> provided is quite extensive. I'm sorry for that, but I think it is better to
> provide the list with all the relevant information.
>
> Package: postgresql-7.4

maybe, because you are in developing state, you can start to think in
upgrading to 8.1

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)