Re: WHERE col = ANY($1) extended to 2 or more columns?

2023-02-10 Thread Alban Hertroys
> On 9 Feb 2023, at 18:35, Dominique Devienne wrote: > > On Thu, Feb 9, 2023 at 5:37 PM David G. Johnston > wrote: > On Thu, Feb 9, 2023 at 9:28 AM Alban Hertroys wrote: > > On 9 Feb 2023, at 16:41, Dominique Devienne wrote: > > Now we'd like to do the same for composite keys, and I don't k

valgrind a background worker

2023-02-10 Thread Jon Erdman
Hi, I've got a background worker that has a slow memory leak in it somewhere. How can I get it to start under valgrind to get a memcheck output from it? -- Jon Erdman (aka StuckMojo) PostgreSQL Zealot

Re: How to use the BRIN index properly?

2023-02-10 Thread GF
For membership/equality predicates (also partial, for multiple columns) you could take a look at bloom indexes: they are quite efficient in terms of space footprint, you can even choose how long is the signature for each entry and how is distributed among the columns. https://www.postgresql.org/doc

Re: valgrind a background worker

2023-02-10 Thread Tom Lane
=?UTF-8?Q?Jon_Erdman?= writes: > I've got a background worker that has a slow memory leak in it > somewhere. How can I get it to start under valgrind to get a memcheck > output from it? You have to valgrind the whole cluster AFAIK. Basically, start the postmaster under valgrind with --trace-ch

PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Lawrence, Mike (DTST)
Dell Customer Communication - Confidential I recently installed PostgreSQL 13.9.3 on a newly build Window 11 22H1 system. When I attempt to uninstall, and I've tried numerous times, I receive the error "Unable to initialize any installation mode". Mike Lawrence Consultant Product Manager, Pro

Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Adrian Klaver
On 2/10/23 08:28, Lawrence, Mike (DTST) wrote: Dell Customer Communication - Confidential I recently installed PostgreSQL 13.9.3 on a newly build Window 11 22H1 system. When I attempt to uninstall, and I’ve tried numerous times, I receive the error "Unable to initialize any installation mode"

RE: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Lawrence, Mike (DTST)
Hi Adrian, I downloaded "postgresql-13.9-3-windows-x64.exe" from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads. I went to Windows 11 Apps > Apps & Features, found PostgreSQL 13 and used the Uninstall option from there. I also tried executing "C:\Program Files\PostgreSQL\1

Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Adrian Klaver
On 2/10/23 9:56 AM, Lawrence, Mike (DTST) wrote: Hi Adrian, I downloaded "postgresql-13.9-3-windows-x64.exe" from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads. I went to Windows 11 Apps > Apps & Features, found PostgreSQL 13 and used the Uninstall option from there. I a

Re: valgrind a background worker

2023-02-10 Thread Jon Erdman
Aha! Thanks Tom! This will be my first time using valgrind, so I was unaware of trace-children, and getting it to attach to forked stuff was exactly where I thought the difficulty would lie. This is great, much appreciated! I’m suspecting that the leak might be coming from initStringInfo(),

RE: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Lawrence, Mike (DTST)
Thanks. Those I've tried. I feel like it's related to Windows 11 as I never had trouble with SQL uninstalls in Windows 10. Mike Internal Use - Confidential -Original Message- From: Adrian Klaver Sent: Friday, February 10, 2023 10:08 AM To: Lawrence, Mike (DTST) ; pgsql-general@lis

Re: valgrind a background worker

2023-02-10 Thread Tom Lane
=?UTF-8?Q?Jon_Erdman?= writes: > I’m suspecting that the leak might be coming from initStringInfo(), as I see > a palloc() in there and no associated pfree() in my background worker’s code, > but looking at the elog backend code, it looks like maybe you only have to > explicitly free buf if you

Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode"

2023-02-10 Thread Adrian Klaver
On 2/10/23 11:47, Lawrence, Mike (DTST) wrote: Thanks. Those I've tried. Just to be clear you tried the Control Panel method and that did not work? I feel like it's related to Windows 11 as I never had trouble with SQL uninstalls in Windows 10. Mike -- Adrian Klaver adrian.kla...@akla

Re: valgrind a background worker

2023-02-10 Thread Jeffrey Walton
On Fri, Feb 10, 2023 at 10:04 AM Tom Lane wrote: > > =?UTF-8?Q?Jon_Erdman?= writes: > > I've got a background worker that has a slow memory leak in it > > somewhere. How can I get it to start under valgrind to get a memcheck > > output from it? > > You have to valgrind the whole cluster AFAIK. B

Re: valgrind a background worker

2023-02-10 Thread Tom Lane
Jeffrey Walton writes: > On Fri, Feb 10, 2023 at 10:04 AM Tom Lane wrote: >> You have to valgrind the whole cluster AFAIK. Basically, start >> the postmaster under valgrind with --trace-children=yes. >> For leak tracking you probably also want >> --leak-check=full --track-origins=yes --read-var-