[GENERAL] Optimiser desicion bringing system to its knees?

Hi everyone, My performance on a big mission critical system has recently collapsed, and I've finally traced it down to the postgresql optimiser I think. I'm running postgresql-7.2.1-2PGDG The explains below make it clear I think. If I just change the table declaration order, I get MASSIVELY bett

Re: [GENERAL] Optimiser desicion bringing system to its knees?

o if you > are running a current version of PostgreSQL? Specifically either > 7.3.4 or even 7.4RC1. > > Sincerely, > > Joshua Drake > > > Craig O'Shannessy wrote: > > > Hi everyone, > > > > My performance on a big mission critical system

[GENERAL] int8 primary keys still not using index without manual JDBC driver patch (7.4RC1)

Hi all, Just thought I'd mention that I really think this problem needs to be fixed. I I'm patching the 7.4RC1 JDBC drivers as we speak due to this optimiser bug, and it's the third time I've had to do this. I would think this bug causes quite a lot of people to evaluate postgres and decide

Re: [GENERAL] Optimiser desicion bringing system to its knees?

Ahh, this makes sense. I've recently changed this into a partial index because I was getting awful performance on it. Thanks Tom, this gives me a stopgap fix until I can get 7.4 into production. Craig On Thu, 6 Nov 2003, Tom Lane wrote: > "Craig O'Shannessy" <

Re: [GENERAL] int8 primary keys still not using index without manual

call it my pet peeve. Craig On Fri, 7 Nov 2003, Martijn van Oosterhout wrote: > Any particular reason you can't just put the value in quotes and let > postgres determine the type? > > On Fri, Nov 07, 2003 at 10:43:05AM +1100, Craig O'Shannessy wrote: > > Hi all, > &g

Re: [GENERAL] disaster recovery

On Fri, 28 Nov 2003, Marco Colombo wrote: > On Fri, 28 Nov 2003, Craig O'Shannessy wrote: > > > > > > > From my point of view, it's just support for my demands to have each > > > mission-critical server supported by a UPS, if not re

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

er be compromised. If you use a tool like > webmin, it not really any more complicated. Anyone who complains about > it being "too hard" to offer PG as a shared hosting option just hasn't > investigated the possibility. > > In my experience, many ISPs and

Re: [GENERAL] Pronouncing PostgreSQL

Me too. On Thu, 4 Dec 2003, Chris Stokes wrote: > I use your third pronunciation > > Regards, > Chris Stokes > Senior Systems Consultant > Bass Software > [EMAIL PROTECTED] > Main +613 8415 9300 > Direct +613 8415 9305 > > > -Original Message-