Re: [PERFORM] Talking about optimizer, my long dream

2011-03-01 Thread Merlin Moncure
2011/2/4 Mladen Gogala mladen.gog...@vmsinfo.com: Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread There is no optimizer vs. hint. Hints are a necessary part of the optimizer in all other databases. Without hints Postgres will not get used in the company that I work for,

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-28 Thread Robert Haas
2011/2/27 Віталій Тимчишин tiv...@gmail.com: 27 лютого 2011 р. 19:59 Robert Haas robertmh...@gmail.com написав: 2011/2/4 Віталій Тимчишин tiv...@gmail.com: Hi, all. All this optimizer vs hint thread reminded me about crazy idea that got to my head some time ago. I currently has two

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-27 Thread Robert Haas
2011/2/4 Віталій Тимчишин tiv...@gmail.com: Hi, all. All this optimizer vs hint thread reminded me about crazy idea that got to my head some time ago. I currently has two problems with postgresql optimizer 1) Dictionary tables. Very usual thing is something like select * from big_table where

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-27 Thread Віталій Тимчишин
27 лютого 2011 р. 19:59 Robert Haas robertmh...@gmail.com написав: 2011/2/4 Віталій Тимчишин tiv...@gmail.com: Hi, all. All this optimizer vs hint thread reminded me about crazy idea that got to my head some time ago. I currently has two problems with postgresql optimizer 1)

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-07 Thread Achilleas Mantzios
Greg, 1st off, thanx for your great book, and i really hope i find the time to read it thoroughly. (since i am still stuck somewhere in the middle of Administration Cookbook lol!) Well, people, speaking from the point of the occasional poster and frequent lurker i can see that smth is going a

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-06 Thread Mladen Gogala
Please, don't include me on your emails. I unsubscribed from the list. Cédric Villemain wrote: 2011/2/4 Frank Heikens frankheik...@mac.com: On 04 Feb, 2011,at 02:56 PM, Mladen Gogala mladen.gog...@vmsinfo.com wrote: Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread

[PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Віталій Тимчишин
Hi, all. All this optimizer vs hint thread reminded me about crazy idea that got to my head some time ago. I currently has two problems with postgresql optimizer 1) Dictionary tables. Very usual thing is something like select * from big_table where distionary_id = (select id from dictionary where

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Mladen Gogala
Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread There is no optimizer vs. hint. Hints are a necessary part of the optimizer in all other databases. Without hints Postgres will not get used in the company that I work for, period. I was willing to wait but the fatwa against

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Shaun Thomas
On 02/04/2011 07:56 AM, Mladen Gogala wrote: Hints are a necessary part of the optimizer in all other databases. Without hints Postgres will not get used in the company that I work for, period. I've said repeatedly that EnterpriseDB, a fork of PostgreSQL, has the hints you seek, yet you seem

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Greg Smith
Mladen Gogala wrote: I am even inclined to believe that deep down under the hood, this fatwa has an ulterior motive, which disgusts me deeply. With hints, there would be far fewer consulting gigs. Now you're just being rude. Given that you have direct access to the developers of the

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Mladen Gogala
Shaun Thomas wrote: On 02/04/2011 07:56 AM, Mladen Gogala wrote: Hints are a necessary part of the optimizer in all other databases. Without hints Postgres will not get used in the company that I work for, period. I've said repeatedly that EnterpriseDB, a fork of PostgreSQL, has the

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Frank Heikens
On 04 Feb, 2011,at 02:56 PM, Mladen Gogala mladen.gog...@vmsinfo.com wrote: Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread There is no optimizer vs. hint. Hints are a necessary part of the optimizer in all other databases. That has nothing to do with PostgreSQL:

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Cédric Villemain
2011/2/4 Frank Heikens frankheik...@mac.com: On 04 Feb, 2011,at 02:56 PM, Mladen Gogala mladen.gog...@vmsinfo.com wrote: Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread There is no optimizer vs. hint. Hints are a necessary part of the optimizer in all other databases.

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Mark Kirkwood
On 05/02/11 03:36, Mladen Gogala wrote: Shaun, I don't need to convince you or the Postgres community. I needed an argument to convince my boss. My argument was that the sanctimonious and narrow minded Postgres community is unwilling to even consider creating the tools I need for large porting

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Scott Marlowe
2011/2/4 Mark Kirkwood mark.kirkw...@catalyst.net.nz: Given that there are no hints, what do I do to solve the problem of a slow query suddenly popping up in production? If and when this situation occurs, see how quickly the community steps in to help you solve it (and it'd bet it will solved

Re: [PERFORM] Talking about optimizer, my long dream

2011-02-04 Thread Mark Kirkwood
O If Oracle can patch their query planner for you in 24 hours, and you can apply patch with confidence against your test then production servers in an hour or so, great. Til then I'll stick to a database that has the absolutely, without a doubt, best coder support of any project I've ever used.