"Also sprach Tom Lane:"
> "Peter T. Breuer" <[EMAIL PROTECTED]> writes:
> > But can I prepare a DECLARE x BINARY CURSOR FOR SELECT ... statement?
> > The manual seems to say no.
>
> No, you just prepare the SELECT. At the protocol level, DECLARE CURSOR
> is a tad useless. You can still fetch th
these bogus rowcount estimates are a bit strange. if you have 800K
rows and select 100K of them the rowcount estimate should most likely
come from the histogram for the column. can you check what the
histograms are for
referrer path tables refferrer_domain where id <= referrer_domain
'media
On Fri, May 25, 2007 at 06:45:15PM -0700, Craig James wrote:
We're thinking of building some new servers. We bought some a while back
that have ECC (error correcting) RAM, which is absurdly expensive compared
to the same amount of non-ECC RAM. Does anyone have any real-life data
about the err
On Sat, May 26, 2007 at 08:43:15AM -0400, Michael Stone wrote:
> On Fri, May 25, 2007 at 06:45:15PM -0700, Craig James wrote:
> >We're thinking of building some new servers. We bought some a while back
> >that have ECC (error correcting) RAM, which is absurdly expensive compared
> >to the same a
"Peter T. Breuer" <[EMAIL PROTECTED]> writes:
> "Also sprach Tom Lane:"
>> No, you just prepare the SELECT. At the protocol level, DECLARE CURSOR
>> is a tad useless. You can still fetch the data in binary if you want...
> How? It's a 7.4 server (or may be, more generally) and declare binary
>
