On 10/11/24 20:10, admin@iseki.space wrote:
I found. Maybe we should reply to the mailing list only. Otherwise we'll
receive multiple copies of the emails.
Not if you go here:
https://lists.postgresql.org/manage/
and check:
Don't receive an extra copy of mails when listed in To or CC fiel
I found. Maybe we should reply to the mailing list only. Otherwise we'll
receive multiple copies of the emails.
On Friday, October 11, 2024, iseki zero wrote:
> So, should I use the [reply to all] button? I'm afraid the receipt list
> will growing to have too many address.
>
>
Yes, just use reply-all. The to list only grows when people reply, and it
is a mailing list - all these people are getting the ema
So, should I use the [reply to all] button? I'm afraid the receipt list
will growing to have too many address.
BTW, I'm using Thunderbird. If you have better software, tell me please.
Sorry for my poor English.
iseki zero.
在 2024/10/11 22:19, Tom Lane 写道:
Erik Wienhold writes:
On 2024-10-11
On 2024-10-11 20:43 +0200, Kaushal Shriyan wrote:
> I am running PostgreSQL 14.13 on RHEL 8.10 OS. Is there a way to Prune or
> Purge data stored on PostgreSQL 14.13 ?
>
> For example I have Analytics data stored in PostgreSQL 14.13 server for
> last 1 year (1st September 2023 till date)
>
> Is t
Hi,
I am running PostgreSQL 14.13 on RHEL 8.10 OS. Is there a way to Prune or
Purge data stored on PostgreSQL 14.13 ?
For example I have Analytics data stored in PostgreSQL 14.13 server for
last 1 year (1st September 2023 till date)
Is there a way to prune analytics data from Analytics Data stor
On Fri, Oct 11, 2024 at 9:57 PM Greg Sabino Mullane
wrote:
> On Fri, Oct 11, 2024 at 9:28 AM Durgamahesh Manne <
> maheshpostgr...@gmail.com> wrote:
>
>> composite key (placedon,id)
>> In concurrent mode if i use id at where clause then query plan for that
>> id column changes
>>
>> How to mitiga
On 10/11/24 09:16, Adrian Klaver wrote:
On 10/11/24 01:23, Thürmann, Andreas wrote:
Please do not post. The convention on this list is to inline or bottom
That should have been do not top post.
post. That makes it easier to follow the conversation flow.
See:
--
Adrian Klaver
adrian.kla..
On Fri, Oct 11, 2024 at 9:28 AM Durgamahesh Manne
wrote:
> composite key (placedon,id)
> In concurrent mode if i use id at where clause then query plan for that id
> column changes
>
> How to mitigate it rather than use seperate index for id to continue
> without change in query plan (index scan)
On 10/11/24 01:23, Thürmann, Andreas wrote:
Please do not post. The convention on this list is to inline or bottom
post. That makes it easier to follow the conversation flow.
See:
https://en.wikipedia.org/wiki/Posting_style
Yes I run it under Windows, I also have a Linux server for testing.
On 10/11/24 04:08, Koen De Groote wrote:
In the release notes for postgres 17 I'm reading:
> The PostgreSQL foreign data wrapper (postgres_fdw), used to execute
queries on remote PostgreSQL instances, can now push EXISTS and IN
subqueries to the remote server for more efficient processing.
Hello,
> On Oct 10, 2024, at 03:02, Ravi Varma Addala wrote:
>
> Hello Team,I wanted to reach out to provide some insight into a request from
> my customer regarding their multiple PostgreSQL Flex instances with
> PGbouncer. Currently, they are utilizing an Azure Load Balancer which
> distrib
Erik Wienhold writes:
> On 2024-10-11 15:00 +0200, iseki wrote:
>> But why the mailing list haven't use the "Reply-To" header specify where to
>> reply? Because the mail is you send to me directly?
> The message author sets Reply-To, if necessary, according to RFC 5322.
> Are there mailing lists
On 2024-10-11 15:00 +0200, iseki wrote:
> Oh sorry, I should use [reply to all] instead of [reply]. I don't have much
> experience with mailing lists...
>
> But why the mailing list haven't use the "Reply-To" header specify where to
> reply? Because the mail is you send to me directly?
The messag
On Fri, Oct 11, 2024 at 6:18 PM Greg Sabino Mullane
wrote:
> (please start a new thread in the future rather than replying to an
> existing one)
>
> You cannot query on b and use an index on (a,b) as you observed. However,
> you can have two indexes:
>
> index1(a)
> index2(b)
>
> Postgres will be
-- Forwarded message -
From: Durgamahesh Manne
Date: Mon, Oct 7, 2024 at 10:01 AM
Subject: Inefficient use of index scan on 2nd column of composite index
during concurrent activity
To:
Hi team
Second column of composite index not in use effectively with index scan
when using se
Oh sorry, I should use [reply to all] instead of [reply]. I don't have
much experience with mailing lists...
But why the mailing list haven't use the "Reply-To" header specify where
to reply? Because the mail is you send to me directly?
Thank you.
On 2024/10/11 14:53, Laurenz Albe wrote:
On
(please start a new thread in the future rather than replying to an
existing one)
You cannot query on b and use an index on (a,b) as you observed. However,
you can have two indexes:
index1(a)
index2(b)
Postgres will be able to combine those when needed in the case where your
WHERE clause needs t
On Fri, Oct 11, 2024 at 5:00 PM Greg Sabino Mullane
wrote:
> if we have any column with large string/text values and we want it to be
>> indexed then there is no choice but to go for a hash index. Please correct
>> me if I'm wrong.
>>
>
> There are other strategies / solutions, but we would need
>
> if we have any column with large string/text values and we want it to be
> indexed then there is no choice but to go for a hash index. Please correct
> me if I'm wrong.
>
There are other strategies / solutions, but we would need to learn more
about your use case.
Cheers,
Greg
In the release notes for postgres 17 I'm reading:
> The PostgreSQL foreign data wrapper (postgres_fdw), used to execute
queries on remote PostgreSQL instances, can now push EXISTS and IN
subqueries to the remote server for more efficient processing.
I'm confused as to what this means. In older ve
Hello Team,
I wanted to reach out to provide some insight into a request from my customer
regarding their multiple PostgreSQL Flex instances with PGbouncer. Currently,
they are utilizing an Azure Load Balancer which distributes connections using
the Round-robin mechanism. However, they are now s
22 matches
Mail list logo
