Re: [HACKERS] 8.0RC1 tomorrow
Bruce Momjian [EMAIL PROTECTED] writes: TODO item? Sure: * ANALYZE should record a pg_statistic entry for an all-NULL column regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] 8.0RC1 tomorrow
I wrote: I started work today on a page that lists all the members. Now viewable here: http://www.pgbuildfarm.org/cgi-bin/show_members.pl In due course, the branch names will be links to the build history. cheers andrew ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] 8.0RC1 tomorrow
The core committee has agreed that it's about time to advance to Release Candidate status (which we define as code is frozen, but not docs nor message translation work). Barring surprises, 8.0RC1 will be wrapped tomorrow (Friday). We never really issued a call for port reports as has been past practice. I think that Andrew Dunstan's build farm has partially obsoleted that custom, but if you have access to a platform that is not represented in the build farm, please do give it a try soon. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 8.0RC1 tomorrow
Tom Lane wrote: The core committee has agreed that it's about time to advance to Release Candidate status (which we define as code is frozen, but not docs nor message translation work). Barring surprises, 8.0RC1 will be wrapped tomorrow (Friday). We never really issued a call for port reports as has been past practice. I think that Andrew Dunstan's build farm has partially obsoleted that custom, but if you have access to a platform that is not represented in the build farm, please do give it a try soon. Tom, Will ANALYZE continue to ignore columns whose data is composed entirely of NULL in 8.0? http://archives.postgresql.org/pgsql-performance/2004-11/msg00363.php Mike Mascari ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 8.0RC1 tomorrow
On Dec 2, 2004, at 11:08 AM, Tom Lane wrote: We never really issued a call for port reports as has been past practice. I think that Andrew Dunstan's build farm has partially obsoleted that custom, but if you have access to a platform that is not represented in the build farm, please do give it a try soon. What platforms are covered by the build farm? I couldn't find any info about it as I looked through the pages at http://developer.postgresql.org/ -Travis ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] 8.0RC1 tomorrow
Travis P [EMAIL PROTECTED] writes: What platforms are covered by the build farm? See http://www.pgbuildfarm.org/cgi-bin/show_status.pl Also I think there is a gborg project page for it. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 8.0RC1 tomorrow
Tom Lane wrote: Travis P [EMAIL PROTECTED] writes: What platforms are covered by the build farm? See http://www.pgbuildfarm.org/cgi-bin/show_status.pl Also I think there is a gborg project page for it. s/gborg/pgfoundry/ http://pgfoundry.org/projects/pgbuildfarm/ I started work today on a page that lists all the members. cheers andrew ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 8.0RC1 tomorrow
On Dec 2, 2004, at 5:44 PM, Andrew Dunstan wrote: http://pgfoundry.org/projects/pgbuildfarm/ I started work today on a page that lists all the members. Ah, good. I'm not seeing it immediately, but I'll keep my eye out. I've an AIX 5.1 system on which I could try to compile if you don't have one in the farm, though I usually build/deploy on Linux. -Travis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 8.0RC1 tomorrow
Travis P wrote: On Dec 2, 2004, at 5:44 PM, Andrew Dunstan wrote: http://pgfoundry.org/projects/pgbuildfarm/ I started work today on a page that lists all the members. Ah, good. I'm not seeing it immediately, but I'll keep my eye out. I've an AIX 5.1 system on which I could try to compile if you don't have one in the farm, though I usually build/deploy on Linux. current approved members: name| os | compiler | arch | branches --+---++--+-- cat | Linux 2.4.22 | gcc 3.3.2 | i386 | dog | Linux 2.4.22 | gcc 3.3.2 | i386 | {HEAD,REL7_4_STABLE} kangaroo | Mac OS X 10.3.5 | gcc 3.3 20030304 (Apple Computer, Inc. build 1495) | PowerPC G4 | echidna | FreeBSD 6-CURRENT | gcc 3.4.2 [FreeBSD] 20040728 | x86 | potorooo | Solaris 2.8 | gcc 3.3.2 | Ultra SPARC | {HEAD,REL7_4_STABLE} capuchin | AIX 4.2.2 | gcc 2.8.1 | Power 2 | spoonbill | OpenBSD 3.6-current | gcc 3.3.2 | Sparc64 | {HEAD,REL7_4_STABLE} lionfish | Linux Debian/Sarge| gcc 3.3.4 | mipsel | {HEAD,REL7_4_STABLE} kudu | Solaris 9 | Sun WorkShop 6 update 2 C 5.3 Patch 111680-09 | x86 | {HEAD,REL7_4_STABLE} emu | OpenBSD 3.6-current | gcc 2.95.3 | x86/SMP | {HEAD,REL7_4_STABLE} badger| Fedora Core 2 | GCC 3.3.3 | x86 (Athlon) | {HEAD} canary| NetBSD 1.6| gcc 2.95.3 | x86 | {HEAD,REL7_4_STABLE} cockatoo | FreeBSD 4.10-STABLE | gcc 2.95.4 | x86 | {HEAD,REL7_4_STABLE} galah | FreeBSD 5.3 | gcc 3.4.2 | x86 | {HEAD,REL7_4_STABLE} loris | Windows XP Pro| gcc 3.2.3 | x86 | {HEAD} gibbon| Cygwin NT-5.1 | gcc 3.3.3 (cygwin special) | x86 | {HEAD} panda | Linux Debian sid | gcc 3.3.5 | amd64| {HEAD,REL7_4_STABLE} viper | Fedora Core 3 | GCC 3.4.2 | x86_64 | caribou | Linux 2.6.9 | gcc 3.3.5 | x86_64 | shrew | Mandrake Linux 10.0 2.6.5 SMP | gcc 3.3.2 | AMD 2600x2 | Those with nothing in the branches column have not yet reported results (one is my test machine). If you have something missing from here I'm especially interested in hearing from you. (HPUX and Solaris-x86 for example). Also anyone who has Windows machines that can be used to replace the Cygwin and Windows hosts. cheers andrew ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] 8.0RC1 tomorrow
Tom Lane wrote: We never really issued a call for port reports as has been past practice. I think that Andrew Dunstan's build farm has partially obsoleted that custom, but if you have access to a platform that is not represented in the build farm, please do give it a try soon. The platform coverage of the build farm is currently quite limited, and all those red lines don't make me feel better. I think we still need to check all the platforms explicitly. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] 8.0RC1 tomorrow
Andrew Dunstan wrote: If you have something missing from here I'm especially interested in hearing from you. I think Linux entries are quite useless. We need to know what distribution (and version) it is. The kernel is actually a pretty uninteresting part of the porting process. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] 8.0RC1 tomorrow
Peter Eisentraut wrote: Andrew Dunstan wrote: If you have something missing from here I'm especially interested in hearing from you. I think Linux entries are quite useless. We need to know what distribution (and version) it is. The kernel is actually a pretty uninteresting part of the porting process. I would very much welcome your input and that of other major developers on a) how we classify farm members, b) what steps should be run for a farm test, and c) what information would be useful from a build run. Unfortunately I got hit with some unexpected issues about a month ago that have restricted my available time rather. So far I have been concentrating on getting the clients working robustly - Windows and Cygwin have been something of a challenge, as expected. The server side is extremely simple - crude even. The database is as just 2 tables like this: pgbuildfarm=# \d buildsystems Table public.buildsystems Column | Type | Modifiers -+--+--- name | text | not null secret | text | not null operating_system | text | not null os_version | text | not null compiler | text | not null compiler_version | text | not null architecture | text | not null status | text | not null sys_owner| text | not null owner_email | text | not null Indexes: buildsystems_pkey primary key, btree (name) pgbuildfarm=# \d build_status Table public.build_status Column |Type | Modifiers --+-+--- sysname | text| not null snapshot | timestamp without time zone | not null status| integer | stage | text| log | text| conf_sum | text| branch| text| changed_this_run | text| changed_since_success | text| Indexes: build_status_pkey primary key, btree (sysname, snapshot) bs_branch_snapshot_idx btree (branch, snapshot) bs_sysname_branch_idx btree (sysname, branch) Foreign-key constraints: bs_fk FOREIGN KEY (sysname) REFERENCES buildsystems(name) ON UPDATE CASCADE ON DELETE CASCADE These were really more or less placeholders while I got things up and running. Any constructive input is welcome. Anyone who would like to make the web site look spiffy rather than pedestrian would be especially welcome (it's done in perl + template toolkit). cheers andrew ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] 8.0RC1 tomorrow
Mike Mascari [EMAIL PROTECTED] writes: Will ANALYZE continue to ignore columns whose data is composed entirely of NULL in 8.0? I had hoped to get to this before RC, but it looks like it won't happen. Considering I've just been beating up on Bruce for committing stuff that wasn't clearly a bug fix, I can't really do anything about it now ;-) regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 8.0RC1 tomorrow
Tom Lane wrote: Mike Mascari [EMAIL PROTECTED] writes: Will ANALYZE continue to ignore columns whose data is composed entirely of NULL in 8.0? I had hoped to get to this before RC, but it looks like it won't happen. Considering I've just been beating up on Bruce for committing stuff that wasn't clearly a bug fix, I can't really do anything about it now ;-) TODO item? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster