IndexAccessMethod API & Index Only Scans

2024-09-27 Thread Eric Ridge
Hi all! Congrats on releasing v17! I'm adding support for Index Only Scans to a custom IAM impl and I've got a little dilemma. My IAM implementation is essentially a composite index that might have up to 32 columns and while it can return any column in the index definition it's quite expens

Re: Hide exposed impl detail of wchar.c

2023-11-21 Thread Eric Ridge
(I hope you don't mind I'm reposting your reply -- I accidentally replied directly to you b/c phone) > On Nov 21, 2023, at 11:56 AM, Andres Freund wrote: > > Hi, > > On 2023-11-21 10:11:18 -0500, Eric Ridge wrote: >> On Mon, Nov 20, 2023 at 7:10 PM Andres Freund

Re: Hide exposed impl detail of wchar.c

2023-11-21 Thread Eric Ridge
> On Nov 20, 2023, at 7:10 PM, Andres Freund wrote: > > > What I don't quite get is why SIMD headers are particularly more problematic > than others - there's other headers that are compiler specific? The short answer is the rust-based bindings generation tool pgrx uses (bindgen) is a little b

Re: [PATCH] Support % wildcard in extension upgrade filenames

2023-05-01 Thread Eric Ridge
> On May 1, 2023, at 4:24 PM, Tom Lane wrote: > > Eric Ridge writes: >> FWIW, outside of major ZDB releases, most of those have little-to-zero >> schema changes. But that doesn't negate the fact each release needs its own >> upgrade.sql script. I'm

Re: [PATCH] Support % wildcard in extension upgrade filenames

2023-05-01 Thread Eric Ridge
> On May 1, 2023, at 12:12 PM, Robert Haas wrote: > > On Fri, Apr 28, 2023 at 10:03 AM Eric Ridge wrote: >> ZomboDB has 137 releases over the past 8 years. > > Dang. > > This may be one of those cases where the slow pace of change for > extensions shipped wit

Re: [PATCH] Support % wildcard in extension upgrade filenames

2023-04-28 Thread Eric Ridge
(I'm the developer of ZomboDB and pgrx, which while not an extension per se, allows others to make extensions that then need upgrade scripts. So this topic is interesting to me.) > On Mar 13, 2023, at 2:48 PM, Regina Obe wrote: > >>> I wonder if a solution to this problem might be to provide

Re: Threading in BGWorkers (!)

2020-06-22 Thread Eric Ridge
> dispatch the threaded work to a non-Postgres-ish process I’m no expert here but all your solid points about threading with Postgres notwithstanding I think there’s some issues around interrupt handling and general syscalls that doesn’t otherwise play nice with “non-Postgres-ish” *threads*