Re: PGSQL and Nested Loops - Mailing list pgsql-novice

From Tom Lane
Subject Re: PGSQL and Nested Loops
Date
Msg-id 13177.1125968750@sss.pgh.pa.us
Whole thread Raw
In response to Re: PGSQL and Nested Loops  (<operationsengineer1@yahoo.com>)
List pgsql-novice
<operationsengineer1@yahoo.com> writes:
> since he's a cut and paste sql writer, i may have
> jumped the gun since he may be doing everying wrong
> and then complaining pgsql isn't as efficient as a
> wrong to do things.  ;-)

> anyway, *if* his point is valid, i'd appreciate input.

With no specifics as to what he was doing, it's impossible to evaluate
whether the complaint is valid or not.  I don't say he lied about the
times he observed, but there's no way to tell if it's a stupid query
design, failure to configure/tune the database properly, or a genuine
Postgres performance issue --- much less whether any such issue has
been fixed later.

I would translate the complaint as follows: "I know about SQL Server
and I can't be bothered to learn about Postgres".  Pretty much a
self-fulfilling prophecy, eh?

            regards, tom lane

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: PGSQL and Nested Loops
Next
From: bob_a@xypro.com
Date:
Subject: ERROR: 42P01: relation "