[ANNOUNCE] BISCUIT – A Bitmap-Based Indexed Search Extension for PostgreSQL

2025-11-01 Thread Sivaprasad
Hi all, I'm excited to announce the release of BISCUIT, a new PostgreSQL extension focused on deterministic pattern matching using bitmaps and logical operations. Unlike pg_trgm, BISCUIT is deterministic — no verification required. It uses bitmap-based indexing to accelerate complex LIKE and patt

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Bruce Momjian
On Sat, Nov 1, 2025 at 02:15:43PM -0700, Adrian Klaver wrote: > 3) Of course there is: > > https://www.postgresql.org/community/ > > "PostgreSQL is well-supported by its active community." > > > To me that means extensions provided by members of the 'community' are > 'community-provided'? Yes

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Adrian Klaver
On 11/1/25 11:34, Greg Sabino Mullane wrote: On Sat, Nov 1, 2025 at 11:32 AM Adrian Klaver > wrote: The community does provide it, just not the version of Postgres released here: I'm not sure of your point here. Companies have forked versions / patche

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Rainer Duffner
> Am 01.11.2025 um 19:54 schrieb Ken Marshall : > > +1 from me for having TDE in-core or available as an extension > > The security auditors that I have worked with have been increasingly > unwilling to actual evaluate the merits of an implementation or perhaps > no longer have the knowledge or

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Ken Marshall
+1 from me for having TDE in-core or available as an extension The security auditors that I have worked with have been increasingly unwilling to actual evaluate the merits of an implementation or perhaps no longer have the knowledge or skills needed. This is a needed checkbox to allow PostgreSQL t

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Greg Sabino Mullane
On Sat, Nov 1, 2025 at 11:32 AM Adrian Klaver wrote: > The community does provide it, just not the version of Postgres released > here: > I'm not sure of your point here. Companies have forked versions / patches, yes, but not sure how that equates to "community-provided" Cheers, Greg -- Crunch

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Adrian Klaver
On 11/1/25 06:58, Bruce Momjian wrote: On Sat, Nov 1, 2025 at 08:34:57AM +0100, Kai Wagner wrote: If you want to move forward with TDE without waiting to see if the temporary file compression patch will reduce the TDE code impact, you need to dig into how the community does feature calculus a

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Bruce Momjian
On Sat, Nov 1, 2025 at 08:34:57AM +0100, Kai Wagner wrote: > I wholeheartedly agree, as in this thread we are trying to do the same thing > again, that has already happened all they years before. We lose ourselves in > technical reasons, wondering why this makes no sense and how it could be > achi

Re: Enquiry about TDE with PgSQL

2025-11-01 Thread Kai Wagner
On Sat, Nov 1, 2025 at 5:19 AM Chris Travers wrote: > I maintain that the way forward is to get TDE in core. Perhaps someone > could pick up the previous patches and try to push them again > I wholeheartedly agree, as in this thread we are trying to do the same thing again, that has already happ