Search Discussions
-
153
SCMS question
Are there any plans to move to another SCMS in the future? I am curious, I guess. wt -- Warren Turkal (w00t)Warren Turkal
Feb 22, 2007 at 4:22 am
Mar 27, 2007 at 1:46 am -
Proposal: Implement a new option for COMMIT, for enhancing performance, providing a MySQL-like trade-off between performance and robustness for *only* those that want it. COMMIT NOWAIT This form of ...
Simon Riggs
Feb 26, 2007 at 10:59 pm
Mar 5, 2007 at 8:56 pm -
After staring at my previous notes for autovac scheduling, it has become clear that this basics of it is not really going to work as specified. So here is a more realistic plan: First, we introduce ...
Alvaro Herrera
Feb 16, 2007 at 9:01 pm
Feb 28, 2007 at 1:52 am -
Inspired by this thread [1], and in particular by the idea of storing three numbers (permanent ID, on-disk storage position, display position) for each column, I spent a little time messing around ...
Phil Currier
Feb 20, 2007 at 9:07 pm
Apr 30, 2008 at 2:06 pm -
Heap Only Tuples ("HOT") is a simplification of earlier proposals for improving the way the server handles frequent updates, based upon what's been learned and feedback received. Heap Only Tuples ...
Simon Riggs
Feb 7, 2007 at 5:41 pm
Feb 22, 2007 at 6:06 pm -
Hi list, Here's a proposal of this idea which stole a good part of my night. I'll present first the idea, then 2 use cases where to read some rational and few details. Please note I won't be able to ...
Dimitri Fontaine
Feb 19, 2007 at 10:54 am
Mar 28, 2007 at 1:33 pm -
Gregory Stark
Feb 9, 2007 at 3:31 am
Feb 15, 2007 at 4:28 pm -
PostgreSQL, already a mature database, needs to have more options for recovery as compared to proprietary databases. I just worked with Oracle's FlashBack query feature in Oracle 9i and FlashBack ...
RPK
Feb 17, 2007 at 2:49 pm
Mar 1, 2007 at 5:48 pm -
Hello PostgreSQL Hackers, I have made a modification of PostgreSQL which accelerates INSERT/UPDATE using UPS. The name of the software is "Sigres", and the philosophy is considering a battery ...
Hideyuki Kawashima
Feb 11, 2007 at 1:34 am
Apr 3, 2007 at 4:09 am -
Hello hackers, I was starting to think about next SOC and the project for it. And for a long time I wanted to implement the user quotas in PG. So, I'll try to explain my understanding of the ...
Sergey E. Koposov
Feb 28, 2007 at 4:27 pm
Mar 2, 2007 at 6:59 pm -
Column storage position is the subject of many long threads in recent times. Solutions proposed for this have been both fairly complex and long enough that nothing seems likely to happen for 8.3. If ...
Simon Riggs
Feb 22, 2007 at 10:45 pm
Feb 26, 2007 at 8:47 pm -
Hi We are developing a new feature for vacuum, here is a brief overview about it. Introduction ------------ A) What is it? This feature enables vacuum has resumable capability. Vacuum can remembers ...
Galy Lee
Feb 26, 2007 at 9:22 am
Mar 1, 2007 at 3:11 pm -
This is the second proposal for Dead Space Map (DSM). Here is the previous discussion: http://archives.postgresql.org/pgsql-hackers/2006-12/msg01188.php I'll post the next version of the Dead Space ...
ITAGAKI Takahiro
Feb 27, 2007 at 3:08 am
Mar 7, 2007 at 4:35 am -
Regarding the advisory on possibly insecure security definer functions that I just sent out (by overriding the search path you can make the function do whatever you want with the privileges of the ...
Peter Eisentraut
Feb 13, 2007 at 11:52 pm
Aug 10, 2007 at 7:07 pm -
Hi I plan to submit a proposal for implementing support for read-only queries during wal replay as a "Google Summer of Code 2007" project. I've been browsing the postgres source-code for the last few ...
Florian G. Pflug
Feb 23, 2007 at 4:35 pm
Feb 28, 2007 at 8:59 pm -
I have found some interesting results from my tests with the Synchronized Scan patch I'm working on. The two benefits that I hope to achieve with the patch are: (1) Better caching behavior with ...
Jeff Davis
Feb 27, 2007 at 11:14 pm
Mar 14, 2007 at 9:22 am -
The next Summer of Code is just around the corner. Last year, we had 46 submissions and seven we accepted. Out of the SoC we got two ongoing contributors, several good patches, two code refactors and ...
Josh Berkus
Feb 26, 2007 at 9:11 pm
Feb 27, 2007 at 6:26 pm -
FYI, I am not going to be comfortable accepting a final patch that contains this email signature: This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 003 693 481. It is ...
Bruce Momjian
Feb 27, 2007 at 10:49 pm
Mar 6, 2007 at 2:59 am -
I'm reading the SQL Standard and I can't find anywhere that says that we need to place SHARE locks on rows in the referenced table. RI_FKey_check() clearly does that. What I do see is this: "4. For ...
Simon Riggs
Feb 2, 2007 at 9:54 am
Feb 6, 2007 at 10:14 am -
As per numerous reports this morning, PG 8.2.2 and 8.1.7 both fail on fairly simple scenarios involving typmod-bearing columns (varchar, numeric, etc) with check constraints or functional indexes ...
Tom Lane
Feb 6, 2007 at 6:27 pm
Mar 17, 2007 at 12:46 am -
Simon Riggs started this thread with the question: . . . Why do we need a SHARE lock at all, on the **referenc(ed)** table? . . . The root problem addressed by this thread seems to be that using ...
Marc Munro
Feb 6, 2007 at 9:35 pm
Feb 19, 2007 at 8:42 pm -
A few months ago at http://archives.postgresql.org/pgsql-general/2006-11/msg01770.php the notion of adding an "anyelement2" pseudotype was discussed. The context was a compatibility SQL function to ...
Matt Miller
Feb 14, 2007 at 6:42 am
Feb 19, 2007 at 9:51 am -
Hallo to all, Just wondering after reading so many mails from Hackers List.(its 2.15 AM now!!) Is there anybody working on something to create a DB from a) The TODO list ...
Deductive
Feb 25, 2007 at 2:28 am
Mar 1, 2007 at 12:20 pm -
I've looked into cutting back on the implicit casts to text, which exposed the following little gem. The expressions 'abc' || 34 34 || 'abc' would no longer work, with the following error message: ...
Peter Eisentraut
Feb 27, 2007 at 6:03 pm
Jun 6, 2007 at 9:04 pm -
Hello, 5 weeks to feature freeze folks. Please provide updates including if you think you will have a patch submitted before feature freeze. Be realistic, if you can't make it -- say so. Alvaro ...
Joshua D. Drake
Feb 23, 2007 at 9:24 pm
Feb 28, 2007 at 5:42 am -
[ time to move this thread to -hackers ] Bruce Momjian <bruce@momjian.us writes: Packed doesn't seem to have quite the right connotation either --- it sounds like it means there are two separable ...
Tom Lane
Feb 8, 2007 at 8:00 pm
Feb 9, 2007 at 2:37 pm -
I am wanting to write some new C functions which leverage postgresql's existing regexp code in an extension module. I notice that the functions RE_compile_and_cache and RE_compile_and_execute in ...
Jeremy Drake
Feb 1, 2007 at 9:20 pm
Feb 7, 2007 at 8:37 pm -
This is a WIP patch based on the recent posting by Simon and discussions thereafter. We are trying to do one piece at a time and intention is to post the work ASAP so that we could get early and ...
Pavan Deolasee
Feb 14, 2007 at 10:04 am
Feb 20, 2007 at 7:22 am -
What is the practical purpose of the notices emitted by DROP SOMETHING IF EXISTS when the object in fact does not exist? -- Peter Eisentraut http://developer.postgresql.org/~petere/
Peter Eisentraut
Feb 7, 2007 at 1:13 pm
Feb 19, 2007 at 4:53 pm -
Temporal Extensions for PostgreSQL by: Warren Turkal I would like to see a comprehensive solution to time varying tables (or temporal) in PostgreSQL. I specifically want to see suuport for valid-time ...
Warren Turkal
Feb 10, 2007 at 7:20 am
Feb 19, 2007 at 3:11 pm -
I'm still getting random failures from some of my buildfarm members which is starting to get a bit irritating and annoying :-( some recent failures: ...
Stefan Kaltenbrunner
Feb 6, 2007 at 8:27 pm
Feb 7, 2007 at 11:15 pm -
Hi all, I found the need to determine the type of a datum at runtime. David Fetter and Elein have already written about this: http://www.varlena.com/varlena/GeneralBits/117.php (My scenario is ...
Kate F
Feb 2, 2007 at 1:17 am
Feb 2, 2007 at 5:35 pm -
Almost a year ago, we talked about the problem that referential integrity should be selecting comparison operators on the basis of b-tree index opclasses, instead of assuming that the appropriate ...
Tom Lane
Feb 10, 2007 at 3:35 am
Feb 14, 2007 at 2:17 am -
I'm observing high CPU usage (95%) of a 2.6GHz opteron by the stats collector on an 8.2.3 box investigation has lead me to belive that the stats file is written a lot more often that once every 500ms ...
Darcy Buskermolen
Feb 27, 2007 at 9:14 pm
Mar 6, 2007 at 7:15 am -
I'm really curious to know how people feel about the varlena patch. In particular I know these issues may elicit comment: 1) Do we really need a special case for little-endian machines? I think it ...
Gregory Stark
Feb 27, 2007 at 1:46 pm
Mar 1, 2007 at 10:54 am -
Reposting - looks like the message did not get through in the first attempt. My apologies if multiple copies are received. This is the next version of the HOT WIP patch. Since the last patch that I ...
Pavan Deolasee
Feb 20, 2007 at 6:38 am
Feb 23, 2007 at 6:28 am -
I'm starting to think about the long-wanted plan invalidation mechanism. Here's a sketch --- anyone see any problems? * Create a new module, say src/backend/utils/cache/plancache.c, that we will put ...
Tom Lane
Feb 17, 2007 at 5:48 pm
Feb 21, 2007 at 10:21 pm -
I notice that this patch: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.443&r2=1.444 inserts a bunch of XML related rows in pg_proc without specifying oid. ...
Magnus Hagander
Feb 19, 2007 at 9:16 am
Feb 21, 2007 at 12:30 pm -
I tried to write a trigger using C++. This requires to include the following header-files: extern "C" { #include <postgres.h #include <executor/spi.h #include <commands/trigger.h #include <fmgr.h } ...
Jacob Rief
Feb 13, 2007 at 11:22 pm
Feb 18, 2007 at 10:47 pm -
13
XML export
The issue of XML export has been discussed a few times throughout history. Right now you've got the HTML output in psql. A few people have proposed "real" XML output formats in psql or elsewhere. I ...Peter Eisentraut
Feb 10, 2007 at 6:59 pm
Feb 11, 2007 at 2:18 pm -
Hi I'm trying to gain a better understanding of how the postgres xlog works - especially about the corner cases of wal replay. One thing that I do not understand is what CheckPoint.undo is used for. ...
Florian G. Pflug
Feb 22, 2007 at 1:26 pm
Mar 3, 2007 at 8:04 pm -
Does anyone happen to know what it is about my build environment that causes these errors? I get a similar slew of errors from each flex lexer we built including the plpgsql lexer, the ecpg lexer, ...
Gregory Stark
Feb 28, 2007 at 3:23 pm
Mar 2, 2007 at 5:30 am -
I built the "-base" version of 8.2.3 today, for installation at a company I'm helping out. The build (and later, the installation) gave me an error about a missing directory "test/regress". IIRC I ...
Jeroen T. Vermeulen
Feb 12, 2007 at 6:22 pm
Feb 13, 2007 at 7:29 pm -
Hello, I miss doc for this operator Regards Pavel Stehule Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/
Pavel Stehule
Feb 2, 2007 at 7:47 am
Feb 20, 2007 at 2:32 pm -
G'day hackers, I had some hand-wavy thoughts about some potential gains for postgres in the data archiving/warehousing area. I'm not able to do any work myself on this, and don't actually have a ...
Chris Dunlop
Feb 1, 2007 at 2:01 am
Feb 2, 2007 at 12:34 pm -
Added -hackers to CC:. I agree with you on this point. We need every information we can put in the database (database, user and so on) in a structured way. Logging statements is not the only thing to ...
Guillaume Smet
Feb 18, 2007 at 11:07 am
Feb 20, 2007 at 1:17 pm -
psql's \copy (query) with a delimiter yields a syntax error: test= \copy foo to foo.txt delimiter '|' (works) test= \copy (select * from foo) to foo.txt (works) test= \copy (select * from foo) to ...
Michael Fuhr
Feb 3, 2007 at 9:18 am
Feb 20, 2007 at 2:50 am -
Hi, configure with --enable-debug does not seem to add "-g" to CFLAGS while compiling with gcc. Guess we will need to change configure.in as below: *************** # supply -g if --enable-debug ! if ...
NikhilS
Feb 2, 2007 at 8:29 am
Feb 19, 2007 at 11:46 pm -
I've been looking into Pavan Deolasee's recent discovery that when storing a maximum-length toast tuple, heap_insert uselessly recurses to toast_insert_or_update, wasting a nontrivial number of ...
Tom Lane
Feb 2, 2007 at 8:12 pm
Feb 19, 2007 at 9:08 pm -
Aloha, I just wanted to bring up the wishlist todo items: http://developer.postgresql.org/index.php/Todo:WishlistFor83 All items have a name behind them aside from "Better handling of partitioning". ...
Lukas Kahwe Smith
Feb 11, 2007 at 11:36 am
Feb 19, 2007 at 6:17 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 170 |
posts | 1,916 |
users | 173 |
website | postgresql.org... |
irc | #postgresql |
173 users for February 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)