Moving to Postgresql database

Hello Experts, If some teams are well versed with the Oracle database architecture and its optimizers working and designing applications on top of this. Now moving same team to work on AWS aurora postgresql databases design/development projects. Is any key design/architectural changes should the

Re: Why scan all columns when we select distinct c1?

Thanks for the explanation. Tom Lane 于2024年1月14日周日 23:46写道： > Ron Johnson writes: > > On Sun, Jan 14, 2024 at 6:18 AM Yongtao Huang > > wrote: > >> gpadmin=# create table t1 (c1 int, c2 text); > >> CREATE TABLE > >> gpadmin=# explain (costs off, verbose) select distinct c1 from t1; > >> QUERY

Re: Help with "Create Extension unaccent"

On 1/13/24 21:52, Lan Xu wrote: With CREATE EXTENSION unaccent, I’m getting the following: ERROR: extension "unaccent" has no installation script nor update path for version “1.0" But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql Thank you for your help! What OS and

Re: Why scan all columns when we select distinct c1?

Ron Johnson writes: > On Sun, Jan 14, 2024 at 6:18 AM Yongtao Huang > wrote: >> gpadmin=# create table t1 (c1 int, c2 text); >> CREATE TABLE >> gpadmin=# explain (costs off, verbose) select distinct c1 from t1; >> QUERY PLAN >> - >> HashAggregate >> Output: c1 >>

Re: Why scan all columns when we select distinct c1?

Am 14.01.24 um 12:17 schrieb Yongtao Huang: My question is why scan all columns in PG 16.01? If `select distinct c1`, scan the column `c1` is enough, like PG 9.4. good question, I think because the seq scan always reads the column. If you create an index on c1, this changes: postgres=#

Re: Why scan all columns when we select distinct c1?

On Sun, Jan 14, 2024 at 6:18 AM Yongtao Huang wrote: > PostgreSQL version: 16.1 > Operating system: centos7 > Description: > > Let me show these explain results first, in PG9.4 and PG16.1. > > ### Behavior in PG9.4 > ``` SQL > gpadmin=# create table t1 (c1 int, c2 text); > CREATE TABLE >

Re: Software Bill of Materials (SBOM)

Hi Cristina, Have you tried SCANOSS? To install: pip3 install scanoss To generate your SBOM (SPDX lite): scanoss-py scan --format spdxlite DIRECTORY/ Alternatively, in CycloneDX format instead: scanoss-py scan --format cyclonedx DIRECTORY/ Hope this helps. Regards, Julian From: Кристина

Re: Support for arm64 windows is absent - Would be nice to have!

Thank you Dominique For CI and build I think the following could be suitable [azure-icon-250x250.png] General availability: Arm-based VMs now available in four additional

Re: Issue with loading unicode characters with copy command

Its UTF-8. Also verified the load file and its utf-8. Regards, Kiran On Fri, Jan 12, 2024 at 10:48 PM Adrian Klaver wrote: > On 1/12/24 07:23, Kiran K V wrote: > > Hi, > > > > > > I have a UTF8 database and simple table with two columns (integer and > > varchar). Created a csv file with some

Why scan all columns when we select distinct c1?

PostgreSQL version: 16.1 Operating system: centos7 Description: Let me show these explain results first, in PG9.4 and PG16.1. ### Behavior in PG9.4 ``` SQL gpadmin=# create table t1 (c1 int, c2 text); CREATE TABLE gpadmin=# explain (costs off, verbose) select distinct c1 from t1;

Re: Help with "Create Extension unaccent"

2024年1月14日(日) 14:53 Lan Xu : > > With CREATE EXTENSION unaccent, I’m getting the following: > ERROR: extension "unaccent" has no installation script nor update path for > version “1.0" > > But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql For recent PostgreSQL versions, the