Re: [HACKERS] Bug? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Bug?
Date
Msg-id 199802061800.NAA15035@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Bug?  (Tom I Helbekkmo <tih@Hamartun.Priv.NO>)
Responses Re: [HACKERS] Bug?  (Tom I Helbekkmo <tih@Hamartun.Priv.NO>)
List pgsql-hackers
>
> Bruce Momjian said:
>
> > The only fix for this would be to read all integers in as 64-bit
> > integers, then do the conversion, but that could be a performance
> > problem.
>
> Michael Meskes answered:
>
> > I agree. And performance is important. I think explicit type
> > conversion is what we should do. Or is it asked for too much if the
> > user has to add a ::float8 to the number?
>
> Am I being dense here?  Can there really be a significant performance
> hit in the parsing of a query?  Let's say that it takes a millisecond
> extra to do the right thing with a number.  Does it matter?  How many
> queries per second can we expect to process anyway?

I don't know of standard ways to read in 64-bit integers.

--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Profile of current backend
Next
From: Bruce Momjian
Date:
Subject: Re: AW: AW: [HACKERS] Re: atttypmod of 0