From: Jaime Casanova <systemguards@gmail.com>
To: Alessandro Baretta <a.baretta@barettadeit.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 500x speed-down: Wrong query plan?
Date: Mon, 9 Jan 2006 10:30:21 -0500
Message-ID: <c2d9e70e0601090730l7c6ec2f6gd0af6612a4332c4c@mail.gmail.com> (raw)
In-Reply-To: <43C26A5F.7040702@barettadeit.com>
References: <43C26A5F.7040702@barettadeit.com>
On 1/9/06, Alessandro Baretta <a.baretta@barettadeit.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 ;)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: systemguards@gmail.com, a.baretta@barettadeit.com
Subject: Re: 500x speed-down: Wrong query plan?
In-Reply-To: <c2d9e70e0601090730l7c6ec2f6gd0af6612a4332c4c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox