Search Discussions
-
What is the official stance on handling compiler warnings? I got a bit curious today on how many warnings our builds are generating on the buildfarm. I have hacked up a small script that (in a very ...
Stefan Kaltenbrunner
Jul 12, 2007 at 1:25 pm
Jul 17, 2007 at 4:04 pm -
Recently I've been involved in or overheard discussions about SMP scalability at both the PA PgSQL get together and in some list traffic. myYearbook.com would ike to make one of our previous ...
Gavin M. Roy
Jul 25, 2007 at 3:16 pm
Nov 2, 2007 at 9:13 pm -
Now that we have working GSSAPI authentication, I'd like to see the following done: * Deprecate krb5 authentication in 8.3. At least in documentation, possibly with a warning when loading ...
Magnus Hagander
Jul 18, 2007 at 10:40 am
Jul 19, 2007 at 12:02 pm -
Why is stats_block_level = off by default? Is there a measurable cost to enabling this? We already have stats_row_level = on, so presumably the overhead of setting stats_block_level to on cannot be ...
Simon Riggs
Jul 26, 2007 at 6:03 pm
Aug 1, 2007 at 7:49 pm -
Hello I was little bit surprised. Is any reason for it? Today I got: (1) pgbench -c 30 -t 100 (2) pgbench -c 60 -t 100 (3) pgbench -c 30 -t 200 (4) pgbench -c 60 -t 200 autovacuum on linux (fedora 7, ...
Pavel Stehule
Jul 21, 2007 at 3:40 pm
Jul 24, 2007 at 4:55 pm -
The following command sequence appears to lock up the database system: BEGIN; LOCK pg_authid; PREPARE TRANSACTION 'foo'; \q After that you can't connect anymore, even in single-user mode. The only ...
Peter Eisentraut
Jul 10, 2007 at 1:15 pm
Jul 12, 2007 at 7:41 pm -
I attach In-Place upgrade project concept. Any technical details about implementation of each part will be sent later (after concept acceptance). Please, let me know your comments. thanks Zdenek
Zdenek Kotala
Jul 3, 2007 at 9:22 am
Jul 4, 2007 at 8:38 am -
From http://developer.postgresql.org/pgdocs/postgres/routine-vacuuming.html : "Recommended practice for most sites is to schedule a database-wide VACUUM once a day at a low-usage time of day, ...
Jim C. Nasby
Jul 2, 2007 at 9:52 pm
Jul 7, 2007 at 11:18 pm -
Hello if I understand well, there isn't any difference between local and global temp tables in postgresql. I have question. Is correct implementation of global temp in Oracle or Firebird, where ...
Pavel Stehule
Jul 1, 2007 at 9:31 pm
Jul 18, 2007 at 12:18 am -
I ran some DBT-2 tests to compare different bgwriter strategies: http://community.enterprisedb.com/bgwriter/ imola-336 was run with minimal bgwriter settings, so that most writes are done by ...
Heikki Linnakangas
Jul 5, 2007 at 8:52 pm
Jul 11, 2007 at 3:16 pm -
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lionfish&dt=2007-07-24%2005:30:13 any ideas ? Stefan
Stefan Kaltenbrunner
Jul 24, 2007 at 2:51 pm
Jul 25, 2007 at 9:51 pm -
Jignesh Shah's scalability testing on Solaris has revealed further tuning opportunities surrounding the start and end of a transaction. Tuning that should be especially important since async commit ...
Simon Riggs
Jul 30, 2007 at 10:23 pm
Mar 26, 2008 at 1:51 am -
I have just discovered that the recently implemented pipe chunking protocol is broken on Windows. This is because the pipes are operating in text mode and doing LF- CR-LF translation, so the number ...
Andrew Dunstan
Jul 29, 2007 at 12:46 pm
Jul 30, 2007 at 11:59 am -
Howdy, I'm working on a patch to extend the stats collector to handle stored procedure statistics (call counts, duration etc). The goal is to make this information visible via pg_stat ...
Martin Pihlak
Jul 13, 2007 at 11:18 am
May 14, 2008 at 2:22 pm -
Hi I'm currently working on correctly flushing the catalog/relation/sgmr caches on a readonly PITR slave during recovery. These are the things that currently cause me headache. 1) It seems that the ...
Florian G. Pflug
Jul 22, 2007 at 5:04 pm
Jul 23, 2007 at 5:36 pm -
I was experimenting with what happened if I made the pg_log directory unwritable, and found out that this comes out on stderr:
Tom Lane
Jul 16, 2007 at 1:18 am
Jul 19, 2007 at 7:16 pm -
David Strong presented some excellent results of his SMP scalability testing at Ottawa in May. http://www.pgcon.org/2007/schedule/events/16.en.html There are some easy things we can do to take ...
Simon Riggs
Jul 16, 2007 at 12:23 pm
Mar 24, 2008 at 5:31 pm -
A quick status update on the SSPI authentication part of the GSSAPI project. I have libpq SSPI working now, with a few hardcoded things still in there to be fixed. But it means that I can connect to ...
Magnus Hagander
Jul 16, 2007 at 5:50 pm
Jul 18, 2007 at 5:25 pm -
To test some changes in Slony I needed a \usleep [microseconds|:variable] in pgbench's scripting language to be able to have hundreds of concurrent running transactions without totally swamping the ...
Jan Wieck
Jul 5, 2007 at 7:13 pm
Jul 7, 2007 at 10:08 pm -
All, I'm working on cleaning up postgresql.conf and pg_settings for the release. Attached is a sample WIP. It's not in patch form because I'm not done yet; I've just been editing postgresql.conf and ...
Josh Berkus
Jul 2, 2007 at 11:03 am
Sep 26, 2007 at 8:34 am -
I have just absorbed the significance of some code that has been in plpgsql since day one, but has never been documented anyplace. It seems that if you attach a "label" to a statement block in a ...
Tom Lane
Jul 14, 2007 at 9:13 pm
Mar 11, 2008 at 10:32 pm -
It seems like we see a remarkable number of occurrences of $subject. For instance, right now we have these members failing on various branches: echidna No space left on device asp No space left on ...
Tom Lane
Jul 4, 2007 at 2:36 am
Jul 24, 2007 at 12:04 am -
while looking at some other stuff I noticed that we have the following compiler warning on OpenBSD 4.0/amd64 with the OS supplied compiler: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline ...
Stefan Kaltenbrunner
Jul 11, 2007 at 3:42 pm
Jul 17, 2007 at 7:56 am -
Are we leaking memory in vac_update_relstats ? /* Fetch a copy of the tuple to scribble on */ ctup = SearchSysCacheCopy(RELOID, ObjectIdGetDatum(relid), 0, 0, 0); This copy is not subsequently freed ...
Pavan Deolasee
Jul 20, 2007 at 9:23 am
Jul 21, 2007 at 8:06 am -
I have been thinking about where we are in the release process for 8.3. I know we hoped for a July beta, but soon after the 8.3 feature freeze it was clear that we weren't going to make that date. I ...
Bruce Momjian
Jul 19, 2007 at 6:18 pm
Jul 20, 2007 at 8:03 am -
Stefan reported me that prcrypto regression test fails on solaris 10 with openssl support. I investigated this problem and the result is that Solaris 10 delivers only support for short keys up to ...
Zdenek Kotala
Jul 24, 2007 at 11:29 am
Sep 26, 2007 at 2:23 pm -
Just wanted to record a quick idea in case its useful in the future. VACUUM reads all blocks in sequence and waits on each one to acquire a cleanup lock. If VACUUM is running with vacuum_delay ...
Simon Riggs
Jul 26, 2007 at 4:08 pm
Jul 31, 2007 at 3:44 pm -
The MAXIMUM_ALIGNOF value is set to 8 bytes in a Windows- 32-bit environment. I have very little knowledge about Windows, but at the face of it, this looks strange. Any idea why is this required ? ...
Pavan Deolasee
Jul 20, 2007 at 12:54 pm
Jul 23, 2007 at 4:43 pm -
I came across a boat load of these the other day. Seems fairly naff that we substitute variables blindly. Seems like we could be slightly more friendly without too much bother: at least only ...
Simon Riggs
Jul 11, 2007 at 9:59 pm
Jul 12, 2007 at 6:15 pm -
[redirecting to -hackers] Stephen Frost wrote: Not very, no :-) This looks too clever by half, to me. Someone facing the problem you are facing would have to dig quite deep to find the solution ...
Andrew Dunstan
Jul 27, 2007 at 4:03 pm
Mar 11, 2008 at 10:49 pm -
People, I'd like to suggest you guys to implement a new feature. Actually is an alias for a existent feature. Unstead of having to type all the insert syntax, using ("column") names, you could do the ...
Rafael Azevedo
Jul 31, 2007 at 7:40 pm
Aug 1, 2007 at 3:14 am -
I just noticed that when the BY option was added to plpgsql FOR loops, no real error checking was done. If you specify a zero step value, you'll have an infinite loop. If you specify a negative ...
Tom Lane
Jul 14, 2007 at 6:27 pm
Jul 17, 2007 at 1:27 pm -
Incidentally I found this paper in ACM SIGMETRICS 1992 covering more or less precisely the same algorithm we're using for our clock sweep. I haven't quite digested it yet myself so I'm not sure what ...
Gregory Stark
Jul 3, 2007 at 7:20 pm
Jul 4, 2007 at 10:46 pm -
While poking at the vacuum-launcher issue currently under discussion, I got annoyed again at the behavior we've known for a long while that on some platforms pg_usleep() won't be interrupted by ...
Tom Lane
Jul 1, 2007 at 4:11 pm
Aug 26, 2008 at 8:29 pm -
I've been debugging some really weird crashes in libpq on win32, and I think I've finally found the reason for the heap corruption that shows up in msvc debug mode. When run in debug mode, the ...
Magnus Hagander
Jul 23, 2007 at 1:36 pm
Jul 23, 2007 at 5:30 pm -
Somewhere along the way we seem to have made the syslogger's shutdown message go to stderr, even if we have redirected it: [andrew@constanza inst.test.5703]$ bin/pg_ctl -D data/ -w stop waiting for ...
Andrew Dunstan
Jul 22, 2007 at 11:22 pm
Jul 23, 2007 at 3:15 pm -
Hi! I'm trying to write an autoconf macro to figure out if the function krb5_free_unparsed_name exists (because it exists in MIT but not Heimdal), to fix a rather nasty bug in our Kerberos ...
Magnus Hagander
Jul 11, 2007 at 4:18 pm
Jul 12, 2007 at 2:14 pm -
I have applied the latest version of the GSSAPI patch with only minor further fixes. I'm still working on the documentation part and will make a separate commit with that as soon as I can. I'd ...
Magnus Hagander
Jul 10, 2007 at 1:17 pm
Jul 10, 2007 at 10:38 pm -
Most of them would be, but the one you actually needed here (the update of pg_database.datfrozenxid) is treated as a non-WAL-logged action in pre-8.2 releases :-( ... so you had to have a checkpoint ...
Tom Lane
Jul 8, 2007 at 4:11 pm
Jul 9, 2007 at 1:11 am -
To review, Pavel Stehule submitted a proposal and patch to add support for "table functions" a few months back: http://archives.postgresql.org/pgsql-hackers/2007-02/msg00318.php ...
Neil Conway
Jul 17, 2007 at 7:41 am
Sep 27, 2007 at 5:42 am -
I've done some further analysis of bitmap indexes in preparation for a comparison with clustered indexes (GIT), to help understand the use cases for each. Overall, my conclusion is that BMI and GIT ...
Simon Riggs
Jul 23, 2007 at 9:01 pm
Sep 26, 2007 at 8:36 am -
Moving to -hackers. I suspect that this is just a matter of no one scratching the itch. I suspect a patch would be accepted, or you could possibly put something on pgFoundry. I'd set it up so that ...
Decibel!
Jul 31, 2007 at 5:17 am
Sep 14, 2007 at 1:23 pm -
Hi all, I am using version 8.2.4 of the source and compiled it with both OPTIMIZER_DEBUG and EXEC_EVALDEBUG enabled to take a look at how quals are evaluated by the executor. However, when I issue a ...
Peter Trautmeier
Jul 24, 2007 at 9:36 am
Jul 25, 2007 at 3:09 pm -
has anyone looked at burstsort https://sourceforge.net/projects/burstsort they claim that "Copy-Burstsort is a sorting algorithm for strings that is cache-efficient. Burstsort and its variants are ...
Hannu Krosing
Jul 13, 2007 at 1:51 pm
Jul 15, 2007 at 1:16 am -
According to http://developer.postgresql.org/index.php/Feature_Matrix, 8.2 has non-blocking CREATE INDEX, which is news to me. Is it correct? ...
Jim C. Nasby
Jul 13, 2007 at 8:39 pm
Jul 14, 2007 at 4:23 pm -
Gregory Stark
Jul 4, 2007 at 3:30 pm
Jul 11, 2007 at 4:15 pm -
Hi, I noticed in 8.3 there are chances where we can avoid WAL logging. For example, 8.3's pgbench was modified to use TRUNCATE right before COPY. Is there any documentation which describes that kind ...
Tatsuo Ishii
Jul 24, 2007 at 4:05 am
Jul 24, 2007 at 7:15 pm -
Ah, I see it. Your PHP script is sending all 30000 INSERT commands to the backend *in a single PQexec*, ie, one 37MB command string. psql won't do that, it splits the input at semicolons. ...
Tom Lane
Jul 20, 2007 at 8:05 pm
Jul 23, 2007 at 8:38 pm -
Looking around the lc_messages stuff a bit, I notice it's set to superuser-only. I do use ALTER USER joe SET lc_messages='sv_SE' now and then to change the language for a user. And I see it's also ...
Magnus Hagander
Jul 23, 2007 at 3:05 pm
Jul 23, 2007 at 3:22 pm -
I just came across yet another place where MingW isn't compatible with the windows api. Specifically, their libsecur32.a file lacks at least one function that is needed to implement SSPI ...
Magnus Hagander
Jul 23, 2007 at 9:09 am
Jul 23, 2007 at 2:34 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 119 |
posts | 1,007 |
users | 109 |
website | postgresql.org... |
irc | #postgresql |
109 users for July 2007
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)