On Mon, 7 Apr 2025 at 14:45, Costa Alexoglou wrote:
> ...
> with a plan:
> ```
> Gather Merge (cost=115584.47..118515.35 rows=25120 width=824) (actual
> time=46.004..74.267 rows=29653 loops=1)
> Workers Planned: 2
> Workers Launched: 2
> -> Sort (cost=114584.45..114615.85 rows=12560 widt
Hey,
On Wed, 12 Mar 2025 at 10:11, Luca Ferrari wrote:
> Now, according to the documentation, the function f_t is immutable
> since it is not modifying the database, so what is going on? And why
> is the same function working if the table has not the constraint on
> the column?
I can reproduce t
On Mon, 11 Mar 2024 at 13:26, Michał Kłeczek wrote:
>
>
> > On 11 Mar 2024, at 11:41, Michał Kłeczek wrote:
> >
> > Hi,
> >
> > I am trying to create an extension that delegates some calls to btree_gist
> > functions:
> >
> > DirectFunctionCall5Coll(
> >gbt_text_consistent, …othe
Hello,
On Thu, 5 Oct 2023 at 16:42, jacktby jacktby wrote:
>
> Hi, I’m writing some kernel codes in pg15, and now I need to make a map
> struct, I know c-lang doesn’t support this, so does pg support an internal
> struct? Hopefully your replies.
PostgreSQL has hash tables:
https://github.com/p
On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips
wrote:
> We now wonder if tri-gram alone can achieve a fast full text search result.
> If so, then we could the tsvector column be dropped?
>
> 1. Is FTS required for tri-gram to work?
> 2. Are these independent of each other?
FTS and tri-gram are in
Hello,
On 31.07.2019 14:21, Luca Ferrari wrote:
Hello,
I'm a little confused about the setting pgaudit.log_parameter of the
pgaudit extension
(https://github.com/pgaudit/pgaudit/blob/master/README.md).
What's the purpose of this? AN example of query that will trigger such
parameter logging? Appa
