Search Discussions
-
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 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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, 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 ...
Moises
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 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 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 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 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 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 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. 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 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 ...
Korry
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 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 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 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 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 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 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 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. 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. 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 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 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 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 Liu
Jul 24, 2006 at 8:20 am
Jul 24, 2006 at 4:06 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 197 |
posts | 1,626 |
users | 149 |
website | postgresql.org... |
irc | #postgresql |
149 users for July 2006
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)