Re: Guiding principle for dropping LLVM versions?

On 1/25/24 13:41, Thomas Munro wrote: On Thu, Jan 25, 2024 at 4:44 PM Thomas Munro wrote: ... A few build farm animals will now fail in the configure step as discussed, and need some adjustment (ie disable LLVM or upgrade to LLVM 10+ for the master branch). Owners pinged. I think I fixed

Re: LLVM 16 (opaque pointers)

On Mon, Oct 23, 2023 at 10:47:24PM -0400, Tom Lane wrote: > Andres Freund writes: > > FC 29 is well out of support, so I don't think it makes sense to invest any > > further time in this. Personally, I don't think it's useful to have years > > old > > fedora in the buildfarm... > > +1. It's

Re: LLVM 16 (opaque pointers)

On Tue, Oct 24, 2023 at 10:17:22AM +1300, Thomas Munro wrote: > On Tue, Oct 24, 2023 at 4:27 AM Mark Wong wrote: > > I haven't gotten around to disabling llvm on any of my animals with llvm > > < 7 yet. Do you still want to hold on that? > > Yes, please disable --with

Re: LLVM 16 (opaque pointers)

On Mon, Oct 23, 2023 at 01:15:04PM +1300, Thomas Munro wrote: > On Sun, Oct 22, 2023 at 2:44 PM Thomas Munro wrote: > > On Sat, Oct 21, 2023 at 2:45 PM Tom Lane wrote: > > > Thomas Munro writes: > > > > (It'd be nice if the > > > > build farm logged "$LLVM_CONFIG --version" somewhere.) > > > >

Re: LLVM 16 (opaque pointers)

I'm slowing enabling --with-llvm on POWER, s390x, and aarch64 (but none here yet as I write this)... > I doubt I can get anywhere near an s390x though, and we definitely had > pre-existing problems on that arch. If you want to send me your ssh key, I have access to these systems through OSUOSL and LinuxFoundation programs. Regards, Mark -- Mark Wong EDB https://enterprisedb.com

Re: Buildfarm failures on urocryon

Hi, On Fri, Sep 01, 2023 at 11:27:47AM +0530, vignesh C wrote: > Hi, > > Recently urocryon has been failing with the following errors at [1]: > checking for icu-uc icu-i18n... no > configure: error: ICU library not found > If you have ICU already installed, see config.log for details on the >

Re: real/float example for testlibpq3

On Mon, Mar 20, 2023 at 01:37:57PM -0400, Gregory Stark (as CFM) wrote: > On Mon, 23 Jan 2023 at 11:54, Mark Wong wrote: > fficient way to communicate useful information. > > > > Yeah, I will try to cover all the data types we ship. :) I'll keep at > > it and drop t

Re: real/float example for testlibpq3

s more appropriate than a whole > bunch of small sample programs; maintaining working code in the > documentation seems like an annoying amount of maintenance and is > probably not the most efficient way to communicate useful information. Yeah, I will try to cover all the data types we ship. :) I'll keep at it and drop the code examples. Regards, Mark -- Mark Wong EDB: http://www.enterprisedb.com

Re: real/float example for testlibpq3

On Thu, Nov 03, 2022 at 09:55:22AM -0400, Tom Lane wrote: > Peter Eisentraut writes: > > On 01.11.22 09:15, Tom Lane wrote: > >> Agreed that the libpq manual is not the place for this, but I feel > >> like it will also be clutter in "Data Types". Perhaps we should > >> invent a new appendix or

Re: real/float example for testlibpq3

it and how to mark it up, > > etc., in a repeatable fashion is part of the job here. > > Yup. I'll take a stab at adding a new chapter and share how that looks. Regards, Mark -- Mark Wong EDB https://enterprisedb.com

Re: s390x builds on buildfarm

Hi everyone, On Wed, Aug 10, 2022 at 6:56 AM Andrew Dunstan wrote: > > On 2022-08-10 We 09:04, Vivian Kong wrote: > > > > Hi, > > > > > > > > Are builds being paused on s390x as it looks like the s390x builds > > were last run 15 days ago. If so, wondering what is the reason for > > the pause

Re: Asking for feedback on Pgperffarm

o maintain it and because it sounded like you were starting to do something similar to that, I think you can save a good amount of effort from reimplementing another kit from scratch. Regards, Mark -- Mark Wong EDB https://enterprisedb.com

Re: real/float example for testlibpq3

On Thu, Jun 16, 2022 at 03:41:50PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Tue, Jun 14, 2022 at 1:40 PM Mark Wong wrote: > >> I've created a function for each data type with the idea that an example > >> for handling a specific data type can be more

Re: real/float example for testlibpq3

On Thu, Jun 16, 2022 at 03:41:50PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Tue, Jun 14, 2022 at 1:40 PM Mark Wong wrote: > >> I've created a function for each data type with the idea that an example > >> for handling a specific data type can be more

Re: real/float example for testlibpq3

On Wed, Mar 30, 2022 at 01:16:37PM -0400, Greg Stark wrote: > On Mon, 28 Feb 2022 at 17:50, Tom Lane wrote: > > > > Chapman Flack writes: > > > In the current state of affairs, what's considered the ur-source of that > > > information? > > > > The source code for the type's send/receive

Re: DBT-5 Stored Procedure Development (2022)

On Mon, May 02, 2022 at 07:14:28AM -0700, Mark Wong wrote: > On Tue, Apr 26, 2022, 10:45 AM Peter Geoghegan wrote: > > > On Tue, Apr 26, 2022 at 10:36 AM Mark Wong wrote: > > > I'm afraid not. I'm guessing that pulling in egen 1.14 would address > > > that. Ma

Re: DBT-5 Stored Procedure Development (2022)

On Tue, Apr 19, 2022 at 05:20:50PM -0700, Peter Geoghegan wrote: > On Tue, Apr 19, 2022 at 11:31 AM Mark Wong wrote: > > As some of tasks proposed are actually in place, one other task could be > > updating egen (the TPC supplied code.) The kit was last developed again &g

Re: DBT-5 Stored Procedure Development (2022)

Hi Mahesh, On Tue, Apr 19, 2022 at 02:01:54PM -0400, Mahesh Gouru wrote: > Dear all, > > Please review the attached for my jerry-rigged project proposal. I am > seeking to continually refactor the proposal as I can! My comments might briefer that they should be, but I need to write this

Re: GSoC: Database Load Stress Benchmark (2022)

Hi! On Mon, Apr 18, 2022 at 03:40:23PM +0200, Mohammad Zain Abbas wrote: > Dear concerned, > > I hope you are doing well. > > I am Mohammad Zain Abbas, currently enrolled in Erasmus Mundus (BDMA) > program. I would like you to have a look at my proposal for the "*Database > Load Stress

Re: trigger example for plsample

On Thu, Apr 07, 2022 at 06:29:53PM -0400, Tom Lane wrote: > Chapman Flack writes: > > v4 looks good to me. > > Pushed with very minor editorialization. Mainly, I undid the > decision to stop printing the function source text, on the > grounds that (1) it falsified the comment immediately above,

Re: trigger example for plsample

On Thu, Apr 07, 2022 at 10:30:13AM -0400, c...@anastigmatix.net wrote: > On 2022-04-06 16:44, Mark Wong wrote: > > I think I've applied all of these suggestions and attached a new patch. > > That looks good to me, though I wonder about the pfree(source). > In the simplest case

Re: trigger example for plsample

On Thu, Mar 10, 2022 at 06:36:44PM -0500, Chapman Flack wrote: > On 03/02/22 15:12, Mark Wong wrote: > > > I've attached v2, which reduces the output: > > > > * Removing the notices for the text body, and the "compile" message. > > * Replaced the not

Re: trigger example for plsample

On Fri, Feb 25, 2022 at 06:39:39PM +, Chapman Flack wrote: > This patch is straightforward, does what it says, and passes the tests. > > Regarding the duplication of code between plsample_func_handler and > plsample_trigger_handler, perhaps that's for the best for now, as 3554 in > the same

real/float example for testlibpq3

Hi everyone, Would adding additional examples to testlibpq3.c on handling more data types be helpful? I've attached a patch adding how to handle a REAL to current example. Regards, Mark diff --git a/src/test/examples/testlibpq3.c b/src/test/examples/testlibpq3.c index 4f7b791388..0c1739fcbb

Re: Time to drop plpython2?

On Wed, Feb 23, 2022 at 07:59:01AM -0800, Mark Wong wrote: > On Tue, Feb 22, 2022 at 08:50:07PM -0500, Tom Lane wrote: > > Mark Wong writes: > > > Take 3. :) > > > > > I've upgraded everyone to the v14 buildfarm scripts and made sure the > > > --test p

Re: Time to drop plpython2?

On Tue, Feb 22, 2022 at 08:50:07PM -0500, Tom Lane wrote: > Mark Wong writes: > > Take 3. :) > > > I've upgraded everyone to the v14 buildfarm scripts and made sure the > > --test passed on HEAD on each one. So I hopefully didn't miss any > > (other than the o

Re: Time to drop plpython2?

On Mon, Feb 21, 2022 at 03:28:35PM -0500, Tom Lane wrote: > Mark Wong writes: > > On Sat, Feb 19, 2022 at 08:22:29AM -0800, Andres Freund wrote: > >> Unfortunately it looks like it wasn't quite enough. All, or nearly all, > >> your > >> animals that ran since

Re: Time to drop plpython2?

On Sat, Feb 19, 2022 at 08:22:29AM -0800, Andres Freund wrote: > Hi, > > On 2022-02-19 02:00:28 +0000, Mark Wong wrote: > > On Fri, Feb 18, 2022 at 02:41:04PM -0800, Andres Freund wrote: > > > There's snapper ("pgbf [ a t ] twiska.com"), and there's Mark Wong'

Re: Time to drop plpython2?

Hi everyone, On Fri, Feb 18, 2022 at 02:41:04PM -0800, Andres Freund wrote: > There's snapper ("pgbf [ a t ] twiska.com"), and there's Mark Wong's large > menagerie. Mark said yesterday that he's working on updating. I've made one pass. Hopefully I didn't make any mistakes. :) Regards, Mark

trigger example for plsample

Hi everyone, I've adapted the work that Konstantina did for pl/julia as part of her GSOC project to add an example of handling triggers to plsample. Which was based from pl/tcl and pl/perl. One aspect that I'm not sure about is whether the example should be duplicating code (as it is now) for

Re: GSoc Applicant

Hello, On Mon, Apr 05, 2021 at 11:46:36PM +0200, Mohamed Mansour wrote: > Greetings, > > I'm Mohamed Mansour, a Data Engineer at IBM and a Master's degree student > in the Computer Engineering Department - Faculty of Engineering - Cairo > University. > > I would like to apply to google summer

Re: [GSoC] Question about Add functionality to pg_top and supporting tools

Hi Lu, On Sat, Mar 27, 2021 at 03:36:25PM +0800, Trafalgar Ricardo Lu wrote: > Hi, > > I am interested in "Add monitoring of pg_stat_statements to pg_systat". I > have read some code of pg_systat and enabled the pg_stat_statements > function. Thanks for your interest! > I noticed that

Re: Interest in GSoC 2021 Projects

ted in two of them. I really wish to > take part in the project *Make plsample a more complete procedural language > handler example (2021)* considering both my interest and ability. The > potential mentor for this Project is *Mark Wong*. I am also interested in > the project *Improve Po

Re: buildfarm animal shoveler failing with "Illegal instruction"

On Thu, Oct 01, 2020 at 09:12:53PM -0400, Tom Lane wrote: > Mark Wong writes: > > I'm getting Tom set up with access too, in case he has time before me to > > get a stack trace to see what's happening... > > tl;dr: it's hard to conclude that this is anything but a compiler

Re: buildfarm animal shoveler failing with "Illegal instruction"

On Thu, Oct 01, 2020 at 12:12:44PM -0700, Andres Freund wrote: > Hi Mark, > > shoveler has been failing for a while with an odd error. E.g. > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=shoveler=2020-09-18%2014%3A01%3A48 > > Illegal instruction > pg_dumpall: error: pg_dump failed on

Re: doc examples for pghandler

On Fri, Aug 14, 2020 at 02:25:52PM +0900, Michael Paquier wrote: > On Tue, Aug 11, 2020 at 01:01:10PM -0700, Mark Wong wrote: > > Ah, right. For the moment I've added some empty conditionals for > > trigger and event trigger handling. > > > > I've created a new entr

Re: doc examples for pghandler

On Mon, Jun 15, 2020 at 04:47:01PM +0900, Michael Paquier wrote: > On Sun, Jun 14, 2020 at 08:45:17PM -0700, Mark Wong wrote: > > Sounds good to me. Something more like the attached patch? > > That's the idea. I have not gone in details into what you have here, > but perhaps i

Re: doc examples for pghandler

rc/test/modules/, and if you can provide some low-level API > coverage through this module, that's even better. Sounds good to me. Something more like the attached patch? Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/ diff --

Re: doc examples for pghandler

On Fri, Jun 12, 2020 at 03:10:20PM -0400, Tom Lane wrote: > Mark Wong writes: > > Would some additional procedure language handler code examples in the > > documentation be good to add? I've put some together in the attached > > patch, and can log it to a future commi

doc examples for pghandler

Hi everyone, Would some additional procedure language handler code examples in the documentation be good to add? I've put some together in the attached patch, and can log it to a future commitfest if people think it would be a good addition. Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL

Re: GSOC 2020 - Develop Performance Farm Benchmarks and Website (2020)

nderstand the project? I suggest reaching out on the #gsoc2020-students slack channel. Details on that, and other Postgres specific GSoC information, if you haven't already seen it: https://wiki.postgresql.org/wiki/GSoC Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise ht

Re: [GSoC 2020] Questions About Performance Farm Benchmarks and Website

tgresql-archive.org/GSoC-Summery-of-pg-performance-farm-td6034578.html >- > > https://www.postgresql-archive.org/GSOC-18-Performance-Farm-Project-Initialization-Project-td6010380.html >- > > https://www.postgresql-archive.org/GSOC-18-Performance-Farm-Project-td6008120

Re: [HACKERS] kqueue

o ~140,000, ~ 32% increase * system time dropped from ~ 78% to ~ 70%, ~ 8% decrease * user time increased from ~16% to ~ 23%, ~7% increase I don't have any profile data, but I've attached a couple chart showing the processor utilization over a 15 minute interval from the database system. Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/

Re: stress test for parallel workers

quot;... cluster is an OpenStack based cluster offering POWER8 & POWER9 LE instances running on KVM ..." But to keep you on your toes, some of my ppc animals are Docker within other OpenStack/KVM instance... Regards, Mark [1] https://github.com/torvalds/linux/blob/master/arch/powerpc/m

Re: stress test for parallel workers

t, it'd be nice to investigate the infinite_recurse > failures we've been seeing on all those ppc64 critters ...) Yeah, whoever would like access, just send me your ssh key and login you'd like to use, and I'll get you set up. Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for th

Re: Why is infinite_recurse test suddenly failing?

On Mon, May 20, 2019 at 12:15:49PM -0700, Mark Wong wrote: > On Sun, May 19, 2019 at 02:38:26PM -0700, Andres Freund wrote: > > Hi, > > > > On 2019-05-14 08:31:37 -0700, Mark Wong wrote: > > > Ok, I have this added to everyone now. > > > > > &

Re: Why is infinite_recurse test suddenly failing?

On Sun, May 19, 2019 at 02:38:26PM -0700, Andres Freund wrote: > Hi, > > On 2019-05-14 08:31:37 -0700, Mark Wong wrote: > > Ok, I have this added to everyone now. > > > > I think I also have caught up on this thread, but let me know if I > > missed

Re: Why is infinite_recurse test suddenly failing?

print $handle "bt\n"; > > + print $handle "p $_siginfo\n"; > > close($handle); > > > > > > > I think we'll need to write that as: > > >     print $handle 'p $_siginfo',"\n"; Ok, I have this added to everyone now. I think I also have caught up on this thread, but let me know if I missed anything. Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/

Re: Why is infinite_recurse test suddenly failing?

On Tue, May 14, 2019 at 10:52:07AM -0400, Tom Lane wrote: > Mark Wong writes: > > Slowly catching up on my collection of ppc64le animals... > > Oh, btw ... you didn't answer my question from before: are these animals > all running on a common platfor

Re: Why is infinite_recurse test suddenly failing?

sg have any other > information (often segfaults are logged by the kernel with the code > IIRC). It's been up for about 49 days: debian@postgresql-debian:~$ uptime 14:54:30 up 49 days, 14:59, 3 users, load average: 0.00, 0.34, 1.04 I see one line from dmesg that is related to post

Re: Why is infinite_recurse test suddenly failing?

On Fri, May 03, 2019 at 11:45:33AM -0700, Andres Freund wrote: > Hi, > > On 2019-05-03 10:08:59 -0700, Mark Wong wrote: > > Ok, I think I have gdb installed now... > > Thanks! Any chance you could turn on force_parallel_mode for the other > branches it applies to too? M

Re: Why is infinite_recurse test suddenly failing?

ndy. I think that's > the only extra thing the buildfarm script needs to extract stack > traces from core dumps. We'd likely already know where the problem > is if we had a stack trace ... Ok, I think I have gdb installed now... Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/

Re: [GSoC 2019] Proposal: Develop Performance Farm Database and Website

out getting the authentication/authorization completely integrated. I think the main issue was how to integrate this app while using resources outside of the community infrastructure. We may have to continue working around that. Otherwise, I think the rest make sense. Let us know if you have any more questions. Regards, Mark -- Mark Wong 2ndQuadrant - PostgreSQL Solutions for the Enterprise https://www.2ndQuadrant.com/

Re: A note about recent ecpg buildfarm failures

even more so seeing that only HEAD is > failing, while the change was back-patched into all branches. > > Mark Wong and I poked into this off-list, and what we find is that > this seems to be a compiler bug. Those animals are all running > nearly the same version of clang

Re: Odd 9.4, 9.3 buildfarm failure on s390x

1-- | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | ---- | 1 3f3e3c3b-3a30-3938-3736-353433a2313e | 3f3e3c3b-3a30-3938-3736-353433a2313e | 0 (9 rows) Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

Re: Odd 9.4, 9.3 buildfarm failure on s390x

Hi Andres, On Fri, Sep 28, 2018 at 03:41:27PM -0700, Andres Freund wrote: > On 2018-09-28 15:22:23 -0700, Mark Wong wrote: > > On Fri, Sep 28, 2018 at 11:52:15AM -0700, Andres Freund wrote: > > > Mark, is there anything odd for specific branches? > > > > No... I don

Re: Odd 9.4, 9.3 buildfarm failure on s390x

On Fri, Sep 28, 2018 at 11:52:15AM -0700, Andres Freund wrote: > Mark, is there anything odd for specific branches? No... I don't have anything in the config that would be applied to specific branches... Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.

Re: [GSoC] Summery of pg performance farm

mber of variations might be too many things to trend on this page, but we can change that. Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

Re: ppc64le support in 9.3 branch?

om > >> building 9.3. (by setting branches_to_build to 'HEAD_PLUS_LATEST4' > >> instead of 'ALL'). > > > > So once we desupport 9.3, they'll stop building 9.4? :-) > > > > > Then we'll set it back to ALL :-) I'll put it on my calendar. :) Regards, Mark -- M

Re: GSOC 2018 Proposal review

f the django web app work needs to be moved up into phase one, because I'd propose the web app should also have an API that the build farm plants should use to transfer results. Good luck! Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.com/ PostgreSQL Development, 24

Re: Re: Re: [GSOC 18] Performance Farm Project——Initialization Project

Hi, I have some additional comments to a couple areas... On Wed, Mar 14, 2018 at 05:33:00PM -0400, Dave Page wrote: > On Tue, Mar 13, 2018 at 11:31 PM, Hongyuan Ma wrote: > > At the same time I hope you can help me understand the functional > > requirements of this

Re: [GSOC 18] Performance Farm Project

ge. That would probably help provide some context. I'll see what I can do about that... I've touched base with the pginfra team about hosting the Web site and database so I think I have that aspect covered. Regards, Mark > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.

Re: [GSOC 18] Performance Farm Project

effects? I prefer to keep things simple by not having any javascript, but I am open to being swayed otherwise by the potential consumers of this data. Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

Re: pgbench - allow to specify scale as a size

the final data file sizes due to any architecture specific nuances or changes in the backend. But perhaps it might still offer a little more meaning to be able to say "50 gigabytes of bank account data" rather than "10 million rows of bank accounts" when thinking about size over cardinality. Regards, Mark -- Mark Wonghttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services