Re: [HACKERS] switch UNLOGGED to LOGGED

2011-05-08 Thread Leonardo Francalanci
On Fri, Apr 22, 2011 at 4:13 AM, Leonardo Francalanci m_li...@yahoo.it wrote: Maybe you should change xl_act_commit to have a separate list of rels to drop the init fork for (instead of mixing those with the list of files to drop as a whole). I tried to follow your suggestion,

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

2011-05-08 Thread Greg Smith
Mitsuru IWASAKI wrote: the patch is available at: http://people.freebsd.org/~iwasaki/postgres/buffer-cache-hibernation-postgresql-20110508.patch We can't accept patches just based on a pointer to a web site. Please e-mail this to the mailing list so that it can be considered

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.

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

[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); -

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 clipper.ken...@gmail.com 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

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 package

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

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!

[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

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

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: Multiple failures

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 weis...@rbg.informatik.tu-darmstadt.de 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

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] Questions about the internal of fastpath function call

2011-05-08 Thread Tom Lane
lee Richard clipper.ken...@gmail.com 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.

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 module. All

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

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

[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] 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 t...@sss.pgh.pa.us 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

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

2011-05-08 Thread Tom Lane
Greg Stark gsst...@mit.edu 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:

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

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

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 to

Re: [HACKERS] Prefered Types

2011-05-08 Thread Tom Lane
Greg Sabino Mullane g...@turnstep.com 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

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