FAQ

PostgreSQL > pgsql-hackers > February 2007

Search Discussions

170 discussions - 1,916 posts

  • Are there any plans to move to another SCMS in the future? I am curious, I guess. wt -- Warren Turkal (w00t)
    Warren TurkalWarren 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 RiggsSimon 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 HerreraAlvaro 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 CurrierPhil 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 RiggsSimon 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 FontaineDimitri Fontaine
    Feb 19, 2007 at 10:54 am
    Mar 28, 2007 at 1:33 pm
  • Gregory StarkGregory 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 ...
    RPKRPK
    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 KawashimaHideyuki 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. KoposovSergey 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 RiggsSimon 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 LeeGaly 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 TakahiroITAGAKI 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 EisentrautPeter 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. PflugFlorian 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 DavisJeff 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 BerkusJosh 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 MomjianBruce 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 RiggsSimon 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 LaneTom 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 MunroMarc 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 MillerMatt 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 ...
    DeductiveDeductive
    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 EisentrautPeter 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. DrakeJoshua 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 LaneTom 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 DrakeJeremy 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 DeolaseePavan 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 EisentrautPeter 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 TurkalWarren 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 KaltenbrunnerStefan 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 FKate 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 LaneTom 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 BuskermolenDarcy 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 StarkGregory 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 DeolaseePavan 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 LaneTom 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 HaganderMagnus 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 RiefJacob Rief
    Feb 13, 2007 at 11:22 pm
    Feb 18, 2007 at 10:47 pm
  • 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 EisentrautPeter 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. PflugFlorian 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 StarkGregory 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. VermeulenJeroen 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 StehulePavel 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 DunlopChris 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 SmetGuillaume 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 FuhrMichael 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 ...
    NikhilSNikhilS
    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 LaneTom 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 SmithLukas Kahwe Smith
    Feb 11, 2007 at 11:36 am
    Feb 19, 2007 at 6:17 pm
Feb 2007
1234
Group Navigation
period‹ prev | Feb 2007 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions170
posts1,916
users173
websitepostgresql.org...
irc#postgresql

173 users for February 2007

Tom Lane: 268 posts Bruce Momjian: 177 posts Andrew Dunstan: 84 posts Simon Riggs: 82 posts Joshua D. Drake: 80 posts Alvaro Herrera: 75 posts Gregory Stark: 66 posts Peter Eisentraut: 64 posts Jim Nasby: 48 posts Warren Turkal: 44 posts Magnus Hagander: 41 posts Heikki Linnakangas: 39 posts Florian G. Pflug: 36 posts Andreas Zeugswetter: 34 posts Pavel Stehule: 29 posts Pavan Deolasee: 26 posts Jan Wieck: 25 posts Jonah H. Harris: 24 posts Martijn van Oosterhout: 24 posts Markus Schiltknecht: 22 posts
show more
Archives