On Thu, 2025-09-25 at 15:38 +, Roberto Gallesio wrote:
> we would need to know if the OS "WINDOWS Server 2025 Datacenter" is supported
> to install PostgreSQL 17.x
>
> but we need a confirmation to be sure we have understand the information
> correctly.
Windows 2025 is supported. That mean
Hi Samuel
Using ON CONFLICT is a headache.
It's better to use the versatility of a Trigger: you have the full record
at your fingertips, and if you're going to UPDATE, you have the previous
record too.
There's much more control.
Also, you can always count on the beloved foreign keys, which are al
On 9/25/25 11:49, Bryan Sayer wrote:
Hi,
I'm not sure if this is the best list to ask this (and I am very new to
PostgreSQL) but I think more options are needed in the COPY from
command, in order to better deal with exceptions. By exceptions I mean
data not consistent with the format, empty r
On Thursday, September 25, 2025, Bryan Sayer wrote:
> Is there someone or a party that deals with the details of the COPY
> command that I could discuss this with?
>
This mailing list is the primary medium that reaches a large number of
people some of whom may wish to join in your discussion. J
As I understand it, COPY is intended as a simple & fast way to get clean data
into Postgres.
It is not intended to groom data during the process. There are a variety of ETL
tools that can apply filters & rules to data streams to do what you are asking,
so no need to invent another Postgres speci
On Thu, Sep 25, 2025 at 3:49 PM Bryan Sayer wrote:
> Hi,
>
> I'm not sure if this is the best list to ask this (and I am very new to
> PostgreSQL) but I think more options are needed in the COPY from command,
> in order to better deal with exceptions. By exceptions I mean data not
> consistent wi
Hi,
I'm not sure if this is the best list to ask this (and I am very new to
PostgreSQL) but I think more options are needed in the COPY from
command, in order to better deal with exceptions. By exceptions I mean
data not consistent with the format, empty rows, extra delimiters at the
end of r
On 9/25/25 08:38, Roberto Gallesio wrote:
Hi all,
we would need to know if the OS "WINDOWS Server 2025 Datacenter" is
supported to install PostgreSQL 17.x
We have see, on www.postgresql.org/download, the following :
but we need a confirmation to be sure we have understand the information
co
On 9/25/25 04:36, Ashish Mukherjee wrote:
Hello,
I recently upgraded from pgsql 12 to pgsql 17. It's a Percona TDE
enabled database. However, after the upgrade the query planning time has
shot up by 10x when I check explain analyze output.
Did the Postgres 12 instance have the Percona TDE ex
Hi all,
we would need to know if the OS "WINDOWS Server 2025 Datacenter" is supported
to install PostgreSQL 17.x
We have see, on www.postgresql.org/download, the following :
[cid:e01c7181-b8c8-4344-99dc-b73bd50d84c1]
but we need a confirmation to be sure we have understand the information
corr
Hello,
I recently upgraded from pgsql 12 to pgsql 17. It's a Percona TDE enabled
database. However, after the upgrade the query planning time has shot up by
10x when I check explain analyze output.
The difference in planning time is visible here. The first case is pgsql 17
with TDE. The second ca
11 matches
Mail list logo
