| Lists: | pgsql-hackers |
|---|
| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-05 23:13:20 |
| Message-ID: | 00dd01c777d8$065c6bf0$131543d0$@org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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 running on
it.
I am willing to run any X86 or X64 OS's in VM's as buildfarm clients.
What OS's do we need coverage for?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-05 23:18:00 |
| Message-ID: | 461583A8.7050208@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
>
> It will have CentOS 4.4 X86_64 as the base os with VMWare Server running
> on it.
>
>
>
> I am willing to run any X86 or X64 OS’s in VM’s as buildfarm clients.
>
>
>
> What OS’s do we need coverage for?
CentOS5 hits ina couple days.
J
>
>
>
> LER
>
>
>
>
>
> --
>
> Larry Rosenman http://www.lerctr.org/~ler
>
> Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
>
> US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-05 23:28:39 |
| Message-ID: | 016001c777da$2a579ff0$7f06dfd0$@org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I might use that as the base then, since the hardware finishes getting here
tomorrow.
My question still stands on what OS's we need coverage for.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
Sent: Thursday, April 05, 2007 6:18 PM
To: Larry Rosenman
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] What X86/X64 OS's do we need coverage for?
>
> It will have CentOS 4.4 X86_64 as the base os with VMWare Server running
> on it.
>
>
>
> I am willing to run any X86 or X64 OS's in VM's as buildfarm clients.
>
>
>
> What OS's do we need coverage for?
CentOS5 hits ina couple days.
J
>
>
>
> LER
>
>
>
>
>
> --
>
> Larry Rosenman http://www.lerctr.org/~ler
>
> Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
>
> US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| From: | Chris Browne <cbbrowne(at)acm(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 02:02:56 |
| Message-ID: | 60slbel0of.fsf@dba2.int.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
ler(at)lerctr(dot)org ("Larry Rosenman") writes:
> I might use that as the base then, since the hardware finishes getting here
> tomorrow.
>
> My question still stands on what OS's we need coverage for.
I've got Debian testing/unstable covered. I'm not sure we have
Novell/SuSE covered...
--
output = ("cbbrowne" "@" "linuxdatabases.info")
http://www3.sympatico.ca/cbbrowne/emacs.html
"Motto for a research laboratory: What we work on today, others will
first think of tomorrow." -- Alan J. Perlis
| From: | "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 05:23:26 |
| Message-ID: | 4615D94E.5070806@tocr.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Larry Rosenman wrote:
> I might use that as the base then, since the hardware finishes getting here
> tomorrow.
The other thing to consider is that CentOS 5 has Xen built right in, so
you should be able run VMs without VMWare on it.
| From: | Devrim Gündüz <devrim(at)CommandPrompt(dot)com> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com> |
| Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 06:42:38 |
| Message-ID: | 1175841758.1680.2.camel@your-0548c161e1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi,
On Fri, 2007-04-06 at 01:23 -0400, Matthew T. O'Connor wrote:
>
> The other thing to consider is that CentOS 5 has Xen built right in,
> so you should be able run VMs without VMWare on it.
... if the kernel of the OS has Xen support, there will be no
performance penalty (only 2%-3%) (Para-virtualization). Otherwise, there
will be full-virtualization, and we should expect a performance loss
about 30% for each guest OS (like Windows).
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.CommandPrompt.com
| From: | "Marko Kreen" <markokr(at)gmail(dot)com> |
|---|---|
| To: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 06:58:43 |
| Message-ID: | e51f66da0704052358t44f248f7y5ede53c2194d3e82@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On 4/6/07, Larry Rosenman <ler(at)lerctr(dot)org> wrote:
> I am willing to run any X86 or X64 OS's in VM's as buildfarm clients.
>
> What OS's do we need coverage for?
Cannot say about OS, but could you run it with
Python 2.5? 64bit interface changed there and it
would be interesting to see if it still works.
--
marko
| From: | Matthew O'Connor <matthew(at)zeut(dot)net> |
|---|---|
| To: | Devrim Gündüz <devrim(at)CommandPrompt(dot)com> |
| Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 07:53:48 |
| Message-ID: | 4615FC8C.4070804@zeut.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Devrim Gündüz wrote:
> Hi,
>
> On Fri, 2007-04-06 at 01:23 -0400, Matthew T. O'Connor wrote:
>> The other thing to consider is that CentOS 5 has Xen built right in,
>> so you should be able run VMs without VMWare on it.
>
> ... if the kernel of the OS has Xen support, there will be no
> performance penalty (only 2%-3%) (Para-virtualization). Otherwise, there
> will be full-virtualization, and we should expect a performance loss
> about 30% for each guest OS (like Windows).
I may be wrong but I thought that the guest OS kernel only needs special
support if the underlying CPU doesn't have virtualization support which
pretty much all the new Intel and AMD chips have. No?
| From: | "Sander Steffann" <s(dot)steffann(at)computel(dot)nl> |
|---|---|
| To: | "Matthew O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 09:46:14 |
| Message-ID: | 002201c77830$6f95f390$b4c8a8c0@sanderthuis |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi,
>> ... if the kernel of the OS has Xen support, there will be no
>> performance penalty (only 2%-3%) (Para-virtualization). Otherwise, there
>> will be full-virtualization, and we should expect a performance loss
>> about 30% for each guest OS (like Windows).
>
> I may be wrong but I thought that the guest OS kernel only needs special
> support if the underlying CPU doesn't have virtualization support which
> pretty much all the new Intel and AMD chips have. No?
You need that CPU support if you want to do full virtualization at all.
Otherwise you can only use para-virtualization. Para-virtualization has much
better performance, but full virtualization is more flexible because you
don't need special kernel support in the guest.
- Sander
| From: | Paul Lindner <lindner(at)inuus(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 11:25:24 |
| Message-ID: | 20070406112524.GI26493@inuus.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Thu, Apr 05, 2007 at 06:28:39PM -0500, Larry Rosenman wrote:
> I might use that as the base then, since the hardware finishes getting here
> tomorrow.
>
> My question still stands on what OS's we need coverage for.
I can provide coverage of SuSE Enterprise 9/10 on i386/x86_64. I just
filled out the form on the buildfarm page, so I'm awaiting further
instructions....
--
Paul Lindner ||||| | | | | | | | | |
lindner(at)inuus(dot)com
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Matthew O'Connor <matthew(at)zeut(dot)net> |
| Cc: | Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 13:25:29 |
| Message-ID: | 20070406082344.E84209@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Fri, 6 Apr 2007, Matthew O'Connor wrote:
> Devrim Gndz wrote:
>> Hi,
>>
>> On Fri, 2007-04-06 at 01:23 -0400, Matthew T. O'Connor wrote:
>>> The other thing to consider is that CentOS 5 has Xen built right in,
>>> so you should be able run VMs without VMWare on it.
>>
>> ... if the kernel of the OS has Xen support, there will be no
>> performance penalty (only 2%-3%) (Para-virtualization). Otherwise, there
>> will be full-virtualization, and we should expect a performance loss
>> about 30% for each guest OS (like Windows).
>
> I may be wrong but I thought that the guest OS kernel only needs special
> support if the underlying CPU doesn't have virtualization support which
> pretty much all the new Intel and AMD chips have. No?
>
It doesn't matter as far as MY box is concerned. I use VMWare extensively
in my current $DAYJOB, and I want to be able to test/play with things related
to that as well. The box I'm building will be using the (free) VMWare Server
as it's virtualization platform.
I'd still like to hear from a Tom Lane or someone else on the project with what
X86 or X86_64 OS's we need coverage for.
LER
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>From pgsql-hackers-owner(at)postgresql(dot)org Fri Apr 6 11:09:32 2007
Received: from localhost (maia-3.hub.org [200.46.204.184])
by postgresql.org (Postfix) with ESMTP id 3870A9FB47A
for <pgsql-hackers-postgresql(dot)org(at)postgresql(dot)org>; Fri, 6 Apr 2007 11:09:31 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
with ESMTP id 12956-02 for <pgsql-hackers-postgresql(dot)org(at)postgresql(dot)org>;
Fri, 6 Apr 2007 11:09:17 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from nabagan.bluegap.ch (nabagan.bluegap.ch [88.198.58.248])
by postgresql.org (Postfix) with ESMTP id 8EBA59FB542
for <pgsql-hackers(at)postgresql(dot)org>; Fri, 6 Apr 2007 11:09:04 -0300 (ADT)
Received: from [192.168.77.28] (p54bd9cdd.dip0.t-ipconnect.de [::ffff:84.189.156.221])
(AUTH: CRAM-MD5 markus(at)bluegap(dot)ch, SSL: TLSv1/SSLv3,256bits,AES256-SHA)
by nabagan.bluegap.ch with esmtp; Fri, 06 Apr 2007 17:08:19 +0200
id 0023735E.46166264.00003A6D
Message-ID: <46165475(dot)5070009(at)bluegap(dot)ch>
Date: Fri, 06 Apr 2007 16:08:53 +0200
From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
User-Agent: Icedove 1.5.0.10 (X11/20070307)
MIME-Version: 1.0
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
CC: Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Martijn van Oosterhout <kleptog(at)svana(dot)org>,
"Joshua D. Drake" <jd(at)commandprompt(dot)com>,
Gregory Stark <stark(at)enterprisedb(dot)com>, NikhilS <nikkhils(at)gmail(dot)com>,
pgsql-hackers(at)postgresql(dot)org
Subject: Re: Auto Partitioning
References: <d3c4af540704030836o242c49cl2688ab4ec9808ac3(at)mail(dot)gmail(dot)com> <46139825(dot)6080204(at)bluegap(dot)ch> <1175694172(dot)3623(dot)120(dot)camel(at)silverbirch(dot)site> <87648ckzi0(dot)fsf(at)oxford(dot)xeocode(dot)com> <4613BB72(dot)1090602(at)bluegap(dot)ch> <871wj0ko91(dot)fsf(at)oxford(dot)xeocode(dot)com> <4613F49E(dot)1030901(at)bluegap(dot)ch> <1175713305(dot)3623(dot)197(dot)camel(at)silverbirch(dot)site> <4613F809(dot)2010607(at)commandprompt(dot)com> <4613FDAB(dot)6080501(at)bluegap(dot)ch> <20070405081029(dot)GA17587(at)svana(dot)org> <46155565(dot)2010605(at)bluegap(dot)ch> <28487(dot)1175838996(at)sss(dot)pgh(dot)pa(dot)us> <1175843479(dot)3623(dot)463(dot)camel(at)silverbirch(dot)site> <E1539E0ED7043848906A8FF995BDA57901E7B93D(at)m0143(dot)s-mxs(dot)net> <1175864959(dot)3623(dot)497(dot)camel(at)silverbirch(dot)site>
In-Reply-To: <1175864959(dot)3623(dot)497(dot)camel(at)silverbirch(dot)site>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/317
X-Sequence-Number: 101650
Simon Riggs wrote:
> i.e. if we have partitions for each year (2001, 2002, 2003 2004, 2005,
> 2006, 2007) AND we have already proved that 2005 is excluded when we
> have a WHERE clause saying year >= 2006, then we should be able to use
> the ordering to prove that partitions for 2004 and before are also
> automatically excluded.
Provided you've set up the right constraints, the current
constraint_exclusion feature does exactly that, no?
> I'll think some more about the Merge node, but not right now.
I've looked at nodeAppend.c and nodeMergeJoin.c. Probably we can use
much of nodeMergeJoin, just without the join? Instead returning the
tuples as they are, but in the correct order. The nodeMergeJoin code can
only handle two inputs (a left and a right node), but it might be
beneficial to structure multiple merge nodes into a binary tree layout
anyway. (I'm guessing that might reduce the amount of comparisons needed).
What do you think?
Regards
Markus
| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | Matthew O'Connor <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 14:13:42 |
| Message-ID: | 46165596.8080907@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Larry Rosenman wrote:
> It doesn't matter as far as MY box is concerned. I use VMWare
> extensively
> in my current $DAYJOB, and I want to be able to test/play with things
> related
> to that as well. The box I'm building will be using the (free) VMWare
> Server
> as it's virtualization platform.
>
> I'd still like to hear from a Tom Lane or someone else on the project
> with what
> X86 or X86_64 OS's we need coverage for.
>
>
VMWare Server is indeed a fine product, which I use extensively.
I am not sure what our Windows support is like for x86_64. Magnus has
one for MSVC (for which buildfarm support is nearly done, but not
quite). But I don't see one for MinGW. OTOH, Windows is not free (in
either sense) and setting up a build environment there is quite a bit
harder than on Unix platforms.
The other platform I've whined about missing for some time is HP-UX,
especially on PA-RISC. But that's a whole different story.
cheers
andrew
| From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, Matthew O'Connor <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 14:33:20 |
| Message-ID: | 46165A30.5060500@kaltenbrunner.cc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Andrew Dunstan wrote:
>
>
> Larry Rosenman wrote:
>> It doesn't matter as far as MY box is concerned. I use VMWare
>> extensively
>> in my current $DAYJOB, and I want to be able to test/play with things
>> related
>> to that as well. The box I'm building will be using the (free) VMWare
>> Server
>> as it's virtualization platform.
>>
>> I'd still like to hear from a Tom Lane or someone else on the project
>> with what
>> X86 or X86_64 OS's we need coverage for.
>>
>>
>
> VMWare Server is indeed a fine product, which I use extensively.
>
> I am not sure what our Windows support is like for x86_64. Magnus has
> one for MSVC (for which buildfarm support is nearly done, but not
> quite). But I don't see one for MinGW. OTOH, Windows is not free (in
> either sense) and setting up a build environment there is quite a bit
> harder than on Unix platforms.
yeah improving windows coverage might be a nice thing - some other
random thoughts might include:
*) a linux x86_64 box with say the non-commercial version of icc (intel
c compiler)
*) recent netbsd/amd64
*) solaris 10/x86 - gcc and sun studio
*) maybe solaris express/opensolaris?
*) as said early we don't seem to have any suse/novell coverage at all
though generally the x86/x64_86 coverage seems to be quite good
>
> The other platform I've whined about missing for some time is HP-UX,
> especially on PA-RISC. But that's a whole different story.
there are more obscure and rare platforms(both in terms that might be a
win for the buildfarm but HP-UX is really missing.
Stefan
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Matthew O'Connor <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 15:00:51 |
| Message-ID: | 20070406095916.M87707@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Fri, 6 Apr 2007, Andrew Dunstan wrote:
>
>
> Larry Rosenman wrote:
>> It doesn't matter as far as MY box is concerned. I use VMWare extensively
>> in my current $DAYJOB, and I want to be able to test/play with things
>> related
>> to that as well. The box I'm building will be using the (free) VMWare
>> Server
>> as it's virtualization platform.
>>
>> I'd still like to hear from a Tom Lane or someone else on the project with
>> what
>> X86 or X86_64 OS's we need coverage for.
>>
>>
>
> VMWare Server is indeed a fine product, which I use extensively.
>
> I am not sure what our Windows support is like for x86_64. Magnus has one for
> MSVC (for which buildfarm support is nearly done, but not quite). But I don't
> see one for MinGW. OTOH, Windows is not free (in either sense) and setting up
> a build environment there is quite a bit harder than on Unix platforms.
If someone wants to supply the appropriate licenses, I would be willing to run
windows VM's on this beast. I don't have the free cash to pony up the licenses.
>
> The other platform I've whined about missing for some time is HP-UX,
> especially on PA-RISC. But that's a whole different story.
I'm seeing if I can use some HP-UX boxes I have at the office to supply
HP-UX 11.11 PA-800's. No guarantees at this point, but I am asking.
>
> cheers
>
> andrew
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Matthew O'Connor <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 15:01:32 |
| Message-ID: | 20070406100103.A87707@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Fri, 6 Apr 2007, Stefan Kaltenbrunner wrote:
> Andrew Dunstan wrote:
>>
>>
>> Larry Rosenman wrote:
>>> It doesn't matter as far as MY box is concerned. I use VMWare
>>> extensively
>>> in my current $DAYJOB, and I want to be able to test/play with things
>>> related
>>> to that as well. The box I'm building will be using the (free) VMWare
>>> Server
>>> as it's virtualization platform.
>>>
>>> I'd still like to hear from a Tom Lane or someone else on the project
>>> with what
>>> X86 or X86_64 OS's we need coverage for.
>>>
>>>
>>
>> VMWare Server is indeed a fine product, which I use extensively.
>>
>> I am not sure what our Windows support is like for x86_64. Magnus has
>> one for MSVC (for which buildfarm support is nearly done, but not
>> quite). But I don't see one for MinGW. OTOH, Windows is not free (in
>> either sense) and setting up a build environment there is quite a bit
>> harder than on Unix platforms.
>
> yeah improving windows coverage might be a nice thing - some other
> random thoughts might include:
> *) a linux x86_64 box with say the non-commercial version of icc (intel
> c compiler)
> *) recent netbsd/amd64
> *) solaris 10/x86 - gcc and sun studio
> *) maybe solaris express/opensolaris?
> *) as said early we don't seem to have any suse/novell coverage at all
I'll see what I can do on the NetBSD and Solaris fronts.
>
> though generally the x86/x64_86 coverage seems to be quite good
>
>>
>> The other platform I've whined about missing for some time is HP-UX,
>> especially on PA-RISC. But that's a whole different story.
>
> there are more obscure and rare platforms(both in terms that might be a
> win for the buildfarm but HP-UX is really missing.
>
> Stefan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "Matthew O'Connor" <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 15:04:13 |
| Message-ID: | 4616616D.4050206@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
>>> VMWare Server is indeed a fine product, which I use extensively.
>>>
>>> I am not sure what our Windows support is like for x86_64. Magnus has
>>> one for MSVC (for which buildfarm support is nearly done, but not
>>> quite). But I don't see one for MinGW. OTOH, Windows is not free (in
>>> either sense) and setting up a build environment there is quite a bit
>>> harder than on Unix platforms.
>>
>> yeah improving windows coverage might be a nice thing - some other
>> random thoughts might include:
>> *) a linux x86_64 box with say the non-commercial version of icc (intel
>> c compiler)
>> *) recent netbsd/amd64
>> *) solaris 10/x86 - gcc and sun studio
>> *) maybe solaris express/opensolaris?
>> *) as said early we don't seem to have any suse/novell coverage at all
>
> I'll see what I can do on the NetBSD and Solaris fronts.
>
IMO, the Solaris one is probably more important than NetBSD.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | "Matthew O'Connor" <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 16:59:29 |
| Message-ID: | 14484.1175878769@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Larry Rosenman <ler(at)lerctr(dot)org> writes:
> I'd still like to hear from a Tom Lane or someone else on the project with what
> X86 or X86_64 OS's we need coverage for.
FWIW, I think we are more in need of coverage of different configure-option
sets than of OS's per se.
regards, tom lane
| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, Matthew O'Connor <matthew(at)zeut(dot)net>, Devrim Gündüz <devrim(at)CommandPrompt(dot)com>, "'Joshua D(dot) Drake'" <jd(at)CommandPrompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-06 18:27:15 |
| Message-ID: | 46169103.9050300@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> FWIW, I think we are more in need of coverage of different configure-option
> sets than of OS's per se.
>
>
If someone would like to put together a list of gaps we can see what we
can do about it.
For anyone who wants the data on what is being built currently, the
dashboard data is available via SOAP interface. An example client to
fetch the data is below.
cheers
andrew
------------------------------------------------------------------------------------------------------
|#!/usr/bin/perl
use SOAP::Lite;
my $obj = SOAP::Lite
->uri('http://www.pgbuildfarm.org/PGBuildFarm')
->proxy('http://www.pgbuildfarm.org/cgi-bin/show_status_soap.pl')
;
my $data = $obj->get_status->result;
# you now have the data. One example of how to use it is below.
my @fields = qw(
branch sysname stage status
operating_system os_version
compiler compiler_version architecture
when_ago snapshot build_flags
);
my $head = join (' | ', @fields);
print $head,"\n";
foreach my $datum (@$data)
{
my $line = join (' | ', @{$datum}{(at)fields});
print $line,"\n";
}
|
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-07 18:29:38 |
| Message-ID: | 200704071129.38320.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Folks,
> > I'll see what I can do on the NetBSD and Solaris fronts.
>
> IMO, the Solaris one is probably more important than NetBSD.
Solaris is taken care of ... should be online in a week or two. Sun DBTG Q.A.
set up in the Sun labs:
Solaris 9 + Sparc + SunCC
Solaris 8 + Sparc + SunCC
Solaris 10 + Sparc + SunCC
Solaris 10 + x86 + SunCC
Solaris 10 + x86 + gcc
Solaris Nevada + Sparc + SunCC
Solaris Nevada + x86 + SunCC
Solaris Nevada + x86 + gcc
... which ought to cover most of the platforms we're interested in from
Solaris. The 8 and 9 machines will just build current, but the 10 and Nevada
machines will build CVS, 8.1, 8.2 and rotationally older versions (once each
week). We're building in as many options as we have support for, including
perl, kerberos (on Nevada), Dtrace (on 8.2) and integer-datetimes.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-08 02:22:58 |
| Message-ID: | 20070407212217.N55268@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Sat, 7 Apr 2007, Josh Berkus wrote:
> Folks,
>
>>> I'll see what I can do on the NetBSD and Solaris fronts.
>>
>> IMO, the Solaris one is probably more important than NetBSD.
>
> Solaris is taken care of ... should be online in a week or two. Sun DBTG Q.A.
> set up in the Sun labs:
>
> Solaris 9 + Sparc + SunCC
> Solaris 8 + Sparc + SunCC
> Solaris 10 + Sparc + SunCC
> Solaris 10 + x86 + SunCC
> Solaris 10 + x86 + gcc
> Solaris Nevada + Sparc + SunCC
> Solaris Nevada + x86 + SunCC
> Solaris Nevada + x86 + gcc
>
> ... which ought to cover most of the platforms we're interested in from
> Solaris. The 8 and 9 machines will just build current, but the 10 and Nevada
> machines will build CVS, 8.1, 8.2 and rotationally older versions (once each
> week). We're building in as many options as we have support for, including
> perl, kerberos (on Nevada), Dtrace (on 8.2) and integer-datetimes.
>
Given Sun handling Solaris, my question is:
1) what os(s) do we need more coverage on
2) what collection of options for OS' in 1?
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | "Adrian Maier" <adrian(dot)maier(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-09 16:22:54 |
| Message-ID: | cd30ef8c0704090922h51846d0dk2599a50055417405@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
>
> > The other platform I've whined about missing for some time is HP-UX,
> > especially on PA-RISC. But that's a whole different story.
>
> there are more obscure and rare platforms(both in terms that might be a
> win for the buildfarm but HP-UX is really missing.
Hello,
I have access to a PA-RISC machine running HP-UX 11.11. Unfortunately
the machine is on a dedicated network and has no Internet access.
It should be possible to create a mirror of the CVS repository on my machine
(which has access to both the Internet and the dedicated network) so that
the HP-UX server could get the sources from my machine.
But I am not sure whether the results could be reported back to the buildfarm.
Cheers,
Adrian Maier
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Adrian Maier <adrian(dot)maier(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-09 16:38:22 |
| Message-ID: | 20070409113654.C12246@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, 9 Apr 2007, Adrian Maier wrote:
>>
>> > The other platform I've whined about missing for some time is HP-UX,
>> > especially on PA-RISC. But that's a whole different story.
>>
>> there are more obscure and rare platforms(both in terms that might be a
>> win for the buildfarm but HP-UX is really missing.
>
> Hello,
>
> I have access to a PA-RISC machine running HP-UX 11.11. Unfortunately
> the machine is on a dedicated network and has no Internet access.
>
> It should be possible to create a mirror of the CVS repository on my machine
> (which has access to both the Internet and the dedicated network) so that
> the HP-UX server could get the sources from my machine.
> But I am not sure whether the results could be reported back to the
> buildfarm.
>
I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets
fixed, and assuming either the bundled compiler will work or I can get
GCC on it.
This will take a week or 2, but I have permission now.
(This box can get out to the internet via our proxy).
LER
>
> Cheers,
> Adrian Maier
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Adrian Maier <adrian(dot)maier(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-09 16:45:45 |
| Message-ID: | 461A6DB9.70808@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Adrian Maier wrote:
>
> I have access to a PA-RISC machine running HP-UX 11.11. Unfortunately
> the machine is on a dedicated network and has no Internet access.
>
> It should be possible to create a mirror of the CVS repository on my
> machine
> (which has access to both the Internet and the dedicated network) so that
> the HP-UX server could get the sources from my machine.
> But I am not sure whether the results could be reported back to the
> buildfarm.
>
>
The buildfarm has support for reporting via a proxy server. An
appropriately configured instance of squid on the same machine that has
the CVS mirror should do the trick. Look for BF_PROXY in the buildfarm
config file.
cheers
andrew
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | Adrian Maier <adrian(dot)maier(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-09 17:17:11 |
| Message-ID: | 29490.1176139031@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Larry Rosenman <ler(at)lerctr(dot)org> writes:
> I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets
> fixed, and assuming either the bundled compiler will work or I can get
> GCC on it.
If the bundled compiler is still the same non-ANSI-C weakling that was
bundled in HPUX 10, there's no chance. It would be great to have a
buildfarm member using HP's real ANSI-spec C compiler though.
I still do a lot of my own development on HPUX 10 + gcc, so I'm not
particularly worried about lack of that combination in the buildfarm.
regards, tom lane
| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Adrian Maier <adrian(dot)maier(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-09 18:58:20 |
| Message-ID: | 20070409135747.H17853@thebighonker.lerctr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mon, 9 Apr 2007, Tom Lane wrote:
> Larry Rosenman <ler(at)lerctr(dot)org> writes:
>> I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets
>> fixed, and assuming either the bundled compiler will work or I can get
>> GCC on it.
>
> If the bundled compiler is still the same non-ANSI-C weakling that was
> bundled in HPUX 10, there's no chance. It would be great to have a
> buildfarm member using HP's real ANSI-spec C compiler though.
> I still do a lot of my own development on HPUX 10 + gcc, so I'm not
> particularly worried about lack of that combination in the buildfarm.
Looks like we are a DSPP member, so I might be able to get the aCC bundle
for free, and if so, I'll set it up with that.
Thanks,
LER
>
> regards, tom lane
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
| From: | Darcy Buskermolen <darcy(at)ok-connect(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | "Larry Rosenman" <ler(at)lerctr(dot)org>, "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com> |
| Subject: | Re: What X86/X64 OS's do we need coverage for? |
| Date: | 2007-04-19 22:21:09 |
| Message-ID: | 200704191521.10052.darcy@ok-connect.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Thursday 05 April 2007 16:28, Larry Rosenman wrote:
> I might use that as the base then, since the hardware finishes getting here
> tomorrow.
>
> My question still stands on what OS's we need coverage for.
One I see as missing right now is Solaris 10 X86 with gcc building 64bit
binaries (we have more than one member building with SunStudio 11)
>
> --
> Larry Rosenman http://www.lerctr.org/~ler
> Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
> US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
>
>
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
> Sent: Thursday, April 05, 2007 6:18 PM
> To: Larry Rosenman
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] What X86/X64 OS's do we need coverage for?
>
> > It will have CentOS 4.4 X86_64 as the base os with VMWare Server running
> > on it.
> >
> >
> >
> > I am willing to run any X86 or X64 OS's in VM's as buildfarm clients.
> >
> >
> >
> > What OS's do we need coverage for?
>
> CentOS5 hits ina couple days.
>
> J
>
> > LER
> >
> >
> >
> >
> >
> > --
> >
> > Larry Rosenman http://www.lerctr.org/~ler
> >
> > Phone: +1 512-248-2683 E-Mail: ler(at)lerctr(dot)org
> >
> > US Mail: 430 Valona Loop, Round Rock, TX 78681-3893