[SQL] Changing location of ORDER BY has large effect on performance, but not results...

2005-11-03 Thread Jason Turner
I have two queries that return the same results, but one is 6 times slower than the other one, can anyone enlighten me as to why? My initial guess is that it is not able to utilize the index on foo.tracktitle to sort the result set after foo has been joined with other tables. This seems kind of br

Re: [SQL] Cross-database references

2003-01-28 Thread Jason Turner
On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the >implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? This is usually left u