Search Discussions

158 discussions - 1,266 posts

  • Now that we are half-way though the scheduled feature freeze, I wanted to share my thoughts about this period. Having just pushed all open items into the patches queue or 8.4 hold queue, I am seeing ...
    Bruce MomjianBruce Momjian
    Apr 27, 2007 at 3:14 am
    May 7, 2007 at 1:14 pm
  • Hi, Am planning to do the above by using the check constraint specified for each partition. This constraint's raw_expr field ends up becoming the whereClause for the rule specific to that partition. ...
    Apr 3, 2007 at 3:36 pm
    Apr 6, 2007 at 7:30 pm
  • Hi Florian, I am right now running an rsync of the Pg CVS repo to my work machine to get a git import underway. I'm rather keen on seeing your cool PITR Pg project go well and I have some git+cvs fu ...
    Martin LanghoffMartin Langhoff
    Apr 16, 2007 at 7:43 am
    Apr 30, 2007 at 1:18 pm
  • On Windows Vista, IPv6 is enabled by default, and cannot be uninstalled, or disabled easily on the loopback adaptor. localhost is ::1 by default, and the enhanced 'security' makes it insanely ...
    Dave PageDave Page
    Apr 11, 2007 at 1:36 pm
    Apr 16, 2007 at 6:39 pm
  • [ redirecting to -hackers for wider comment ] Zdenek Kotala <Zdenek.Kotala@Sun.COM writes: Yeah, I was going to suggest the same thing --- but not with that switch name. We already use ...
    Tom LaneTom Lane
    Apr 6, 2007 at 6:46 pm
    Mar 19, 2008 at 12:40 pm
  • OK, so posted. ;-) To clarify for the larger audience: without the plain "gss" mechanism, the "gss-np" mechanism provides exactly the same functionality as the existing krb5 mechanism. It will ...
    Henry B. HotzHenry B. Hotz
    Apr 30, 2007 at 10:23 pm
    May 2, 2007 at 3:53 pm
  • I'm in the process of building a new box that will have Dual Xeon 5120's (Dual Core), and 4G of ram and 2.4T of disk (6x400G SATA). It will have CentOS 4.4 X86_64 as the base os with VMWare Server ...
    Larry RosenmanLarry Rosenman
    Apr 5, 2007 at 11:13 pm
    Apr 19, 2007 at 10:39 pm
  • In recovery, with full_pages_writes=on, we read in each page only to overwrite the contents with a full page image. That's a waste of time, and can have a surprisingly large effect on recovery time. ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 25, 2007 at 12:49 pm
    May 2, 2007 at 11:26 pm
  • I'm seeing an ECPG-Check failure on Windows Vista - any ideas what might be causing this? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=vaquita&dt=2007-04-24%2020:00:05 The only other Vista ...
    Dave PageDave Page
    Apr 25, 2007 at 9:48 am
    Apr 27, 2007 at 6:59 am
  • two of my buildfarm members had different but pretty weird looking failures lately: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=quagga&dt=2007-04-25%2002:03:03 and ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Apr 25, 2007 at 5:10 am
    May 2, 2007 at 5:44 pm
  • Hi, When using views built with left joins, and then querying against these views, there are a lot of join in the plan that are not necessary, because I don't select/use any column of each table in ...
    Ottó HavasvölgyiOttó Havasvölgyi
    Apr 6, 2007 at 10:01 pm
    Apr 21, 2007 at 8:55 am
  • I'm taking over Simon's heap page diagnostic functions to get them into shape for committing. I'm thinking of having a new contrib-module for them: pgforensics. All the new functions go there, and ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 30, 2007 at 3:48 pm
    May 3, 2007 at 5:34 am
  • I've been seeing this failure intermittently on Narwhal HEAD, and once on 8.1. Other branches have been OK, as have other animals running on the same physical box. Narwhal-HEAD is run more often than ...
    Dave PageDave Page
    Apr 21, 2007 at 11:14 am
    Apr 27, 2007 at 4:08 pm
  • The attached patch changes all implicit casts to text to assignment and cleans up the associated regression test damage. This change has been discussed for the longest time; I propose that we bite ...
    Peter EisentrautPeter Eisentraut
    Apr 1, 2007 at 9:29 pm
    May 4, 2007 at 11:45 pm
  • In a PL/PgSQL set-returning function, returning the result set of a query requires a FOR loop and repeated invocations of the RETURN NEXT statement: FOR x in SELECT ... LOOP RETURN NEXT x; END LOOP; ...
    Neil ConwayNeil Conway
    Apr 23, 2007 at 9:15 pm
    May 4, 2007 at 6:38 pm
  • As I announced alpha version of SE-PostgreSQL about one month ago, I'm working for development of a security facility integrated with secure operating system. It provides database users fine grained ...
    KaiGai KoheiKaiGai Kohei
    Apr 16, 2007 at 3:46 pm
    Apr 19, 2007 at 4:00 pm
  • I'm forwarding this to the pgsql-hackers list so that folks more qualified than I can comment, but as I understand the way postgres implements locking each process has it *own* semaphore it waits on ...
    Mark KirkwoodMark Kirkwood
    Apr 10, 2007 at 10:41 am
    Apr 12, 2007 at 4:30 am
  • So I was informed today that UNION types integer and text cannot be matched. Alright, but it failed to tell which particular expressions in this 3-branch, 30-columns-each UNION clause in a 100-line ...
    Peter EisentrautPeter Eisentraut
    Apr 23, 2007 at 8:55 pm
    Mar 24, 2008 at 4:06 pm
  • Arjen van der Meijden told me that according to the tweakers.net benchmark, HEAD is noticeably slower than 8.2.4, and I soon confirmed here that for small SELECT queries issued as separate ...
    Tom LaneTom Lane
    Apr 29, 2007 at 4:44 am
    Jul 31, 2007 at 6:08 am
  • In this thread: http://archives.postgresql.org/pgsql-bugs/2007-03/msg00145.php we eventually determined that the reported lockup had three components: (1) something (still not sure what --- Martin ...
    Tom LaneTom Lane
    Apr 4, 2007 at 6:10 pm
    Apr 27, 2007 at 2:43 am
  • I've written the following function definitions to extend generate_series to support some temporal types (timestamptz, date and time). Please include them if there's sufficient perceived need or ...
    Andrew HammondAndrew Hammond
    Apr 12, 2007 at 9:56 pm
    Mar 11, 2008 at 5:44 pm
  • I'm mostly done with my review of the "Automatic adjustment of bgwriter_lru_maxpages" patch. In addition to issues already brought up with that code, there are some small things that need to be done ...
    Greg SmithGreg Smith
    Apr 18, 2007 at 1:09 pm
    Mar 11, 2008 at 3:44 pm
  • The current documentation for RESET exhibits a certain lack of, um, intellectual cohesiveness: Name RESET -- restore the value of a run-time parameter to the default value Synopsis RESET ...
    Tom LaneTom Lane
    Apr 15, 2007 at 9:01 pm
    Apr 26, 2007 at 4:15 pm
  • The error message we currently produce when a deadlock occurs is pretty unfriendly: ERROR: deadlock detected DETAIL: Process 32068 waits for AccessExclusiveLock on relation 16413 of database 16384; ...
    Neil ConwayNeil Conway
    Apr 20, 2007 at 6:34 am
    Apr 26, 2007 at 7:47 am
  • Certainly looks that way. I've looked at the code there, and can't find a clear problem. One way it could happen is if the actual PGSemaphoreUnlock() is called once more than needed. CC:ing to ...
    Magnus HaganderMagnus Hagander
    Apr 20, 2007 at 7:51 am
    Apr 22, 2007 at 6:51 pm
  • Hi, Zoltan Boszormenyi írta: I just realized that by treating SERIAL the same as IDENTITY GENERATED BY DEFAULT, I incidentally broke the possibility of multiple SERIALs in the same table. I rewrote ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Apr 16, 2007 at 5:17 pm
    Apr 20, 2007 at 8:37 am
  • Hello, I would like to submit a patch so that the COPY statement can import data into a view. (Maybe if this works I'll see about copying out of a view.) Rather than spend a whole lot of time ...
    Karl O. PincKarl O. Pinc
    Apr 19, 2007 at 1:43 pm
    Apr 19, 2007 at 11:12 pm
  • The \COPY command rejects multibyte delimiters. Is this intentional behavior? Here is an example of the behavior: pgsql@compaq ~ $ touch foo pgsql@compaq ~ $ psql -p 5555 Welcome to psql 8.3devel, ...
    Mark DilgerMark Dilger
    Apr 17, 2007 at 5:04 pm
    Apr 18, 2007 at 5:09 pm
  • Greetings, I think I found a bug, or at least a POLA violation. At work, I created a user that is NOT a superuser, nor can that user create databases. When I did a create database foo owner bar, all ...
    Larry RosenmanLarry Rosenman
    Apr 16, 2007 at 12:47 pm
    Apr 17, 2007 at 8:51 pm
  • Ohhhh ... *that's* the problem. Ugh. Although we have a separate semaphore for each PG backend, they're grouped into semaphore sets (I think 16 active semaphores per set). So a wakeup intended for ...
    Tom LaneTom Lane
    Apr 10, 2007 at 10:33 pm
    Apr 12, 2007 at 5:06 pm
  • Hi, When the lock manager's data structures were split into "partitions", how many such data structures can one partition control? Since we use LOCKTAG's hash value to decide the partition which the ...
    Rancpine cuiRancpine cui
    Apr 27, 2007 at 8:53 am
    Apr 28, 2007 at 9:37 am
  • Hello people, I'm thinking in project and implement "data fragmentation" based on catalogs inside pgcluster as my university final project. I would like suggestions and would be happy if anyone help ...
    Gustavo ToniniGustavo Tonini
    Apr 19, 2007 at 9:38 pm
    Apr 27, 2007 at 11:07 am
  • Hackers, I was thinking about the upcoming release on my 32-hour epic airplane ordeal, and realizing that it changes PostgreSQL in a lot of ways. Between major improvements to performance, major ...
    Josh BerkusJosh Berkus
    Apr 23, 2007 at 8:07 pm
    Apr 24, 2007 at 2:24 pm
  • Following up on some complaints we've had about extremely large plan times for large partitioned tables I've been doing some profiling. I've constructed a situation where it takes upwards of 30 ...
    Gregory StarkGregory Stark
    Apr 20, 2007 at 8:17 pm
    Apr 22, 2007 at 2:35 am
  • Hi I'm very excited that my project for implementing read-only queries on PITR slaves was accepted for GSoC, and I'm now trying to work out what tools I'll use for that job. I'd like to be able to ...
    Florian G. PflugFlorian G. Pflug
    Apr 12, 2007 at 1:06 pm
    Apr 16, 2007 at 3:53 pm
  • I'm seeing a problem on my benchmark machine: checkpoints stop happening after the ramp-up period. It looks like the bgwriter gets starved waiting on the CheckpointStartLock. The CheckpointStartLock ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 2, 2007 at 7:00 pm
    Apr 4, 2007 at 11:18 am
  • psql's \d command tells you about outgoing foreign key constraints (ie, ones referencing another table from this one). It doesn't tell you about incoming ones (ie, ones where another table references ...
    Tom LaneTom Lane
    Apr 10, 2007 at 2:15 pm
    Mar 7, 2008 at 12:58 am
  • Hi all, I'm one of the Google SoC's students for PostgreSQL. My project is to implement column-level privilege in PG. Here is a description of my project. Any and all help and/or comment is ...
    Golden LiuGolden Liu
    Apr 24, 2007 at 12:54 pm
    Apr 25, 2007 at 5:56 am
  • mingw-runtime-3.10 introduced a gettimeofday declaration in sys/time.h that is not compatible with port.h. (current is mingw-runtime-3.12) int __cdecl gettimeofday(struct timeval *__restrict__, void ...
    Andreas ZeugswetterAndreas Zeugswetter
    Apr 11, 2007 at 11:45 am
    Apr 13, 2007 at 7:47 pm
  • The problem is that most of the standard methods are platform dependent, as they require MAC addresses or a "good" random source, for instance. I'm not sure how we wanted to solve that, but certainly ...
    Peter EisentrautPeter Eisentraut
    Apr 10, 2007 at 4:29 pm
    Apr 11, 2007 at 6:46 am
  • Hi Does anyone know if pgsnmpd is still actively developed? The last version (0.1b1) is about 15 months old. greetings, Florian Pflug
    Florian G. PflugFlorian G. Pflug
    Apr 6, 2007 at 7:03 pm
    Apr 7, 2007 at 10:39 pm
  • Hi I believe I have discovered the following problem in pgsql 8.2 and HEAD, concerning warm-standbys using WAL log shipping. The problem is that after a crash, the master might complete incomplete ...
    Florian G. PflugFlorian G. Pflug
    Apr 19, 2007 at 8:26 pm
    Jul 5, 2007 at 7:41 pm
  • I can't help feeling that this is enormously overcomplicated. The "DFC" in particular seems to not be worth its overhead. Why wouldn't we simply track the newest commit record at all times, and then ...
    Tom LaneTom Lane
    Apr 12, 2007 at 7:57 pm
    May 28, 2007 at 8:57 pm
  • I have developed a small patch to optimizer/util/plancat.c that eliminates one of hte caveats associated with constraint exclusions, namely the inability to avoid searching tables based on the ...
    Marshall, SteveMarshall, Steve
    Apr 30, 2007 at 10:16 pm
    May 11, 2007 at 5:52 pm
  • I found that autovacuum launcher does not launch any workers in HEAD. AFAICS, we track the time to be vaccumed of each database in the following way: 1. In rebuild_database_list(), we initialize ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Apr 25, 2007 at 8:27 am
    May 7, 2007 at 7:26 pm
  • Dunno if anyone's noticed, but buildfarm member jackal has been crashing intermittently in the "cluster" regression test. I found out that I can reproduce that here on a Mac Mini (apparently the same ...
    Tom LaneTom Lane
    Apr 17, 2007 at 3:59 pm
    Apr 17, 2007 at 9:12 pm
  • Hi When I try to build CVS HEAD on OSX 10.4, compiling src/interfaces/ecpg/preproc/preproc.c fails with: In file included from preproc.y:6951: pgc.l:3:20: error: config.h: No such file or directory ...
    Florian G. PflugFlorian G. Pflug
    Apr 15, 2007 at 10:21 pm
    Apr 16, 2007 at 10:02 pm
  • I posted some fairly detailed benchmark results for my Synchronized Scan patch and it's interactions with Simon Riggs' Recycle Buffers patch here: http://j-davis.com/postgresql/patch15-results.html ...
    Jeff DavisJeff Davis
    Apr 2, 2007 at 11:42 pm
    Apr 4, 2007 at 6:57 pm
  • In case someone is wondering how that can happen, here's an example. We're scanning a bucket that contains four entries, and we split it after returning 1: 1 - 2* - 3 - 4 * denotes the next entry the ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 24, 2007 at 12:50 pm
    Apr 25, 2007 at 9:46 pm
  • A recent discussion led me to the idea that FK triggers are fired unnecessarily during an UPDATE if the foreign-key column(s) contain any NULLs, because ri_KeysEqual() treats two nulls as unequal, ...
    Tom LaneTom Lane
    Apr 17, 2007 at 9:16 pm
    Apr 18, 2007 at 6:23 pm
Group Navigation
period‹ prev | Apr 2007 | next ›
Group Overview
grouppgsql-hackers @

147 users for April 2007

Tom Lane: 221 posts Bruce Momjian: 101 posts Andrew Dunstan: 67 posts Heikki Linnakangas: 45 posts Alvaro Herrera: 44 posts Peter Eisentraut: 40 posts Simon Riggs: 40 posts Gregory Stark: 36 posts Magnus Hagander: 36 posts Dave Page: 34 posts Josh Berkus: 22 posts Andreas Zeugswetter: 21 posts Joshua D. Drake: 21 posts Florian G. Pflug: 20 posts Neil Conway: 19 posts Jim Nasby: 17 posts Martijn van Oosterhout: 16 posts Koichi Suzuki: 15 posts Mark Dilger: 15 posts Tatsuo Ishii: 15 posts
show more