FAQ

PostgreSQL > pgsql-hackers > July 2007

Search Discussions

119 discussions - 1,007 posts

  • 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 KaltenbrunnerStefan 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. RoyGavin 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 HaganderMagnus 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 RiggsSimon 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 StehulePavel 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 EisentrautPeter 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 KotalaZdenek 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. NasbyJim 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 StehulePavel 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 LinnakangasHeikki 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 KaltenbrunnerStefan 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 RiggsSimon 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 DunstanAndrew 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 PihlakMartin 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. PflugFlorian 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 LaneTom 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 RiggsSimon 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 HaganderMagnus 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 WieckJan 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 BerkusJosh 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 LaneTom 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 LaneTom 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 KaltenbrunnerStefan 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 DeolaseePavan 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 MomjianBruce 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 KotalaZdenek 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 RiggsSimon 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 DeolaseePavan 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 RiggsSimon 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 DunstanAndrew 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 AzevedoRafael 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 LaneTom 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 StarkGregory 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 LaneTom 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 HaganderMagnus 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 DunstanAndrew 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 HaganderMagnus 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 HaganderMagnus 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 LaneTom 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 ConwayNeil 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 RiggsSimon 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!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 TrautmeierPeter 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 KrosingHannu 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. NasbyJim C. Nasby
    Jul 13, 2007 at 8:39 pm
    Jul 14, 2007 at 4:23 pm
  • Gregory StarkGregory 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 IshiiTatsuo 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 LaneTom 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 HaganderMagnus 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 HaganderMagnus Hagander
    Jul 23, 2007 at 9:09 am
    Jul 23, 2007 at 2:34 pm
Jul 2007
123
Group Navigation
period‹ prev | Jul 2007 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions119
posts1,007
users109
websitepostgresql.org...
irc#postgresql

109 users for July 2007

Tom Lane: 213 posts Gregory Stark: 61 posts Magnus Hagander: 60 posts Bruce Momjian: 55 posts Heikki Linnakangas: 48 posts Simon Riggs: 46 posts Andrew Dunstan: 44 posts Alvaro Herrera: 43 posts Stefan Kaltenbrunner: 31 posts Stephen Frost: 28 posts Greg Smith: 23 posts Joshua D. Drake: 23 posts Zdenek Kotala: 23 posts Jim Nasby: 21 posts Oleg Bartunov: 17 posts Florian G. Pflug: 16 posts Pavel Stehule: 16 posts Dave Page: 13 posts Peter Eisentraut: 13 posts Martijn van Oosterhout: 9 posts
show more
Archives