Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-08 Thread Mitsuru IWASAKI
Hi, Sorry, I missed these messages because I didn't subscribe to this list. # I've just subscribed temporary > > I think that all the complexity with CRCs etc. is unlikely to lead anywhere > > too, and those two issues are not completely unrelated.  The simplest, > > safest thing here is the right

Re: [HACKERS] Prefered Types

2011-05-08 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Tom and I: >>> BTW, not to rain on the parade or anything, but I'll bet that >>> rejiggering anything at all here will result in whining that puts the >>> 8.3-era removal of a few implicit casts to shame. >> I'll take that bet, as it's really h

Re: [HACKERS] Prefered Types

2011-05-08 Thread Tom Lane
"Greg Sabino Mullane" writes: > Tom Lane wrote: >> BTW, not to rain on the parade or anything, but I'll bet that >> rejiggering anything at all here will result in whining that puts the >> 8.3-era removal of a few implicit casts to shame. > I'll take that bet, as it's really hard to imagine anyth

Re: [HACKERS] Prefered Types

2011-05-08 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Tom Lane wrote: > BTW, not to rain on the parade or anything, but I'll bet that > rejiggering anything at all here will result in whining that puts the > 8.3-era removal of a few implicit casts to shame. I'll take that bet, as it's really hard

Re: [HACKERS] "make check" in src/test/isolation is unworkable

2011-05-08 Thread Andrew Dunstan
On 05/08/2011 07:35 PM, Tom Lane wrote: I believe that the "make check" target in src/test/isolation is fundamentally unportable, as is illustrated by the fact that buildfarm member coypu is currently choking on it. The reason is that the pg_isolation_regress program depends on libpq, and in p

Re: [HACKERS] patch: fix race in SSI's CheckTargetForConflictsIn

2011-05-08 Thread Dan Ports
On Fri, May 06, 2011 at 10:49:22PM -0400, Dan Ports wrote: > Will update the patch. Updated patch (in response to Robert's comments) attached. Dan -- Dan R. K. Ports MIT CSAILhttp://drkp.net/ diff --git a/src/backend/storage/lmgr/predicate.c b/src/backend/storage/lm

Re: [HACKERS] "make check" in src/test/isolation is unworkable

2011-05-08 Thread Tom Lane
Greg Stark writes: > How is this different from the regular case with pg_regress? pg_regress doesn't link in libpq. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

Re: [HACKERS] "make check" in src/test/isolation is unworkable

2011-05-08 Thread Greg Stark
On Mon, May 9, 2011 at 12:35 AM, Tom Lane wrote: > While we could maybe hack this to the point where it works (on some > platforms) by dynamically linking libpq from the source tree, I don't > think it's worth the trouble. > How is this different from the regular case with pg_regress? -- greg

[HACKERS] "make check" in src/test/isolation is unworkable

2011-05-08 Thread Tom Lane
I believe that the "make check" target in src/test/isolation is fundamentally unportable, as is illustrated by the fact that buildfarm member coypu is currently choking on it. The reason is that the pg_isolation_regress program depends on libpq, and in particular it depends on having an *installed

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
Tom, Thanks a lot. The part I cant understand is I cant see where SendFunctionResult construct the return value into the buf. I expect it should copy something in retval to buf, but I cant find any of this in the code, the main logic of SendFunctionResult is: 00159 getTypeOutputInfo

Re: [HACKERS] XML with invalid chars

2011-05-08 Thread Andrew Dunstan
On 04/27/2011 11:41 PM, Noah Misch wrote: On Wed, Apr 27, 2011 at 11:22:37PM -0400, Andrew Dunstan wrote: On 04/27/2011 05:30 PM, Noah Misch wrote: To make things worse, the dump/reload problems seems to depend on your version of libxml2, or something. With git master, a CentOS 5 system with

Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-08 Thread Heikki Linnakangas
On 08.05.2011 07:58, Mitsuru IWASAKI wrote: I'll do more testing tomorrow, and hopefully finalize my patch. Done! the patch is available at: http://people.freebsd.org/~iwasaki/postgres/buffer-cache-hibernation-postgresql-20110508.patch I'd suggest doing this as an extension modul

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread Tom Lane
lee Richard writes: > I still can not see how it return a single return value to the client, and > why it call FunctionCall1() again when it want to send the result. pq_endmessage is where the bytes actually get pushed out to the client, if that's what you're looking for. The rest of the activit

Re: [HACKERS] improvements to pgtune

2011-05-08 Thread Greg Smith
Shiv wrote: So my exams are over now and am fully committed to the project in terms of time. I have started compiling a sort of personal todo for myself. I agree with your advice to start the project with small steps first. (I have a copy of the code and am trying to glean as much of it as I

Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Greg Stark
On Sun, May 8, 2011 at 4:18 PM, Yves Weißig wrote: > ERROR:  xlog flush request 3FD/0 is not satisfied --- flushed only to > 0/20E2DC4 > That's a pretty big difference in log positions. It seems likely you've overwritten the block header writing garbage to the LSN. -- greg -- Sent via pgsql-h

Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Yves Weißig
Am 08.05.2011 17:38, schrieb Kevin Grittner: > Yves Weißig wrote: > >> my experimental index which I am developing still has some >> problems. Perhaps the list has some advices or hints where this >> error might occur: >> >> WARNING: could not write block 6 of base/459204/483963 >> DETAIL: Multip

Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Kevin Grittner
Yves Weißig wrote: > my experimental index which I am developing still has some > problems. Perhaps the list has some advices or hints where this > error might occur: > > WARNING: could not write block 6 of base/459204/483963 > DETAIL: Multiple failures --- write error might be permanent. > > d

[HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Yves Weißig
Hi again pgsql-hackers, my experimental index which I am developing still has some problems. Perhaps the list has some advices or hints where this error might occur: WARNING: could not write block 6 of base/459204/483963 DETAIL: Multiple failures --- write error might be permanent. directly fo

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-08 Thread Christopher Browne
My example is of doing "self-discovery" to see if all needful database components seem to be properly installed. E.g. - the app needs pgcrypto, intarray, and a custom data type. The install script can consequently inform the production folk either "looks good", or, alternately, "seems problematic

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
Merlin, Oh, I didnt realized that it does not support to return scalar, thanks a lot. When it returns a single value, I see it use the following function, SendFunctionCall result = DatumGetByteaP(FunctionCall1(flinfo, val)); I still can not see how it return a single return value to the

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-08 Thread Peter Eisentraut
On sön, 2011-05-08 at 07:21 -0400, Andrew Dunstan wrote: > As I said there: "to see how the libraries are configured, for example." > > Just the other day I wanted to know what compilation options had been > used for a particular installation. pg_config wasn't installed because > the -devel pack

Re: [HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread Merlin Moncure
On Sun, May 8, 2011 at 8:01 AM, lee Richard wrote: > Hi, > > I am reading the source code of fastpath to understand the internal of > fastpath. I can not understand how does it send result to the client, I hope > somebody can help me on this. > > I see it call it invoke the function in > > HandleF

[HACKERS] Questions about the internal of fastpath function call

2011-05-08 Thread lee Richard
Hi, I am reading the source code of fastpath to understand the internal of fastpath. I can not understand how does it send result to the client, I hope somebody can help me on this. I see it call it invoke the function in HandleFunctionRequest() -> retval = FunctionCallInvoke(&fcinfo); -> Se

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-08 Thread Andrew Dunstan
On 05/08/2011 05:24 AM, Peter Eisentraut wrote: On lör, 2011-05-07 at 17:38 -0400, Andrew Dunstan wrote: On 05/07/2011 05:26 PM, Peter Eisentraut wrote: On lör, 2011-05-07 at 17:16 -0400, Andrew Dunstan wrote: pg_config is useful quite apart from its use in building things, as was discussed

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-08 Thread Peter Eisentraut
On lör, 2011-05-07 at 17:38 -0400, Andrew Dunstan wrote: > > On 05/07/2011 05:26 PM, Peter Eisentraut wrote: > > On lör, 2011-05-07 at 17:16 -0400, Andrew Dunstan wrote: > >> pg_config is useful quite apart from its use in building things, as was > >> discussed upthread. > > Link please. > > > >