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
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 s
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
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
> > > --t
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 1006
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 co
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
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 ke
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 pg_state_
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 of
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 perh
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
. Some of 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/
Postgr
ing 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,
Mar
it, 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 - Po
[2], for what it's worth...
"... 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/torval
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 (3.8.x / pp
ty last year about 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/
; on your buildfarm hosts, that would be really handy. 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/
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
ng up
to monitor these things.
> Does dmesg 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
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 platform (and if so, wha
|| die "opening $cmdfile: $!";
> > 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/
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
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.
> > >
> > > I
ata 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
better
> visual 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
list page. 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://ww
Hi Hongyuan,
On Tue, Mar 06, 2018 at 01:36:23AM +0800, Hongyuan Ma wrote:
> Hi Mark,
> In the past few days I have read some code in pgperffarm.git repository.I
> look forward to discussing the project in detail with you and gradually
> defining the datasheet structure and refining the requireme
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 project more clearly. Here are
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 up
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 d
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 th
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
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
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,
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 Benchmark
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
quickly.
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
>
> it etc.
Yeah, 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
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.)
> > >
> >
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 -
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 goo
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
> fai
stand 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 Enterpri
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
ere to put 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
hen a narrative style is 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
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
> > >
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 functions
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 ea
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 ea
t-3, because I'm trying to
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
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
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 - Postg
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 com
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/
di
increased from ~93,000 to ~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/
>-
>
> https://www.postgresql-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/GS
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&dt=2020-09-18%2014%3A01%3A48
>
> Illegal instruction
> pg_dumpall: error: pg_dump failed o
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
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
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.2ndQuad
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
3433a2313e | ---- |
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
Hi Tom,
On 2/14/25 10:01 AM, Tom Lane wrote:
I see that somebody decided to crank up some animals running
RHEL8 and RHEL9 with FIPS mode turned on. The RHEL9 animals
pass on v17 and master, but not older branches; the RHEL8
animals pass nowhere. This is unsurprising given that the
v17-era comm
On Tue, Feb 18, 2025 at 02:41:18PM +0100, Álvaro Herrera wrote:
> On 2025-Feb-17, Daniel Gustafsson wrote:
>
> > On 17 Feb 2025, at 20:23, Tom Lane wrote:
>
> > > Obviously, we could talk about extending the regression tests'
> > > support for these cases, but I'm really dubious that it's worth
> On Feb 17, 2025, at 2:36 AM, Álvaro Herrera wrote:
> Hello,
>
> So in light of this conversation, what to do about the following pending
> requests?
>
> pgbfprod=> select format('%s %s', operating_system, os_version) as "OS" from
> pending();
> OS
>
68 matches
Mail list logo
