FAQ

Search Discussions

157 discussions - 1,288 posts

  • The series of patches are the proposal of Security-Enhanced PostgreSQL (SE-PostgreSQL) for the upstreamed PostgreSQL 8.4 development cycle. [1/4] sepostgresql-pgace-8.4devel-3.patch provides PGACE ...
    Kohei KaiGaiKohei KaiGai
    Mar 17, 2008 at 5:38 am
    Sep 25, 2008 at 12:05 pm
  • Hello, I was just curious what the status of the Commit Fest was? As I recall it started on the 1st but I haven't seen much. Is something holding us up? Is there something I(we/community/cmd) can do ...
    Joshua D. DrakeJoshua D. Drake
    Mar 14, 2008 at 5:19 pm
    Mar 17, 2008 at 8:29 pm
  • I am reading discussion about improving count(*) performance. I have also seen a TODO for this. Many people have suggested TRIGGER based solution to the slow count(*) problem. I looked at the ...
    Pavan DeolaseePavan Deolasee
    Mar 12, 2008 at 3:05 pm
    Jun 23, 2008 at 10:12 pm
  • Hello, O.k. this appeared easy enough for even me to do it. So I did. It seems to work but I wasn't 100% positive on "where" I put the code changes. Please take a look. Sincerely, Joshua D. Drake - ...
    Joshua D. DrakeJoshua D. Drake
    Mar 11, 2008 at 5:46 pm
    Jun 25, 2008 at 4:34 am
  • Hi, I created a page for our current commitfest: http://wiki.postgresql.org/wiki/CommitFest:March Not all patches are there yet. I only added the latest version of each patch. I'll continue after ...
    Alvaro HerreraAlvaro Herrera
    Mar 25, 2008 at 4:24 pm
    Apr 8, 2008 at 2:06 pm
  • SQL200n specifies a new qualifier on a TRUNCATE command TRUNCATE TABLE foo [ CONTINUE IDENTITY | RESTART IDENTITY ] CONTINUE IDENTITY is the default and does nothing, like now. RESTART IDENTITY will ...
    Simon RiggsSimon Riggs
    Mar 25, 2008 at 2:44 pm
    Jul 1, 2008 at 6:09 pm
  • While testing the changes I was making to Pavel's EXECUTE USING patch to ensure that parameter values were being provided to the planner, it became painfully obvious that the planner wasn't actually ...
    Tom LaneTom Lane
    Mar 31, 2008 at 11:28 pm
    May 29, 2008 at 3:33 am
  • It's not. And I personally don't think it would be a problem. But I think it'll be a lot easier to sell to those who prefer textfiles in cvs (hello bruce!) if we can. /Magnus
    Magnus HaganderMagnus Hagander
    Mar 12, 2008 at 8:25 am
    Mar 12, 2008 at 6:22 pm
  • Where are we on this? Tom thinks we don't want this. TODO has: * Prefix command-line utilities like createuser with 'pg_' http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php See for ...
    Bruce MomjianBruce Momjian
    Mar 26, 2008 at 1:21 am
    Mar 28, 2008 at 5:10 am
  • The first commitfest has been on for about a week now, but I haven't seem much festivities going on. Do we plan to drain Bruce's patch queue completely during this commitfest? Or the items on the ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 7, 2008 at 2:23 pm
    Mar 7, 2008 at 6:48 pm
  • This morning I had a postgres 8.3 install core this morning while multiple vacuum fulls were taking place. I saved the core file, would anyone be interested in dissecting it? I've otherwise had no ...
    Gavin M. RoyGavin M. Roy
    Mar 4, 2008 at 2:31 pm
    Mar 7, 2008 at 1:07 pm
  • [ moved to -hackers --- see original thread here http://archives.postgresql.org/pgsql-docs/2008-03/msg00039.php ] "Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com writes: Hmm ... on my Fedora ...
    Tom LaneTom Lane
    Mar 14, 2008 at 4:20 pm
    Mar 29, 2008 at 1:18 pm
  • Stefan Kaltenbrunner wrote: [ Discussion about making infrastructure downtime more visible to people.] [ Email moved to hackers.] This is an interesting observation that deserves to be discussed ...
    Bruce MomjianBruce Momjian
    Mar 24, 2008 at 7:09 pm
    Mar 25, 2008 at 4:52 pm
  • I've started working on revamping Free Space Map, using the approach where we store a map of heap pages on every nth heap page. What we need now is discussion on the details of how exactly it should ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 16, 2008 at 9:57 pm
    Mar 20, 2008 at 8:59 pm
  • Hi, I've finished (hopefully) the code to handle a current list of open snapshots in a transaction. I'm now wondering how to put it to good use ;-) I'm not posting it yet -- first I want to get some ...
    Alvaro HerreraAlvaro Herrera
    Mar 25, 2008 at 8:26 pm
    Mar 28, 2008 at 4:15 pm
  • Hi, I did some tests with gcc 4.3 on the branches from 7.4 to 8.3 and head. 8.3 and head don't have a problem. All others failed in the ContribCheck state. You can see the results on buildfarm member ...
    Kurt RoeckxKurt Roeckx
    Mar 20, 2008 at 9:03 pm
    Mar 26, 2008 at 6:46 pm
  • Well, yes. I meant to say, a build system that can supply the functionality of Gen_fmgrtab can surely implement this new thing. I see there is Perl being used, so it should be simple.
    Peter EisentrautPeter Eisentraut
    Mar 17, 2008 at 10:40 pm
    Mar 20, 2008 at 2:00 am
  • Bruce, you seem to have removed one of my three patches from the queue. I would actually prefer you remove the other two and put back that one. It's the one I most urgently need feedback on to ...
    Gregory StarkGregory Stark
    Mar 28, 2008 at 9:09 am
    Apr 5, 2008 at 2:26 am
  • Currently, our sort algorithm assumes that its input is unsorted. So if your data is sorted on (a) and you would like it to be sorted on (a,b) then we need to perform the full sort of (a,b). For ...
    Simon RiggsSimon Riggs
    Mar 20, 2008 at 8:33 pm
    Mar 22, 2008 at 1:00 pm
  • It's not clear how this commitfest thing is supposed to work in practice. May I suggest that: 1. When a patch author wants to have a patch reviewed in the next commitfest, he posts it to ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 7, 2008 at 2:34 pm
    Mar 8, 2008 at 8:41 am
  • Related to the concurrent discussion about selectivity estimations ... What is the reason the statistics target is limited to 1000? I've seen more than one case where increasing the statistics target ...
    Peter EisentrautPeter Eisentraut
    Mar 7, 2008 at 6:25 pm
    Mar 20, 2008 at 7:50 pm
  • Hackers, As you may have noticed (http://archives.postgresql.org/pgsql-general/2008-03/msg00470.php) we now have a wiki at wiki.postgresql.org that is replacing techdocs which unfortunately never ...
    Dave PageDave Page
    Mar 12, 2008 at 5:17 pm
    Mar 12, 2008 at 7:20 pm
  • Hi all, I was rsyncing a fresh copy of CVS repository, and suddenly, midway (around heap.c) rsync complained. When after many retries I couldn't start it, I restarted the OS. Since it is a VM running ...
    Gurjeet SinghGurjeet Singh
    Mar 26, 2008 at 1:57 pm
    Apr 7, 2008 at 5:43 pm
  • PosgreSQL hackers, Here's an initial bit of my attempt at cleaning up the the timestamp datatype. I have gone through the backend and made a couple small changes to stop using the ...
    Warren TurkalWarren Turkal
    Mar 9, 2008 at 8:42 am
    Mar 21, 2008 at 4:44 pm
  • Hi PostgreSQL! Although this year's GSoC is just starting, I thought getting in touch a bit earlier would only be of benefit. I study Computer Science in Faculty of Mathematics, Informatics and ...
    Jan UrbańskiJan Urbański
    Mar 3, 2008 at 7:45 pm
    Mar 19, 2008 at 1:44 am
  • Hi, I'm trying to write a version of the MIN aggregate for values of RECORD type. I'm somewhat stuck on getting type information about the argument out, I can determine how many attributes it's got ...
    Sam MasonSam Mason
    Mar 20, 2008 at 7:32 pm
    Apr 2, 2008 at 11:05 pm
  • Folks, Neil Conway sent me a patch that sketched out a plan to make quals visible to functions, and Korry Douglas filled in much of the rest of what you see attached here. Mistakes are all mine. :) ...
    David FetterDavid Fetter
    Mar 26, 2008 at 7:02 am
    Mar 28, 2008 at 10:17 am
  • I found autovacuum can be canceled by blocked backends even if the vacuum is for preventing XID wraparound in 8.3.0 and HEAD. Autovacuum sets PROC_VACUUM_FOR_WRAPAROUND flag just before vacuum, but ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Mar 14, 2008 at 2:06 am
    Mar 15, 2008 at 12:53 am
  • Hello, So, I embarked (yesterday) on a weekend project to add a new feature to Postgres... I use PHP with persistent connections and always have been bothered that those very small AJAX queries ...
    PFCPFC
    Mar 30, 2008 at 7:14 am
    Apr 2, 2008 at 5:08 pm
  • Hi, As an attempt at a first PostgreSQL patch, I'd like to see if I can do anything about this issue. I've read both the attached threads; ...
    Russell SmithRussell Smith
    Mar 24, 2008 at 12:09 am
    Mar 28, 2008 at 12:57 am
  • Hello,Everyone! I'm a student in China. and I'm preparing for GSocC2008 in these days. There are two questions about GSoC. 1. There's a paragraph about the Example Proposal Ideas in PostgreSQL Summer ...
    MxMx
    Mar 24, 2008 at 2:17 pm
    Mar 25, 2008 at 1:15 pm
  • I have an idea for this TODO item: * Allow administrators to safely terminate individual sessions either via an SQL function or SIGTERM Lock table corruption following SIGTERM of an individual ...
    Bruce MomjianBruce Momjian
    Mar 7, 2008 at 1:22 am
    Mar 11, 2008 at 3:04 am
  • Hi Alex, I was taking a look at this patch to add the pg_dump related changes. Just wanted to give you a heads up as this patch crashes if we run "make installcheck". Seems there is an issue ...
    NikhilSNikhilS
    Mar 31, 2008 at 8:36 am
    May 11, 2008 at 4:30 pm
  • Hi hackers, Per the above discussion, I'm looking at creating a nice API in print.c for callers wishing to build their own psql output table. Currently, if you want to build your own table you need ...
    Brendan JurdBrendan Jurd
    Mar 29, 2008 at 11:39 pm
    Apr 15, 2008 at 8:25 am
  • I would like to propose new large object client side API for 8.4. Currently we have: Oid lo_import(PGconn *conn, const char *filename); But we do not have an API which imports a large object ...
    Tatsuo IshiiTatsuo Ishii
    Mar 13, 2008 at 8:22 am
    Mar 22, 2008 at 1:56 am
  • There are several places in tuplesort.c (and perhaps elsewhere) where we explicitly work around limitations of various platforms' qsort() functions. Notably, there's this bit in ...
    Tom LaneTom Lane
    Mar 17, 2008 at 3:59 am
    Jun 23, 2008 at 8:21 pm
  • Hi all, For PG versions < 8.3 (specifically 8.2) I wanted the %r parameter to be substituted by the last restart point, just as the recovery code does in 8.3. I assumed there would be objections to ...
    Gurjeet SinghGurjeet Singh
    Mar 27, 2008 at 6:34 pm
    May 15, 2008 at 8:08 pm
  • Hello All, I would like to submit following feature request for Postgres: 1. Transparent Data Encryption: The column which needs to be stored in encrypted form can be specified through DDL. The ...
    Sanjay sharmaSanjay sharma
    Mar 30, 2008 at 6:52 pm
    Apr 17, 2008 at 12:42 pm
  • The proposed TODO item was not about doing this, it was about removing the option altogether. AFAICS it's a foot-gun and nothing else --- why do we have it? BTW, a point I had forgotten is that ...
    Tom LaneTom Lane
    Mar 26, 2008 at 4:39 pm
    Apr 13, 2008 at 4:28 am
  • Chris, et al, (commit-fest consensus discussion) * Chris Marcellino wrote: This really feels like a deal-breaker to me. My first reaction to this patch, honestly, is that it's being justified for all ...
    Stephen FrostStephen Frost
    Mar 31, 2008 at 5:05 pm
    Apr 2, 2008 at 3:50 pm
  • While working on the previously discussed refactoring of heap_page_prune, I came to the realization that its use of CacheInvalidateHeapTuple is not just a PANIC risk but simply wrong :-( The ...
    Tom LaneTom Lane
    Mar 6, 2008 at 1:23 am
    Mar 13, 2008 at 5:17 pm
  • Hackers, We need to update the SoC page: http://www.postgresql.org/developer/summerofcode ... with new ideas and projects appropriate for PostgreSQL 8.4/8.5. Please make suggestions. Thanks! --Josh
    Josh BerkusJosh Berkus
    Mar 12, 2008 at 5:20 pm
    Mar 13, 2008 at 2:01 pm
  • Does it make any sense to allow LISTEN or UNLISTEN in a prepared transaction? It's certainly not sensical for these actions to affect the backend that actually executes the COMMIT PREPARED, in the ...
    Tom LaneTom Lane
    Mar 11, 2008 at 1:42 am
    Mar 11, 2008 at 3:21 pm
  • Hello, I would like to be able to add CONSTRAINT and/or DEFAULT with out affecting old rows. Yes, it sounds strange, but... Let's say I have big table, I want to add new column, with DEFAULT and NOT ...
    Michał ZaborowskiMichał Zaborowski
    Mar 9, 2008 at 2:17 pm
    May 8, 2008 at 1:41 am
  • Hi, I'm trying to code a GiST opclass to index prefix searches (select ... from t where t.prefix @ query), now using a prefix_range datatype. This datatype is a varlena one, and storing it to disk ...
    Dimitri FontaineDimitri Fontaine
    Mar 25, 2008 at 4:12 pm
    Apr 22, 2008 at 1:15 pm
  • I'm not sure how many people noticed this -patches discussion: http://archives.postgresql.org/pgsql-patches/2008-03/msg00282.php so I'm reposting on -hackers. The conclusion I drew from that thread ...
    Tom LaneTom Lane
    Mar 24, 2008 at 4:22 pm
    Apr 2, 2008 at 11:55 pm
  • It actually has been removed from the TODO list since you saw it last. The problem with the last bullet is pretty serious. It can be illustrated with psql: $ psql -c 'set log_statement="all";select ...
    Bruce MomjianBruce Momjian
    Mar 28, 2008 at 5:23 pm
    Mar 29, 2008 at 4:20 pm
  • Hi, what's your opinion on this? I saw response only from Alvaro on the -patches list. Thanks in advance, Zoltán Böszörményi -------- Eredeti üzenet -------- Tárgy: Re: [PATCHES] 64-bit CommandIds ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Mar 10, 2008 at 4:17 pm
    Mar 21, 2008 at 2:41 pm
  • As you can see here: http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=jaguar&br=HEAD Jaguar has been failing for two days while centaur is ok. The only diff is that jaguar is compiling with ...
    OhpOhp
    Mar 30, 2008 at 5:23 pm
    Apr 9, 2008 at 9:10 pm
  • Hi, Agreed. So I think we need to implement the whole enchilada or nothing at all. We need to do the following for this: * Add logic to disallow ADD CONSTRAINT ONLY to parent of an inheritance ...
    NikhilSNikhilS
    Mar 27, 2008 at 11:21 am
    Mar 28, 2008 at 3:09 pm
Group Navigation
period‹ prev | Mar 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions157
posts1,288
users146
websitepostgresql.org...
irc#postgresql

146 users for March 2008

Tom Lane: 262 posts Bruce Momjian: 200 posts Alvaro Herrera: 72 posts Greg Stark: 57 posts Heikki Linnakangas: 41 posts Simon Riggs: 40 posts Andrew Dunstan: 33 posts Joshua D. Drake: 29 posts Zdeněk Kotala: 24 posts Peter Eisentraut: 23 posts Greg Smith: 22 posts Magnus Hagander: 22 posts Pavan Deolasee: 20 posts Brendan Jurd: 15 posts Gurjeet Singh: 15 posts Kohei KaiGai: 12 posts Kurt Roeckx: 12 posts Martijn van Oosterhout: 12 posts Josh Berkus: 11 posts Tatsuo Ishii: 11 posts
show more
Archives