[HACKERS] patch: add MAP_HUGETLB to mmap() where supported (WIP)

2013-09-13 Thread Richard Poole
most of the buffers, this patch saves nearly 8MB of memory per backend and improves performances by just over 2% on average. It is still WIP as there are a couple of points that Andres has pointed out to me that haven't been addressed yet; also, the documentation is incomplete. Richard -- Richard

[HACKERS] stray SIGALRM

2013-06-14 Thread Richard Poole
it without losing the benefits of that commit. Thanks Alvaro and Andres for helping me get from why is my copy getting these signals to understanding what's actually going on. Richard -- Richard Poole http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [HACKERS] another plperl bug

2004-11-23 Thread Richard Poole
On Tue, Nov 23, 2004 at 11:37:22AM -0500, Tom Lane wrote: CREATE FUNCTION test1() RETURNS TEXT AS $$ return [test]; $$ LANGUAGE plperl; SELECT test1(); test1 -- ARRAY(0x8427a58) (1 row) This is exactly what Perl will do if you try to coerce an

Re: [HACKERS] CVS Messages

2002-08-17 Thread Richard Poole
On Fri, Aug 16, 2002 at 05:44:50PM -0400, Rod Taylor wrote: Is it possible for the cvs emails to include a URL to the appropriate entries in cvs web? The below is current: Modified files: src/backend/utils/adt: ruleutils.c If you're using a Web browser with support for smart

Re: [HACKERS] Re: Outstanding patches

2001-05-08 Thread Richard Poole
On Tue, May 08, 2001 at 05:49:16PM -0400, Tom Lane wrote: I presume that Ian is not thinking about such a scenario, but only about using %type in a schema file that he will reload into a freshly created database each time he edits it. That avoids the issue of whether %type declarations can

Re: [HACKERS] Query not using index, please explain.

2001-03-08 Thread Richard Poole
On Thu, Mar 08, 2001 at 02:43:54PM -0500, Matthew Hagerty wrote: Richard, Thanks for the response, I guess I should have included a little more information. The table contains 3.5 million rows. The indexes were created after the data was imported into the table and I had just run