Search Discussions
-
Currently, here are the options available for wal_sync_method: #wal_sync_method = fsync # the default varies across platforms: # fsync, fdatasync, fsync_writethrough, # open_sync, open_datasync I ...
Bruce Momjian
Aug 8, 2005 at 7:56 pm
Aug 29, 2005 at 3:20 pm -
Hello, I have negotiated with the author of pl/Ruby to release plRuby under the PostgreSQL license. The reason I did this is the following: 1. I felt we needed a truly OO language in core. 2. ...
Joshua D. Drake
Aug 15, 2005 at 5:28 pm
Aug 18, 2005 at 12:42 am -
I have compiled the 8.1 release notes and converted them to SGML at: http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1 I still need to add markup and cleanup, but it is good ...
Bruce Momjian
Aug 23, 2005 at 3:16 am
Aug 25, 2005 at 12:34 am -
Don't know if anyone else has noticed, but cvsweb is a bit slow right now and mailing list response times have gotten really slow. Could we use more machines or bandwidth? -- Jim C. Nasby, Sr. ...
Jim C. Nasby
Aug 24, 2005 at 10:37 pm
Aug 26, 2005 at 5:09 pm -
I saw in the release notes that 8.1 is supposed to do function syntax checking at create rather than run time, but with the first beta this does not seem to work. check function bodies is on by ...
Tony Caduto
Aug 31, 2005 at 4:39 pm
Sep 2, 2005 at 2:26 am -
Hi all, I've done a quick hack to implement PCTFREE on PostgreSQL. As you know, it's inspired by Oracle's PCTFREE. http://www.csee.umbc.edu/help/oracle8/server.815/a67772/schema.htm#990 ...
Satoshi Nagayasu
Aug 22, 2005 at 12:03 am
Sep 2, 2005 at 12:52 am -
I was reminded again today of the problem that once a database has been in existence long enough for the OID counter to wrap around, people will get occasional errors due to OID collisions, eg ...
Tom Lane
Aug 3, 2005 at 11:43 pm
Aug 10, 2005 at 9:40 pm -
While marking up TODO for potential new-hacker items I've run across some items that probably need more explanation: o Allow commenting of variables in postgresql.conf to restore them to defaults ...
Jim C. Nasby
Aug 24, 2005 at 5:44 am
Aug 26, 2005 at 7:48 pm -
It seems to me that contrib/dblink could greatly simplify the design and coding of multi-user regression tests. Is there objection to a portion of src/test/regress depending on contrib/dblink? I'm ...
Matt Miller
Aug 10, 2005 at 7:17 pm
Aug 22, 2005 at 9:35 pm -
Hi, With a help from Bruce, I wrote a small function which returns row locking information(see attached file if you are interested). Here is a sample result: test=# select * from pgrowlocks('t1'); ...
Tatsuo Ishii
Aug 7, 2005 at 12:47 pm
Apr 23, 2006 at 1:14 am -
8.1-beta1 produces some odd results with statement logging enabled when the extended query protocol is used (e.g. when using the JDBC driver). Repeatedly running a simple query with log_statement = ...
Oliver Jowett
Aug 31, 2005 at 2:34 am
Sep 25, 2005 at 11:27 pm -
Is anybody working on allowing indexes to span multiple tables? IF not, I'll give it a try. -- Make April 15 just another day, visit http://fairtax.org
Joshua N Pritikin
Aug 22, 2005 at 6:31 pm
Aug 24, 2005 at 2:06 pm -
I have an example of runs that illustrate a performance problem that occurred between installing the 7/18 and 8/1 development release codes. I'm running on a PPC64 8-way system, with 16GB of memory ...
Mary Edie Meredith
Aug 11, 2005 at 10:13 pm
Aug 29, 2005 at 9:36 pm -
Would anybody object to a patch to update psql's tab completion for SET/RESET/SHOW to include everything that SHOW shows for a superuser? I count about 65 variables that SHOW shows that are missing ...
Michael Fuhr
Aug 13, 2005 at 6:01 am
Aug 22, 2005 at 8:01 pm -
I made a pass over the TODO list to see what was out of date. This comment may be out of date. Suggest Lock table corruption following SIGTERM of an individual backend has been reported in 8.0. A ...
Tom Lane
Aug 25, 2005 at 1:58 am
Aug 26, 2005 at 10:15 pm -
What do people think of exposing pg_usleep() to the user? It's sometimes useful to have a server-side sleep function, and people do ask about it occasionally (e.g., Don Drake today in pgsql-admin). ...
Michael Fuhr
Aug 21, 2005 at 10:52 pm
Aug 24, 2005 at 5:55 pm -
For a while now, I've been seeking a method of reducing the impact of VACUUM when run against a database where 80-95% of the data is effectively read only and will not be deleted/updated again. This ...
Simon Riggs
Aug 31, 2005 at 10:17 pm
Sep 22, 2005 at 7:15 am -
Once more: I would like to get at least some answer, why my patch for enabling concurrent VACUUM was left out from 8.1. It was submitted well in time, and there was only minimal amount of discussion ...
Hannu Krosing
Aug 16, 2005 at 9:02 pm
Aug 23, 2005 at 6:58 am -
Hello, I just found quite a strange behaviour of 8.1beta on SunOS: uname -a: SunOS sun46 5.8 Generic_108528-14 sun4u sparc SUNW,Ultra-80 gcc -v: Reading specs from ...
Sergey E. Koposov
Aug 29, 2005 at 11:50 am
Aug 30, 2005 at 5:12 pm -
I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL)
Mark L. Woodward
Aug 3, 2005 at 8:55 pm
Sep 16, 2005 at 3:55 pm -
It looks like when we changed regress/GNUmakefile to pull rules from Makefile.shlib, cygwin got broken in the process. The problem is that regess.dll ends up being a symlink back to itself, because ...
Rocco Altier
Aug 4, 2005 at 7:05 pm
Aug 9, 2005 at 6:09 am -
Hi, As part of previous discussions about typmod for user type, Tom mentioned that you would need to make type and function names equivalent. As it turns out, if you refactor a few rules, you can ...
Martijn van Oosterhout
Aug 31, 2005 at 1:32 pm
Jun 14, 2006 at 5:56 pm -
Has anyone been able to set kern.sysv.shmmax above 4MB at all in latest OS X? I just spent a while trying what seemed every possible permutation of setting up /etc/sysctl.conf and editing /etc/rc ...
Tom Lane
Aug 30, 2005 at 12:18 am
Oct 16, 2005 at 8:49 pm -
Unfortunately I just found that we still cannot build in thread safety mode on Windows, due to an error on my part - specifically, I concentrated on libpq, not realising that ecpglib is also thread ...
Dave Page
Aug 24, 2005 at 9:50 pm
Aug 29, 2005 at 3:19 pm -
Hello, What might this be? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support ...
Joshua D. Drake
Aug 1, 2005 at 6:57 pm
Aug 9, 2005 at 6:33 pm -
"create user foo with createdb" will create a user with createdb privilege. "create user bar with createuser" will create s superuser who can createdb, createuser, and update system catalog. Why not ...
William ZHANG
Aug 12, 2005 at 10:14 am
Aug 24, 2005 at 7:50 am -
Currently, pg_config will tell about the configure options that were used, but it does not let you find out if any environment variables were used to determine CC, CFLAGS, etc. More than once I've ...
Tom Lane
Aug 9, 2005 at 6:49 pm
Aug 14, 2005 at 9:47 pm -
The core committee has agreed that we need to do a set of releases in the back branches soon --- certainly 8.0 has accumulated a critical mass of changes since 8.0.3, and probably there's enough to ...
Tom Lane
Aug 15, 2005 at 5:06 pm
Aug 17, 2005 at 12:53 pm -
Folks, we need to address the questions asked in this email and get it into CVS soon. --------------------------------------------------------------------------- Magnus Hagander wrote: ...
Bruce Momjian
Aug 13, 2005 at 3:05 am
Aug 24, 2005 at 4:59 pm -
Hello, As I have been laboring over the documentation of the postgresql.conf file for 8.1dev it seems that it may be useful to rip out most of the options in this file? Considering many of the ...
Joshua D. Drake
Aug 7, 2005 at 9:14 pm
Aug 8, 2005 at 9:04 pm -
Folks, I've noticed that \df doesn't do quite what it might when a function is created with named input parameters. Please find enclosed a patch against CVS TIP that does this better. On a slightly ...
David Fetter
Aug 29, 2005 at 3:19 am
Sep 23, 2005 at 8:32 pm -
I'm currently testing pgAdmin support for slony, on pgsql CVS HEAD, and encounter strange problems from time to time. After dropping and recreating the slony schema, all changes committed and all ...
Andreas Pflug
Aug 28, 2005 at 8:23 pm
Aug 30, 2005 at 11:04 pm -
Project members: On behalf of the PostgreSQL Core Team, I welcome Dave Page. Dave has been the head of the pgODBC project for a couple of years, started the pgAdmin project in 1998, has been our lead ...
Josh Berkus
Aug 26, 2005 at 12:56 am
Aug 26, 2005 at 8:55 pm -
I have just managed to get pg server and client (cvs tip) talking IPv6 on Windows. :-) 1. Building - added in library in configure.in: AC_CHECK_LIB(ws2_32, main) - faked out getaddrinfo test in ...
Andrew Dunstan
Aug 18, 2005 at 10:16 pm
Aug 19, 2005 at 5:17 pm -
Dear PostreSQL hackers, For the interested, here: http://www.cs.utwente.nl/~hiemstra/courses/reports/sqlxml.pdf you find a little report discussing possibilities to implement the SQL/XML standard ...
Djoerd Hiemstra
Aug 18, 2005 at 8:50 am
Mar 21, 2006 at 12:18 pm -
I have a table with several 'smallint' fields that I'd like to convert to booleean ... the data in each is either 0 or 1, and: # select '1'::boolean; bool ------ t (1 row) # select '0'::boolean; bool ...
Marc G. Fournier
Aug 29, 2005 at 11:15 pm
Sep 1, 2005 at 10:16 pm -
Context diff, please, diff -c. --------------------------------------------------------------------------- Chuck McDevitt wrote: Content-Description: getaddrinfo.patch [ Attachment, skipping... ] -- ...
Bruce Momjian
Aug 24, 2005 at 7:07 pm
Aug 25, 2005 at 8:31 am -
Hi all, I propose to add an internal function gettime() that transparently returns the current system time, as a timestamptz with maximum precision. Calling gettime() would be a more elegant approach ...
Brendan Jurd
Aug 7, 2005 at 6:10 am
Aug 17, 2005 at 10:27 pm -
Did we recently make some fixes for FBSD that cured the problem with unresolved pthread* symbols for plpython? If so, should we look at possibly doing something similar for OpenBSD? That might clean ...
Andrew Dunstan
Aug 3, 2005 at 2:33 pm
Sep 26, 2005 at 4:48 pm -
Is enable_constraint_exclusion the proper name for this feature? I know we have enable* in the optimizer settings, but that naming seems unfortunate in that we should have just called it hash_join ...
Bruce Momjian
Aug 19, 2005 at 8:56 pm
Aug 22, 2005 at 10:08 pm -
[ redirected to -hackers ] I wrote: After a quick look through the code, it seems like the way to do this is to add an extra bool parameter "nest_triggers" to _SPI_pquery, which when false would ...
Tom Lane
Aug 16, 2005 at 3:00 pm
Aug 22, 2005 at 8:54 pm -
I had posted this earlier, but had insufficient info (or access) to provide much detail ... now, I've got the access, and this really isn't making much sense ... Have databse that \ds shows several ...
Marc G. Fournier
Aug 2, 2005 at 7:31 pm
Aug 3, 2005 at 2:43 am -
[Please CC any replies, thanks] Hi, I saw the discussion about an tester for MVCC. Since I'd never done anything with asyncronous queries before, I figured I'd try to write something useful with it. ...
Martijn van Oosterhout
Aug 29, 2005 at 10:56 pm
Sep 6, 2005 at 9:04 pm -
I just noticed that AlterSchemaOwner (and others like AlterFunctionOwner -- I haven't checked anything else yet) does not release the lock on pg_namespace (resp. AlterFunctionOwner) after it's done ...
Alvaro Herrera
Aug 19, 2005 at 4:13 pm
Aug 20, 2005 at 2:28 pm -
Hi! I played around with roles a bit today and noticed some minor things: ALTER ROLE seems to support ALTER ROLE <name ROLE <name - but that form is not mentioned in the docs: playground=# CREATE ...
Stefan Kaltenbrunner
Aug 15, 2005 at 9:46 am
Sep 23, 2005 at 10:25 pm -
I thought some more about this and came up with a sketch of a solution. This would solve the problem of loading subtly-bogus language definitions from existing dump files, and it also offers a ...
Tom Lane
Aug 31, 2005 at 9:56 pm
Sep 2, 2005 at 8:29 pm -
Hi, I've recently had problems with slow queries caused by the selectivity of the <@ ltree operator, as you may see in my post here: ...
Matteo Beccati
Aug 4, 2005 at 2:37 pm
Aug 13, 2005 at 3:05 am -
[Please CC any replies so I don't have to follow them via the archives] Hi, I'm trying to create a set of types that are going to share the INPUT and OUTPUT functions (written in C). For output you ...
Martijn van Oosterhout
Aug 11, 2005 at 3:33 pm
Aug 12, 2005 at 9:50 pm -
I just spent a tedious hour digging through the buildfarm results to see what I could learn about the intermittent failures we're seeing in the stats regression test, such as here: ...
Tom Lane
Aug 30, 2005 at 4:30 am
Aug 31, 2005 at 12:36 am -
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. ---559023410-560155114-1125148906=:16397 ...
Oleg Bartunov
Aug 27, 2005 at 1:21 pm
Aug 27, 2005 at 6:32 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 151 |
posts | 1,191 |
users | 154 |
website | postgresql.org... |
irc | #postgresql |
154 users for August 2005
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)