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

2013-09-13 Thread Richard Poole
d to touch 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. Richa

[HACKERS] stray SIGALRM

2013-06-14 Thread Richard Poole
us what's a good way to fix 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.c

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 y

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 sma

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 ca

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 >

[HACKERS] "initdb -t" destroys all databases

2000-09-25 Thread Richard Poole
No response to this one on -general, so here goes... The documentation for initdb says that the "-t" (== "--template") option recreates the template1 database but doesn't touch anything else. But it seems that if it detects a failure it will abort and remove anything it *might* have created: --