Re: [HACKERS] buildfarm stats
Chris Mair wrote: but it is about 2Gb of data, so just putting a dump cleaned of personal data somewhere isn't really an option. I could arrange a dump without the diagnostics, in these 2 tables: system: < name | operating_system | os_version | compiler | compiler_version | architecture > build: < name | snapshot | stage | branch | build_flags > (stage in the latter table is OK on success or the name of the stage that failed otherwise). But what do you want it for? And do you want it one-off or continuously? Nothing important at all. I'd just thought about a few interesting stats, like failures vs OS (as the first poster said) or failures vs gcc version or timings vs. arch / RAM or gcc version, etc. For the timings I guess there are some timestamps embedded that might be extracted... But I didn't really think about it, before posting (classic mailing list syndrome ;) We don't have any timing info. For now this goes on the wishlist. cheers andrew ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] buildfarm stats
> but it is about 2Gb of data, so just putting a dump cleaned of personal > data somewhere isn't really an option. > > I could arrange a dump without the diagnostics, in these 2 tables: > > system: < name | operating_system | os_version | compiler | > compiler_version | architecture > > build: < name | snapshot | stage | branch | build_flags > > > (stage in the latter table is OK on success or the name of the stage > that failed otherwise). > > > But what do you want it for? And do you want it one-off or continuously? Nothing important at all. I'd just thought about a few interesting stats, like failures vs OS (as the first poster said) or failures vs gcc version or timings vs. arch / RAM or gcc version, etc. For the timings I guess there are some timestamps embedded that might be extracted... But I didn't really think about it, before posting (classic mailing list syndrome ;) Bye, Chris. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] buildfarm stats
Joshua D. Drake wrote: On Tuesday 04 July 2006 22:14, Chris Mair wrote: Thanks for the stats Andrew. Out of interest, can you easily tabulate the number of failures against OS? Or, more generally, even put a dump of the DB (without personal infos of course :) somewhere? Bye, Chris. PS: and don't say you're running it in MySQL ;) Well as the host, I guarantee you that it is NOT running mySQL :) but it is about 2Gb of data, so just putting a dump cleaned of personal data somewhere isn't really an option. I could arrange a dump without the diagnostics, in these 2 tables: system: < name | operating_system | os_version | compiler | compiler_version | architecture > build: < name | snapshot | stage | branch | build_flags > (stage in the latter table is OK on success or the name of the stage that failed otherwise). But what do you want it for? And do you want it one-off or continuously? cheers andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] buildfarm stats
On Tuesday 04 July 2006 22:14, Chris Mair wrote: > > Thanks for the stats Andrew. Out of interest, can you easily tabulate > > the number of failures against OS? > > Or, more generally, even put a dump of the DB (without personal infos > of course :) somewhere? > > Bye, Chris. > > PS: and don't say you're running it in MySQL ;) Well as the host, I guarantee you that it is NOT running mySQL :) Sincerely, Joshua D. Drake > > > > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster ---(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
Re: [HACKERS] buildfarm stats
> Thanks for the stats Andrew. Out of interest, can you easily tabulate > the number of failures against OS? Or, more generally, even put a dump of the DB (without personal infos of course :) somewhere? Bye, Chris. PS: and don't say you're running it in MySQL ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] buildfarm stats
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Dunstan > Sent: 03 July 2006 23:56 > To: PostgreSQL-development > Subject: [HACKERS] buildfarm stats > > > Sometime in late June the buildfarm passed 50,000 builds reported on. > Here are stats over the lifetime. Thanks for the stats Andrew. Out of interest, can you easily tabulate the number of failures against OS? Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] buildfarm stats
Sometime in late June the buildfarm passed 50,000 builds reported on. Here are stats over the lifetime. cheers andrew ym| builds | reporting_members ++--- 2004-10 |181 | 6 2004-11 | 1533 |12 2004-12 | 2468 |27 2005-01 | 2432 |30 2005-02 | 1367 |25 2005-03 | 1970 |28 2005-04 | 2297 |28 2005-05 | 2348 |28 2005-06 | 2543 |34 2005-07 | 3038 |43 2005-08 | 2748 |41 2005-09 | 2104 |36 2005-10 | 2597 |36 2005-11 | 2214 |35 2005-12 | 2534 |38 2006-01 | 3338 |41 2006-02 | 2843 |40 2006-03 | 2536 |43 2006-04 | 2978 |45 2006-05 | 2816 |45 2006-06 | 3338 |50 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly