Horton

Re: 7.3.1 New install, large queries are slow

Josh Berkus <josh@agliodbs.com>

View thread View on postgr.es
From: "Josh Berkus" <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, "Roman Fail" <rfail@posportal.com>
Cc: josh@agliodbs.com, pgsql-performance@postgresql.org
Date: 2003-01-16T04:41:11Z
Lists: pgsql-performance 
Tom, Roman,

> I think more likely the issue is that your use of JOIN syntax is
> forcing
> Postgres into a bad plan.  MSSQL probably doesn't assign any semantic
> significance to the use of "a JOIN b" syntax as opposed to "FROM a,
> b"
> syntax.  

That's correct.  MSSQL will reorder equijoins, even when explicitly
declared.

Hey, Roman, how many records in BatchDetail, anyway?

Josh Berkus