FAQ

PostgreSQL > pgsql-hackers > July 2006

Search Discussions

197 discussions - 1,626 posts

  • There are roughly three weeks left until the feature freeze on August 1. If people are working on items, they should be announced before August 1, and the patches submitted by August 1. If the patch ...
    Bruce MomjianBruce Momjian
    Jul 7, 2006 at 5:13 pm
    Jul 30, 2006 at 2:18 pm
  • -----Original Message----- From: "Andrew Dunstan" <andrew@dunslane.net To: "Peter Eisentraut" <peter_e@gmx.net Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org Sent: 16/07/06 23:50 ...
    Dave PageDave Page
    Jul 16, 2006 at 11:06 pm
    Aug 2, 2006 at 6:38 pm
  • What is the state of the following items that have been previously discussed? . MERGE (at least in PK case) . multiple values clauses for INSERT . recursive WITH queries Thanks andrew
    Andrew DunstanAndrew Dunstan
    Jul 13, 2006 at 6:57 pm
    Aug 26, 2006 at 8:08 pm
  • Hi,All. The problem has occurred in my customer. poor performance with Context Switch Storm occurred with the following composition. Usually, CS is about 5000, WIPS=360. when CSStorm occurrence, CS ...
    Katsuhiko OkanoKatsuhiko Okano
    Jul 11, 2006 at 11:33 am
    Mar 13, 2008 at 8:24 am
  • It seems everyone likes the units, so here are some details of the implementation I have prepared. Memory units are kB, MB, GB. The factor is 1024. Time units are ms, s, min, h, d. I intentionally ...
    Peter EisentrautPeter Eisentraut
    Jul 25, 2006 at 9:56 pm
    Jul 28, 2006 at 5:00 pm
  • Hello, We were going to submit plPHP to core for inclusion but it is not ready yet. Namely it requires the apache SAPI which could introduce some portability issues. The other issues it has (such as ...
    Joshua D. DrakeJoshua D. Drake
    Jul 17, 2006 at 1:18 am
    Jul 25, 2006 at 4:22 pm
  • Where are we on these TODO items: o Allow point-in-time recovery to archive partially filled write-ahead logs [pitr] Currently only full WAL files are archived. This means that the most recent ...
    Bruce MomjianBruce Momjian
    Jul 25, 2006 at 2:52 pm
    Jul 31, 2006 at 11:46 pm
  • test=# create schema private; CREATE SCHEMA test=# create sequence private.seq; CREATE SEQUENCE test=# create function bump() returns bigint language sql security definer as $$ select ...
    Phil FrostPhil Frost
    Jul 5, 2006 at 6:51 pm
    Jul 28, 2006 at 8:59 pm
  • I'm fairly dissatisfied with the naming of Greg Stark's proposed new feature for creating indexes without blocking writers of the table. To my mind, "ONLINE" just doesn't convey any useful ...
    Tom LaneTom Lane
    Jul 24, 2006 at 3:14 pm
    Jul 28, 2006 at 11:41 am
  • Hi Hackers, Can we resurrect the patch proposed by Junji TERAMOTO? It removes unnecessary items before btree pages split. http://archives.postgresql.org/pgsql-patches/2006-01/msg00301.php There was a ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Jul 12, 2006 at 6:59 am
    Sep 14, 2006 at 7:49 pm
  • pg_regress now seems to break on Msys virtual locations: Example from the buildfarm: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=snake&dt=2006-07-19%2009:00:00 ================== ...
    Andrew DunstanAndrew Dunstan
    Jul 19, 2006 at 11:33 am
    Jul 29, 2006 at 10:38 pm
  • I would prefer to drop the PG_ prefixes on PG_TRACE and pg_trace.h. We know which software we're dealing with. We should probably move the probes file to a subdirectory. Anyone know a good place? ...
    Peter EisentrautPeter Eisentraut
    Jul 21, 2006 at 11:42 am
    Oct 10, 2006 at 11:14 am
  • Pursuant to a conversation this evening I would like to a suggestion: BIRT pgsql-patches should be abolished in favour of something else that accomplishes the bandwidth-reduction aspect without the ...
    Greg StarkGreg Stark
    Jul 10, 2006 at 3:01 am
    Jul 15, 2006 at 8:21 pm
  • This is a cute hack, but it does only a small part of what I think the spec says. In the first place, the SQL syntax is pretty clear that you can combine simple and multiple assignment in the same ...
    Tom LaneTom Lane
    Jul 26, 2006 at 8:59 pm
    Aug 14, 2006 at 2:06 am
  • nonInVacuumXmin seems useless ... perhaps a vestige of some earlier version of the computation? In general, it seems to me that a transaction running lazy vacuum could be ignored for every purpose ...
    Tom LaneTom Lane
    Jul 24, 2006 at 6:00 pm
    Jul 30, 2006 at 2:13 am
  • What's wrong with this picture? http://www.pgbuildfarm.org/cgi-bin/show_status.pl Notice how all the red is at the bottom of the report? That's because all the Windows machines are at the bottom, ...
    Tom LaneTom Lane
    Jul 16, 2006 at 2:29 pm
    Aug 18, 2006 at 1:11 pm
  • I am sure you worked hard on this, but I don't see the use case, nor have I heard people in the community requesting such functionality. Perhaps pgfoundry would be a better place for this. ...
    Bruce MomjianBruce Momjian
    Jul 26, 2006 at 5:35 pm
    Aug 21, 2006 at 6:10 pm
  • I just sent in the patch for online index builds to -patches. . The work to combine the two phases into a single non-transactional command is done. I'm not sure how long to wait between lock checks ...
    Greg StarkGreg Stark
    Jul 12, 2006 at 4:10 pm
    Aug 1, 2006 at 1:20 pm
  • One frequent source of confusion are the different units that the parameters in postgresql.conf use. shared_buffers is in 8 kB, work_mem is in 1 kB; bgwriter_delay is in milliseconds, ...
    Peter EisentrautPeter Eisentraut
    Jul 20, 2006 at 11:49 am
    Jul 22, 2006 at 1:13 am
  • Folks, I was looking at migrating mSQL-interface to pgFoundry, but I'm not sure there's any reason to do so. It was never finished, doesn't build, and it's not like I run across mSQL databases in the ...
    Josh BerkusJosh Berkus
    Jul 10, 2006 at 7:44 pm
    Jul 12, 2006 at 1:36 am
  • I believe Alvaro was suggesting that you should add it as an additional SQL function within contrib/pgstattuple. That'd be my advice too --- I don't see a reason to break this out as a separate ...
    Tom LaneTom Lane
    Jul 25, 2006 at 4:52 am
    Aug 23, 2006 at 7:14 am
  • Is it possible to create user-defined type with optional length in create table similar to char()/varchar()/bit()? Without modification gram.y of course... Thank you. -- Teodor Sigaev E-mail: ...
    Teodor SigaevTeodor Sigaev
    Jul 31, 2006 at 1:05 pm
    Aug 4, 2006 at 8:59 pm
  • Has anyone looked thought about what it would take to get progress bars from clients like pgadmin? (Or dare I even suggest psql:) My first thought would be a message like CancelQuery which would ...
    Gregory StarkGregory Stark
    Jul 18, 2006 at 6:36 pm
    Jul 20, 2006 at 7:55 pm
  • There has been action to clean up and remove some contrib modules, and this is good. I would like to suggest that we should try to move one or two the other way, namely right into the core proper, on ...
    Andrew DunstanAndrew Dunstan
    Jul 14, 2006 at 2:47 pm
    Jul 21, 2006 at 9:06 pm
  • Hello, While setting up a buildfarm installation for cygwin, I've uncountered the following regression failure : float8 ... FAILED ================== pgsql.3132/src/test/regress/regression.diffs *** ...
    Adrian MaierAdrian Maier
    Jul 18, 2006 at 10:46 am
    Aug 2, 2006 at 6:59 am
  • It appears that the superuser does not have connection limit enforcement. I think this should be changed. Slony in particular does not need more than N connections but does require being a super ...
    Rod TaylorRod Taylor
    Jul 31, 2006 at 12:53 pm
    Jul 31, 2006 at 7:49 pm
  • -hackers, With help from Andrew Dunstan, I'm adding the ability to do a pgbench run after all of the other tests during a buildfarm run. Andrew said I should solicit opinions as to what parameters to ...
    Bort, PaulBort, Paul
    Jul 24, 2006 at 3:53 am
    Jul 25, 2006 at 6:16 pm
  • Can any body talk me how many transactions make postgres in a second? For example Inserts, Update, delete, etc. I’m very interesting in this data, because I want to use postgres for a real time ...
    MoisesMoises
    Jul 20, 2006 at 7:55 pm
    Jul 24, 2006 at 10:04 am
  • This is seriously scary, as it seems quite possible that there are other similar cases in which we have simply silently lost functionality or performance, and none of the regression tests will expose ...
    Tom LaneTom Lane
    Jul 14, 2006 at 6:21 pm
    Jul 18, 2006 at 7:20 pm
  • Hi, I already tried to mail security@postgresql.org but my message was stalled. Version: 8.1.4 (binary for win32) OS: Windows XP SP2 I type: pg_dump -h localhost -U postgres database_name and there ...
    Thomas BleyThomas Bley
    Jul 17, 2006 at 7:29 pm
    Jul 19, 2006 at 2:46 pm
  • Should I point out that the buildfarm universally reports failure? regards, tom lane
    Tom LaneTom Lane
    Jul 26, 2006 at 3:06 am
    Aug 10, 2006 at 2:06 am
  • Can one of the Windows buildfarm owners please try building and running "make check" by hand rather than using the buildfarm script? It looks like they all stopped reporting around the same time, and ...
    Andrew DunstanAndrew Dunstan
    Jul 28, 2006 at 10:43 am
    Jul 29, 2006 at 2:50 am
  • Someone at the conference mentioned a tool that would portably and reliably report system info such as architecture. If someone has details I would like to have them, as it would help solve the ...
    Andrew DunstanAndrew Dunstan
    Jul 15, 2006 at 10:40 pm
    Jul 18, 2006 at 4:26 pm
  • I would like to start a discussion about having an extra option in PG which makes possible to bypass (or not check) whether the current user has root/administrative privileges especially (or only) ...
    Gevik BabakhaniGevik Babakhani
    Jul 25, 2006 at 10:26 am
    Jul 25, 2006 at 7:21 pm
  • Hi For my warm-standby-cluster I'm now saving the currently used wal using rsync, to avoid loosing data from a few hours (or days) ago, when there is little traffic, and thus the wal isn't rotated. ...
    Florian G. PflugFlorian G. Pflug
    Jul 14, 2006 at 3:20 pm
    Jul 27, 2006 at 1:00 pm
  • Hi, I just finished setting up a new buildfarm member (Bandicoot) running Windows 2000 Pro. Aside from the fact that it now fails with the same cyptic pg_regress error as seen on Snake, it also ...
    Dave PageDave Page
    Jul 19, 2006 at 4:18 pm
    Aug 20, 2006 at 6:45 pm
  • I'm working on a patch that implements the PL/pgSQL instrumentation stuff (i.e. the PL/pgSQL debugger) that I discussed at the Anniversary Summit and I need some opinions (this seems like a good ...
    KorryKorry
    Jul 19, 2006 at 3:59 pm
    Jul 25, 2006 at 4:46 pm
  • Sorry, i'm resending because i forgot the subject -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and ...
    Jaime CasanovaJaime Casanova
    Jul 17, 2006 at 5:25 am
    Jul 19, 2006 at 3:04 pm
  • Hi, I use the cube datatype a fair bit, and one thing I have always wanted is the ability to do this: pg=# select cube_from_arrays('{1,2,3}'::float[], '{3,5,6}'::float[]); cube_from_arrays ...
    Joshua ReichJoshua Reich
    Jul 17, 2006 at 5:49 pm
    Jul 18, 2006 at 5:43 pm
  • Bandicoot is currently failing on HEAD with the following error shown in a message box during make check: --------------------------- postgres.exe - Entry Point Not Found --------------------------- ...
    Dave PageDave Page
    Jul 21, 2006 at 9:40 am
    Aug 21, 2006 at 7:40 pm
  • This seems pretty useless, as it will be many years before any app that actually tries to deal with back server versions could rely on the variable existing. The correct solution is for client-side ...
    Tom LaneTom Lane
    Jul 30, 2006 at 1:44 am
    Aug 12, 2006 at 11:08 am
  • Ouch. That's a bit nasty. You can't just apply a postponed split at checkpoint time, because the WAL record could easily be somewhere after the checkpoint, leading to duplicate insertions. Right ...
    Tom LaneTom Lane
    Jul 16, 2006 at 2:52 pm
    Aug 9, 2006 at 11:48 am
  • It occurs to me that this kind of thing is something dtrace could help with. It might even be able to do something clever like "time between consecutive CHECK_FOR_INTERRUPT calls grouped by the ...
    Greg StarkGreg Stark
    Jul 12, 2006 at 4:44 am
    Jul 29, 2006 at 5:15 pm
  • Folks, For the code sprint, I'm starting off by removing the projects from contrib which need to be removed by still have some usefulness. I'm not exactly sure what to do with adddepends, though. It ...
    Josh BerkusJosh Berkus
    Jul 10, 2006 at 3:22 pm
    Jul 11, 2006 at 1:42 am
  • Is there a difference in PostgreSQL performance between these two different strategies: if(!exec("update foo set bar='blahblah' where name = 'xx'")) exec("insert into foo(name, bar) ...
    Mark L. WoodwardMark L. Woodward
    Jul 3, 2006 at 1:09 pm
    Jul 5, 2006 at 3:52 pm
  • Hello Hackers, I see the very strange behaviour with the following set of queries: wsdb=# select na,nb, na::double precision as da, nb::double precision as db from ( select random()::numeric as ...
    Sergey E. KoposovSergey E. Koposov
    Jul 30, 2006 at 6:34 pm
    Sep 3, 2006 at 3:49 am
  • The latest buildfarm report from trout, http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=trout&dt=2006-07-16%2014:36:19 shows a failure mode that we've seen recently on snake, but not for a long ...
    Tom LaneTom Lane
    Jul 16, 2006 at 4:24 pm
    Jul 29, 2006 at 8:16 pm
  • So why don't you use the fixed version of VS? regards, tom lane
    Tom LaneTom Lane
    Jul 25, 2006 at 4:19 pm
    Jul 27, 2006 at 12:56 am
  • I want Veil (http://pgfoundry.org/projects/veil/) to be able to read configuration details from a configuration file. Rather than implement my own config file parser, I'd like to be able to re-use ...
    Marc MunroMarc Munro
    Jul 24, 2006 at 5:31 pm
    Jul 25, 2006 at 2:12 am
  • Updateable cursors are used as follows: begin; declare foo cursor for select * from bar for update; fetch foo; update bar set abc='def' where current of foo; fetch foo; delete from bar where current ...
    Golden LiuGolden Liu
    Jul 24, 2006 at 8:20 am
    Jul 24, 2006 at 4:06 pm
Jul 2006
1234
Group Navigation
period‹ prev | Jul 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions197
posts1,626
users149
websitepostgresql.org...
irc#postgresql

149 users for July 2006

Tom Lane: 294 posts Andrew Dunstan: 103 posts Bruce Momjian: 91 posts Peter Eisentraut: 73 posts Joshua D. Drake: 61 posts Marc G. Fournier: 47 posts Martijn van Oosterhout: 47 posts Hannu Krosing: 46 posts Jim Nasby: 45 posts Álvaro Herrera: 41 posts Greg Stark: 40 posts Josh Berkus: 38 posts Dave Page: 27 posts Simon Riggs: 27 posts Thomas Hallgren: 25 posts Jonah H. Harris: 23 posts Bort, Paul: 18 posts Joe Conway: 17 posts Phil Frost: 17 posts Csaba Nagy: 16 posts
show more
Archives