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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 1/9/06, Alessandro Baretta <a.baretta@xxxxxxxxxxxxxxx> 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 ;)


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux