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

2011-03-01 Thread Merlin Moncure
2011/2/4 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

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

2011-02-28 Thread Robert Haas
2011/2/27 Віталій Тимчишин : > > > 27 лютого 2011 р. 19:59 Robert Haas написав: >> >> 2011/2/4 Віталій Тимчишин : >> > 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 optimiz

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

2011-02-27 Thread Віталій Тимчишин
27 лютого 2011 р. 19:59 Robert Haas написав: > 2011/2/4 Віталій Тимчишин : > > 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

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

2011-02-27 Thread Robert Haas
2011/2/4 Віталій Тимчишин : > 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 distionar

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 : On 04 Feb, 2011,at 02:56 PM, Mladen Gogala wrote: Віталій Тимчишин wrote: Hi, all. All this optimizer vs hint thread There is no "optimizer vs. hint". Hin

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.

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

2011-02-04 Thread Scott Marlowe
2011/2/4 Mark Kirkwood : > 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 be very quickly indeed).

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 Cédric Villemain
2011/2/4 Frank Heikens : > > > On 04 Feb, 2011,at 02:56 PM, Mladen Gogala > 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

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

2011-02-04 Thread Frank Heikens
On 04 Feb, 2011,at 02:56 PM, Mladen Gogala 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: PostgreSQL = PostgreSQL.

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 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 software

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 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