From: Dominik Csapak <d.csapak@proxmox.com>
To: Stefan Hanreich <s.hanreich@proxmox.com>,
Stoiko Ivanov <s.ivanov@proxmox.com>,
pmg-devel@lists.proxmox.com
Subject: Re: [pmg-devel] [RFC pmg-api] database: use foreign keys for rule and object group attribute
Date: Thu, 22 Feb 2024 11:05:22 +0100 [thread overview]
Message-ID: <a764739b-357c-43d8-accd-ee73d1529aa0@proxmox.com> (raw)
In-Reply-To: <b1973b05-2767-4979-8319-28d49af681a5@proxmox.com>
On 2/22/24 10:47, Stefan Hanreich wrote:
> As discussed, looks good afaict - might want to add an index later for
> faster joins since postgres doesn't add them automatically for FKs. I'd
> assume the rule DB gets read quite often when processing mail but might
> still be overkill for a couple hundred rows.
>
just fyi, the rule system only gets loaded once per smtp-filter startup
(via RuleCache) and then only when it's signaled to reload which should
only happen when the actual rule system changes
(i actually just sent a fix for the groups since writing you reminded me
that if forgot that ^^)
next prev parent reply other threads:[~2024-02-22 10:05 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2024-02-21 21:08 [pmg-devel] [RFC pmg-api] database: use foreign keys for rule and object group attributes Stoiko Ivanov
2024-02-22 9:47 ` Stefan Hanreich
2024-02-22 10:05 ` Dominik Csapak [this message]
2024-02-22 10:23 ` [pmg-devel] [RFC pmg-api] database: use foreign keys for rule and object group attribute Stefan Hanreich
2024-02-22 10:29 ` [pmg-devel] [RFC pmg-api] database: use foreign keys for rule and object group attributes Dominik Csapak
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=a764739b-357c-43d8-accd-ee73d1529aa0@proxmox.com \
--to=d.csapak@proxmox.com \
--cc=pmg-devel@lists.proxmox.com \
--cc=s.hanreich@proxmox.com \
--cc=s.ivanov@proxmox.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.
Service provided by Proxmox Server Solutions GmbH | Privacy | Legal