Search Discussions

153 discussions - 1,423 posts

  • Hello, What is the consideration here? I read the thread and it appears that OpenSSL is not compatible with GPL? But we don't care about that right? The OpenSSL looks pretty BSDish to me, expect the ...
    Joshua D. DrakeJoshua D. Drake
    Dec 28, 2006 at 5:57 pm
    Jan 3, 2007 at 3:17 pm
  • This is a proposal for load distributed checkpoint. (It is presented on postgresql anniversary summit in last summer.) We offen encounters performance gap during checkpoint. The reason is write ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Dec 7, 2006 at 6:33 am
    Feb 27, 2007 at 8:08 am
  • Hello, A reasonable simple feature we were thinking about sponsoring was an addition to psql. Currently if you perform a \s within psql it gives you the query buffer. My suggestion is that \s give us ...
    Joshua D. DrakeJoshua D. Drake
    Dec 5, 2006 at 8:24 pm
    Feb 5, 2007 at 5:20 pm
  • Is there any special reason why I can't use "Mb" and "Gb" and such for effective_cache_size, the way I can for say shared_buffers? //Magnus
    Magnus HaganderMagnus Hagander
    Dec 18, 2006 at 8:45 pm
    Jan 4, 2007 at 12:51 am
  • If you would like to be able to index enum columns, or even GROUP BY one, you need those; whether the ordering is arbitrary or not is irrelevant. This is a fair point --- it'd be better if the ...
    Tom LaneTom Lane
    Dec 19, 2006 at 8:23 am
    Feb 2, 2007 at 5:44 am
  • I have written an article about the complexities of companies contributing to open source projects: http://momjian.us/main/writings/pgsql/company_contributions/ If you have any suggestions, please ...
    Bruce MomjianBruce Momjian
    Dec 19, 2006 at 5:12 pm
    Dec 22, 2006 at 10:46 pm
  • Now that 8.3 is open, I was considering a revival of this old patch: http://archives.postgresql.org/pgsql-hackers/2005-02/msg00832.php I could probably clean it up with a little help from someone on ...
    Jeff DavisJeff Davis
    Dec 4, 2006 at 7:08 pm
    Dec 8, 2006 at 6:59 am
  • Hi, pg_restore faied by the following operations on Windows XP. $ createdb test $ pgbench -i -s 1000 test $ pg_dump -Fc test out $ createdb restore $ pg_restore -d restore out pg_restore: [custom ...
    Yoshiyuki AsabaYoshiyuki Asaba
    Dec 14, 2006 at 11:44 am
    Feb 19, 2007 at 3:07 pm
  • After further thought about the mergejoinable-operators issue and some other longstanding planner problems, I have a modest proposal to make: we should invent the notion of "operator class groups", ...
    Tom LaneTom Lane
    Dec 13, 2006 at 9:27 pm
    Jan 3, 2007 at 7:17 pm
  • Hello, I ran a simple test... I ran defrag on my drives. Then I initialized pgbench with a -s 1000. 11% fragmentation. I dropped the bench database, and my fragmentation is 1%. I know this isn't ...
    Joshua D. DrakeJoshua D. Drake
    Dec 2, 2006 at 6:58 am
    Jan 16, 2007 at 8:51 pm
  • Hi all, When I swithed to the newest version og pgbuildfarm, I noticed that --with-ldap (now by defaut) didn't work on UnixWare. This is because, on Unixware, ldap needs lber and resolv. Not being a ...
    Dec 11, 2006 at 2:39 pm
    Feb 3, 2007 at 2:46 am
  • I've been skimming through the bitmap index patch... A scan needs to access at least five pages: 1. B-tree index (root+others, depending on depth) 2. The auxiliary heap page 3. bitmap index meta page ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 26, 2006 at 7:47 pm
    Apr 9, 2007 at 2:22 am
  • Hello, Is this really a TODO or is this someone being overzealous with the TODO list? Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || ...
    Joshua D. DrakeJoshua D. Drake
    Dec 28, 2006 at 5:36 pm
    Jan 4, 2007 at 1:42 am
  • i haven't looked at the other patches yet, but this one is just horrid :-( Instead of creating a proper parse-tree representation of the NULLS FIRST/LAST option, you've kluged it to convert the ...
    Tom LaneTom Lane
    Dec 4, 2006 at 6:19 pm
    Jan 10, 2007 at 10:47 am
  • My understanding from 8.2 development was that EXPLAIN ANALYZE had been altered so that if you issued a particular keystroke while it was executing you'd get a partial results-so-far version of the ...
    Simon RiggsSimon Riggs
    Dec 8, 2006 at 10:36 am
    Dec 13, 2006 at 8:25 pm
  • I have been working on providing psql with the ability to accept a libpq conninfo string, so that the following now works for me: psql "conn:service=sname user=uname" Instead of providing yet another ...
    Andrew DunstanAndrew Dunstan
    Dec 12, 2006 at 9:24 pm
    Dec 17, 2006 at 8:23 pm
  • Hello, NTT staffs are working on TODO item: We call the bitmap "Dead Space Map" (DSM), that allows VACUUM to scan only pages that need vacuuming or freezing. We'd like to discuss the design on ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Dec 28, 2006 at 5:50 am
    Jan 17, 2007 at 7:43 am
  • Several of the buildfarm machines are exhibiting repeatable signal 11 crashes in what seem perfectly ordinary queries. This started about four days ago so I suppose it's got something to do with my ...
    Tom LaneTom Lane
    Dec 26, 2006 at 4:25 pm
    Dec 31, 2006 at 5:48 pm
  • Why? It's going to have to fit in a float4 eventually anyway. regards, tom lane
    Tom LaneTom Lane
    Dec 27, 2006 at 11:26 pm
    Dec 29, 2006 at 7:54 pm
  • Until we work out a better solution we can fix this in two ways: 1. EXPLAIN ANALYZE [ [ WITH | WITHOUT ] TIME STATISTICS ] ... 2. enable_analyze_timer = off | on (default) (USERSET) A performance ...
    Simon RiggsSimon Riggs
    Dec 15, 2006 at 10:28 am
    Dec 19, 2006 at 4:43 am
  • I'm teaching a class this week and a student asked me about OIDs. He related the story of how in Sybase, if you moved a database from one server from another, permissions got all screwed up because ...
    Jim NasbyJim Nasby
    Dec 20, 2006 at 6:05 am
    Dec 23, 2006 at 8:27 am
  • I've been fooling with catalog entries here and I've obviously done something wrong. But I'm a bit frustrated trying to debug initdb. Because of the way it starts up the database in a separate ...
    Gregory StarkGregory Stark
    Dec 18, 2006 at 11:35 am
    Dec 21, 2006 at 6:12 am
  • I mentioned this a while back, now that 8.2 is out perhaps others will be more interested in new code. Currently Postgres regression tests only test functionality within a single session. There are ...
    Gregory StarkGregory Stark
    Dec 12, 2006 at 11:54 pm
    Mar 28, 2007 at 10:04 am
  • Permissions on a trigger function seem not to be checked, and I can execute a function for which I have no privileges. I consider this a security leak - or am I missing something? Here is a complete ...
    Albe LaurenzAlbe Laurenz
    Dec 14, 2006 at 3:58 pm
    Feb 1, 2007 at 4:54 am
  • Hello, What is the status of supporting the "WITH" keyword? -- Edwin S. Ramirez, Senior Developer Information Technology Department - ITDC Mount Sinai Medical Center edwin.ramirez@mssm.edu * ...
    Edwin RamirezEdwin Ramirez
    Dec 26, 2006 at 9:00 pm
    Jan 3, 2007 at 11:25 pm
  • The 8.2.0 release went well. We spent a month more in beta than we planned, but that time helped to eliminate many bugs, and many that had existed in previous PostgreSQL major releases as well. We ...
    Bruce MomjianBruce Momjian
    Dec 19, 2006 at 5:24 pm
    Dec 21, 2006 at 10:12 pm
  • Hi. I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? Ver 8.1.5 saito=# select 'Fri Dec 15 ...
    Hiroshi SaitoHiroshi Saito
    Dec 15, 2006 at 6:48 am
    Dec 16, 2006 at 7:20 pm
  • I'm encountering some disconcerting problems on a 8.1.3 database. Very occasionally, I get a "could not open relation with OID xxx". This always occurs inside of a plpgsql function, and always refers ...
    Greg Sabino MullaneGreg Sabino Mullane
    Dec 20, 2006 at 6:04 pm
    Jan 4, 2007 at 10:09 pm
  • I've written up a Warm Standby script as a .c program rather than scripts, to allow it to be portable and potentially shipped as part of PostgreSQL core. pg_standby is designed to be a wait-for ...
    Simon RiggsSimon Riggs
    Dec 13, 2006 at 7:37 pm
    Dec 28, 2006 at 7:15 pm
  • While pg_catalog.pg_index has the create index script I otherwise cant find the index columns in the information_schema. Any ideas?
    Dec 6, 2006 at 1:39 am
    Dec 6, 2006 at 5:57 pm
  • Why exactly is that a good idea? Since DTrace is Solaris-only, this almost seems like an attempt to hide non-Solaris-specific information where people won't look for it. Moreover, the point of ...
    Tom LaneTom Lane
    Dec 1, 2006 at 11:56 pm
    Dec 5, 2006 at 9:48 pm
  • While testing a PITR recovery, I discovered that recovery.conf doesn't seem to allow specifying ' in the command string, making it hard to protect the restore_command against problematic filenames ...
    Andrew - SupernewsAndrew - Supernews
    Dec 13, 2006 at 4:23 am
    Feb 3, 2007 at 10:32 pm
  • Hello, Per the TODO list: Allow pg_hba.conf to specify host names along with IP addresses Host name lookup could occur when the postmaster reads the pg_hba.conf file, or when the backend starts. ...
    Joshua D. DrakeJoshua D. Drake
    Dec 27, 2006 at 9:23 pm
    Dec 27, 2006 at 11:17 pm
  • I adjusted my buildfarm config (mongoose) to attempt to build HEAD --with-libxml. I added the following to build-farm.conf: if ($branch eq 'HEAD' || $branch ge 'REL8_3') { push(@{$conf{config_opts}}, ...
    Jeremy DrakeJeremy Drake
    Dec 22, 2006 at 5:46 pm
    Dec 24, 2006 at 6:19 am
  • When psql is running and CRTL + \ is pressed, a core dumped show up. In first place I ran psql into gdb, saw the backtrace and I believed it was a libc6 bug and I reported to my distro security team ...
    Dec 19, 2006 at 10:52 pm
    Dec 20, 2006 at 10:53 pm
  • I noticed today that process_implied_equality() still contains an ugly hack that should have been got rid of awhile ago: it assumes that mergejoinable operators are named "=". This has been a bogus ...
    Tom LaneTom Lane
    Dec 12, 2006 at 10:56 pm
    Dec 13, 2006 at 9:33 pm
  • This is right after a for-loop, which exits when i = maxoff + 1. So the first if-statement could be written as "if (newitemoff maxoff)". If that's true, newitemonleft shouldn't be true, because that ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 7, 2006 at 7:32 pm
    Feb 6, 2007 at 4:06 pm
  • Hello, I'd like to propose a new feature, Deadline-Based Vacuum Delay, the syntax is something like "VACUUM IN 6 HOURS". Vacuum is a non-trivial task to be performed. The database needs to be ...
    Galy LeeGaly Lee
    Dec 28, 2006 at 7:39 am
    Jan 5, 2007 at 2:54 pm
  • The patch applies to the 8.2.0 tarball without rejects and without fuzz. That's good. Now on to some fun with pgcluster... However, the patch will not apply to cvs branch REL8_2_0. This all raises ...
    Matt MillerMatt Miller
    Dec 18, 2006 at 7:44 pm
    Dec 19, 2006 at 7:43 am
  • Gavin SherryGavin Sherry
    Dec 5, 2006 at 1:50 pm
    Dec 8, 2006 at 5:43 am
  • I have updated my Synchronized Scan patch and have had more time for testing. Go to http://j-davis.com/postgresql/syncscan-results10.html where you can download the patch, and see the benchmarks that ...
    Jeff DavisJeff Davis
    Dec 19, 2006 at 5:06 pm
    Feb 2, 2007 at 11:05 pm
  • Folks, While using DBI-Link, I've noticed a little lacuna in how functions returning (SETOF) RECORD work, namely, that you have to cast them to explicit lists of columns, even when that list of ...
    David FetterDavid Fetter
    Dec 27, 2006 at 10:06 pm
    Jan 8, 2007 at 8:12 pm
  • psql's display of Unicode combining characters appears to have changed in 8.2. For example, I'd expect <U+006E LATIN SMALL LETTER N, U+0303 COMBINING TILDE to display the same as the precomposed ...
    Michael FuhrMichael Fuhr
    Dec 10, 2006 at 5:50 am
    Dec 28, 2006 at 4:41 am
  • Hello, I am work on implementation of SQL/PSM language for PostgreSQL. You can see first results on http://postgresql.interweb.cz/index.php/SQL/PSM . My goal is creating of referential implementation ...
    Pavel StehulePavel Stehule
    Dec 4, 2006 at 12:09 pm
    Dec 17, 2006 at 2:24 pm
  • I am trying to create the libpq.a as a universal binary (both ppc and intel macs). Does anyone have any information on this process? Thanks, Ted
    Ted PetroskyTed Petrosky
    Dec 12, 2006 at 5:58 pm
    Dec 15, 2006 at 4:26 pm
  • Hello, I'm testing the recently changes of WAL entries for freezing-tuples. VACUUM FREEZE took more time. The cause seems to be flushing WAL buffers. Vacuuming processes free buffers into freelist. ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Dec 18, 2006 at 2:55 am
    Feb 6, 2007 at 3:29 am
  • I want to collect all XML todo issues (from my list, from Peter's and those Tom just described in "Loose ends in PG XML patch") in one place, to make the overall picture clear for everyone. How can I ...
    Nikolay SamokhvalovNikolay Samokhvalov
    Dec 24, 2006 at 8:59 am
    Jan 28, 2007 at 10:38 am
  • this seems to cause regression failures on all the buildfarm members (none of them are yet building with xml support). http://www.pgbuildfarm.org/cgi-bin/show_status.pl Stefan
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Dec 21, 2006 at 7:10 pm
    Jan 3, 2007 at 6:08 am
  • Hi, I want to add my .c and .h source files into the postgresql project. What kind of changes should I make with the Makefiles. It seems that, it is not enough just to add the object file of the C ...
    Dakotali kasapDakotali kasap
    Dec 27, 2006 at 4:33 pm
    Dec 27, 2006 at 7:08 pm
  • I'm forwarding this on behalf of Marc Hebert
    Dave CramerDave Cramer
    Dec 1, 2006 at 12:47 pm
    Dec 19, 2006 at 2:02 pm
Group Navigation
period‹ prev | Dec 2006 | next ›
Group Overview
grouppgsql-hackers @

163 users for December 2006

Tom Lane: 259 posts Joshua D. Drake: 85 posts Bruce Momjian: 80 posts Andrew Dunstan: 68 posts Simon Riggs: 62 posts Martijn van Oosterhout: 57 posts Stephen Frost: 47 posts Peter Eisentraut: 34 posts Magnus Hagander: 27 posts Alvaro Herrera: 26 posts Gregory Stark: 25 posts Jeff Davis: 24 posts Takayuki Tsunakawa: 24 posts Heikki Linnakangas: 23 posts Jim C. Nasby: 22 posts Mark: 20 posts Gurjeet Singh: 20 posts ITAGAKI Takahiro: 19 posts Andreas Zeugswetter: 16 posts Teodor Sigaev: 14 posts
show more