Hi Tom,
Tom Lane schreef:
> Well, the planner does put some emphasis on startup time when dealing
> with a DECLARE CURSOR plan; the problem you face is just that that
> correction isn't large enough. (From memory, I think it optimizes on
> the assumption that 10% of the estimated rows will actual
> I have never used Oracle myself, nor have I read its license
agreement,
> but what if you didn't name Oracle directly? ie:
>
> TPS Database
> ---
> 112 MySQL
> 120 PgSQL
> 90Sybase
> 95"Other database that *may* start with a letter after N"
> 50
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> I cannot change the query (it is geneated by a tool called Clarion) but it
> something like (from the psqlodbc_xxx.log):
> "...
> declare SQL_CUR01 cursor for
> SELECT A.ordernummer, B.klantnummer FROM "orders" A LEFT OUTER JOIN "klt_alg"
> B ON
Hi Tom,
Tom Lane schreef:
> On the surface this looks like a reasonable plan choice. If you like
> you can try the other two basic types of join plan by turning off
> enable_hashjoin, which will likely drive the planner to use a merge
> join, and then also turn off enable_mergejoin to get a neste
Mike Benoit <[EMAIL PROTECTED]> writes:
> I have never used Oracle myself, nor have I read its license agreement,
> but what if you didn't name Oracle directly? ie:
> TPS Database
> ---
> 112 MySQL
> 120 PgSQL
> 90Sybase
> 95"Other database that *m
In terms of performance, Oracle is to Postgres as Postgres is to Mysql:
More
complexity, more overhead, more layers of abstraction, but in the long
run it
pays off when you need it. (Only without the user-friendliness of either
open-source softwares.)
I don't find postgres complex... I find
For example, I am a developer of Mambo, a PHP-based CMS application,
and am porting the mysql functions to ADOdb so I can use grown-up
databases ;-)
Just yesterday I "optimized" a query for a website running MySQL. It's
the 'new products' type query :
SELECT product_id, pd.product_name, p.pric
I have never used Oracle myself, nor have I read its license agreement,
but what if you didn't name Oracle directly? ie:
TPS Database
---
112 MySQL
120 PgSQL
90 Sybase
95 "Other database that *may* start with a letter after N"
50 "Othe
Richard Huxton writes:
> Joost Kraaijeveld wrote:
>> 2. If not, what can I do about it?
> The key thing to look for here is the number of rows. If PG expects say
> 100 rows but there are instead 10,000 then it may choose the wrong plan.
> In this case the estimate is 1,100,836 and the actual is
Jeff <[EMAIL PROTECTED]> writes:
> After using oracle in the last few months.. I can see why they'd want to
> prevent those numbers.. Oracle really isn't that good. I had been under the
> impression that it was holy smokes amazingly fast. It just isn't. At least,
> in my experience it isn't.
On Feb 11, 2005, at 2:04 AM, Mitch Pirtle wrote:
I did do the research, but couldn't find one instance where someone
was actually taken to task over it. So far it appears to be bluster.
Horrifying to some, but still bluster.
They may not have done that yet, but they _COULD_. And if they decide
to
Bruno Wolff III wrote:
On Fri, Feb 11, 2005 at 02:22:39 -0500,
Jaime Casanova <[EMAIL PROTECTED]> wrote:
Think anout it, In USA you can speak and publish about the President
but cannot say anything about M$ or Oracles' DBMS?
Not if you signed a contract that says you can't.
If you didn't actuall
On Fri, Feb 11, 2005 at 02:22:39 -0500,
Jaime Casanova <[EMAIL PROTECTED]> wrote:
> What about the free speech rigths, in USA they are in the constitution
> and cannot be denied or revoked, IANAL.
You can voluntarily give up your rights to free speech in the US.
> And like stated by Mitch just
Joost Kraaijeveld wrote:
Hi all,
A question on how to read and interpret the explain analyse statement
(and what to do)
I have a query "SELECT A.ordernummer, B.klantnummer FROM orders A
LEFT OUTER JOIN klt_alg B ON A.Klantnummer=B.Klantnummer ORDER BY
A.klantnummer;"
Both tables have an btree index
Hi all,
A question on how to read and interpret the explain analyse statement (and what
to do)
I have a query "SELECT A.ordernummer, B.klantnummer FROM orders A LEFT OUTER
JOIN klt_alg B ON A.Klantnummer=B.Klantnummer ORDER BY A.klantnummer;"
Both tables have an btree index on klantnummer (int
15 matches
Mail list logo
