Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

because we experienced a crash on our production server with “toast” issues as result. Thanks in advance, Marc On 8 Feb 2020, at 21:16, Adrian Klaver wrote: On 2/8/20 12:09 PM, Nick Renders wrote: Hi, We have just upgraded our Postgres 9.6 database to 12.1 (pg_dumpall -> pg_restore on a cl

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

evening CET. Thanks in advance, Marc On 8 Feb 2020, at 22:18, Adrian Klaver wrote: On 2/8/20 12:28 PM, Marc wrote: Adrian, Everything was a clean install ( MacOS Mojave and Postgres ) Export and import were done with the latest version of PGAdmin. Please advise if we can provide you with

Re: Unable to startup postgres: Could not read from file "pg_clog/00EC"

a new server with version 12.1 but had to fallback on 11.6 ( see other post ) We kept our “old” server active to see if we can learn some more from this hard-times. Thanks for the help Marc On 5 Feb 2020, at 12:14, Nick Renders wrote: Hello, Yesterday, we experienced some issues with our Pos

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

ruled out. We will keep the 12.1 in place so that we can run additional tests to assist to pin-point the issue. Feel free to ask but allow us to recover from these hectic days ;-) Many thanks for the help ! Marc On 8 Feb 2020, at 21:09, Nick Renders wrote: Hi, We have just upgraded our

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

Hello Tom, To whom do we report our findings regarding this issue ? I can offer you a Belgian waffle to go with you caffeine. Kindest Regards, Marc On 25 Feb 2020, at 10:35, Nick Renders wrote: Hi Tom, 1. we used the EDB installer. 2. turning JIT off did make the problem go away. So I

Re: solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

Robert, Otherwise mankind would constantly be in pain ;-) Enjoy the weekend ! Marc On 24 Jan 2021, at 8:13, robert rottermann wrote: thanks a lot. why dos such stupidity not hurt. ? have a nice weekend robert On 24.01.21 08:04, Julien Rouhaud wrote: On Sun, Jan 24, 2021 at 2:58 PM

Re: PG12: Any drawback of increasing wal_keep_segments

S and bandwidth available, of course, but it's not free. Thanks, Stephen Hello Stephen, How do you see a setup with a ‘a dedicated repo that replicas can pull from’ ? Thanks in advance for the clarification. Marc

pgBackRest on MacOS

Has anybody pgbackrest running on MacOS ( Monterey ? ) If yes are you willing to share the how to ? Or can anybody guide us to an “easy” how to ? Many thanks in advance, Marc

Re: Autovacuum on sys tables

This is a test. Apologies but 19/12 we are no longer receiving the list mails

how to troubleshoot: FATAL: canceling authentication due to timeout

prevents this user to do the first authentication step, but no idea how to find it. I’ve tried common queries to find locks but I can’t see anything relevant. I would appreciate if someone could point me to the right direction! Thanks a lot! Marc.

Re: how to troubleshoot: FATAL: canceling authentication due to timeout

ppens again. Thanks! On Wed, 17 Mar 2021, 22:32 Diego, wrote: > hi! > > What you see in the log files of CentOS ( /var/log ) ? > i > > > On 17/03/2021 16:00, Marc wrote: > > hi all, > > We are facing a problem with a user login into database. It happens when >

Re: Incremental Materialized Views

> workload, even when limited to relatively simple queries. It's quite > exciting. > > Regards > Oliver > www.agilebase.co.uk Oliver, According to this info maybe version 15 https://commitfest.postgresql.org/23/2138/ Regards, Marc

pg_dump - increase in backup time - log

this lacks a date time stamp. No changes on the server neither. Postgres: version 11.13 pg_dump is running on the same machine as Postgres and no changes have been made to the configuration Any ideas/help most welcome, Thanks in advance, Marc ARC - your Apple service partner

Extract transactions from wals ??

0900','MMDD HH24MI'); to get most things done after the problem. As we are currently moving out of Oracle, we must prove to the business people that our new postgres env is fine. So, ... any idea ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: Extract transactions from wals ??

in a given timeframe. Quite clearly, an option, for the future, would be to modify ALL tables and add a timestamp column and a trigger to fill/update it. a tad boring to do... This is why I was wondering if it exits another possibility, like getting, from the wals, a list of modify objects. so ?? r

Re: Extract transaction from WAL

and the db "corrupted" we can try to create a dblink from one to the other and, then try to extract the "differences". but this is not always possible. hence the question about wals. or ? regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, Nov 21, 2019 at

Re: Extract transactions from wals ??

to script a kind of "diff" between the 2 to get what I want. Yes ? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, Nov 21, 2019 at 5:16 PM Laurenz Albe wrote: > On Thu, 2019-11-21 at 17:07 +0100, Marc Millas wrote: > > you say "extract the data you need&q

Re: Extract transactions from wals ??

, and elements about what was written. OS files written and position should be enough to provide this. Something ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Fri, Nov 22, 2019 at 11:02 AM Ganesh Korde wrote: > I think he wants to see data from different tables at d

install postgres

Hi, I may overlook something obvious.. I am just looking, on the download pages of postgresql.org for a way to download rpm.(for redhat 6 and redhat 7 x64 machines) NOT the noarch, but the full distro. Reason is I have to install postgres on a network with NO internet access. Thanks, Marc

policies and extensions

? __ Marc

Re: policies and extensions

On Mon, 2020-02-17 at 22:48 -0500, Tom Lane wrote: > Marc Munro writes: > > > An RLS policy is a table "subsidiary object" so it only depends > indirectly > on the extension that owns the table. Yep, I get that, and I see the dependency chain in the catalog.  How

Re: policies and extensions

documentation but again I am not advocating. Thanks again. __ Marc

GPG signing

f the many different gpg-ish packages I should choose. Any other options? Am I missing something? Thanks. __ Marc

Re: GPG signing

On Tue, 2020-05-26 at 12:04 -0700, Adrian Klaver wrote: > On 5/26/20 12:01 PM, Marc Munro wrote: > > I need to be able to cryptographically sign objects in my database > > using a public key scheme. > > [ . . . ] > > Any other options?  Am I missing something? > >

Re: GPG signing

On Wed, 2020-05-27 at 14:42 -0700, Michel Pelletier wrote: > Hi Marc, > > You can sign content with pgsodium: > > https://github.com/michelp/pgsodium Michel, Yay! A modern crypto implementation. And it seems to do most of what I need right out of the box with way less work than

table name

. obviously if I ask: select * from regions-20180101; I get a syntax error. if I try select * from $$regions_20180101$$; I get another syntax error. If I try to rename that table, same thing. if I try a cte, same thing. What should I do ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: table name

damn.. thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, Jun 11, 2020 at 8:55 PM Paul Ramsey wrote: > ALTER TABLE "regions-20180101" rename to regions_20180101; > > > > On Jun 11, 2020, at 11:54 AM, Marc Millas > wrote: > > >

some random() clarification needed

. even weirder (to me !) so, can someone please clarify ? thanks, regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: some random() clarification needed

Ok, thanks for the clarification. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 14, 2020 at 5:24 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Jul 14, 2020 at 8:15 AM Marc Millas > wrote: > >> select id, prenom from prenoms wh

Re: some random() clarification needed

lt partition. thanks, regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 14, 2020 at 5:24 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Jul 14, 2020 at 8:15 AM Marc Millas > wrote: > >> select id, prenom from prenoms wher

how to "explain" some ddl

, something like 12 seconds by partition. We need to understand where that time is spent (check constraints or check within the default partition or...) So, how to ? thanks, regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: how to "explain" some ddl

for a fact table with 40 dimensions ? thanks regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 14, 2020 at 7:05 PM Tom Lane wrote: > Marc Millas writes: > > We would like to understand where an alter table attach partition spend > its > > time. >

Re: how to "explain" some ddl

Hi Tom, a few tests later. Looks like when you add a partition as default, all tupples of it are read, even if there is an index on the column that is the partition key. this do explain our attach time. We are going to clean the default partition... regards, Marc MILLAS Senior Architect

Re: some random() clarification needed

Thanks! makes it clearer :-) its not that obvious to guess the consequences of the "volatile" behaviour. regards, Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Jul 15, 2020 at 1:53 AM David Rowley wrote: > On Wed, 15 Jul 2020 at 04:01, Marc Millas wrote: &g

ransomware

ould somehow "hang" there are various ways to do those checks but I was wandering if any ""standard''" solution exist within postgres ecosystem, or someone do have any feedback on the topic. thanks for your help Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: ransomware

else ? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Feb 2, 2021 at 2:37 AM Michael Paquier wrote: > On Mon, Feb 01, 2021 at 03:38:35PM +0100, Marc Millas wrote: > > there are various ways to do those checks but I was wandering if any > > ""standard

prepare in a do loop

plain ? thanks (its a french db, so error message in french :-) Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: prepare in a do loop

y for use in embedded SQL. This version of the PREPARE statement also uses a somewhat different syntax. ??? where is the difference for the prepare context thing (I dont mean the different syntax part) ?? thanks for clarification Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Fe

postgis

Hi, I would like to install postgis 3.04 on a debian 11. digging into various web sites, I didnt found the name of that packet. can someone help ? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: postgis

Hi, postgres 12. I may use whatever repo. I install postgres from postgresql.org... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Jul 18, 2022 at 7:15 PM Adrian Klaver wrote: > On 7/18/22 10:08, Marc Millas wrote: > > Hi, > > > > I would like to in

Re: postgis

ed via apt. what am I missing ?? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 12:09 AM Adrian Klaver wrote: > On 7/18/22 11:48, Marc Millas wrote: > > Hi, > > postgres 12. > > I may use whatever repo. > > > > I install pos

Re: postgis

just... nothing ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 6:36 PM Adrian Klaver wrote: > On 7/19/22 9:01 AM, Marc Millas wrote: > > Thanks Adrian > > > > still, I see a bunch of files, and nothing that can be installed via > &g

Re: postgis

It is. I do begin with the postgres site script: sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' so... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 a

Re: postgis

Hi, from your message, I understand that for debian 11, I can NOT get any 3.0.x version. right ? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 7:20 PM Imre Samu wrote: > > I would like to install postgis 3.04 on a debian 11 > > postgres 12. &

Re: postgis

I did run each step of the script and did install a postgres 12.11. then destroyed the instance created by the script, and, then pg_createcluster a new one, which is running fine. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 8:42 PM Adrian Klaver wrote

Re: postgis

Postgres installed, but not postgis.. which is why I need some help... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jul 19, 2022 at 11:43 PM Adrian Klaver wrote: > On 7/19/22 2:09 PM, Marc Millas wrote: > > I did run each step of the script and did install a

Re: postgis

??? I did describe precisely what I did: On 7/19/22 2:09 PM, Marc Millas wrote: > > I did run each step of the script and did install a postgres 12.11. > > then destroyed the instance created by the script, and, then > > pg_createcluster a new one, which is running fine.

Re: postgis

nfo on the debian postgis page I was able to find is the name of a package: postgres-12-postgis-3 which do install a postgis 3.2.1 not a postgis 3.0.x Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Jul 20, 2022 at 3:52 PM Ron wrote: > This long drama is about *

Re: postgis

Thanks for your answer. I would like to avoid compiling as much as possible. I know that postgis 3.2.1 is available and does install without pb. but.. That db run an app which is very long to test, so I need to stick to a postgis 3.0.x regards, Marc MILLAS Senior Architect +33607850334

Re: postgis

right. so I scratch the debian vm, install a centos 7 and within minutes I have a postgres 12 with postgis 3.0.4 running. so easy. regards. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Jul 20, 2022 at 7:27 PM Imre Samu wrote: > > I would expect the 35 packages impl

limits, indexes, views and query planner

to exclude the table_b earlier in its plan and to possibly fallback to a plan equivalent to the first one. with a view on a single table (test_av), the index is used. An oddity in the plan is the expected row count in "Append"(11) ... ( tested on postgres 14 ) Regards, Marc Mami

impact join syntax ?? and gist index ??

missing something.. (at least 2 things...) can someone shed some light ?? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: impact join syntax ?? and gist index ??

Yes, I know the 2 syntax provide a different result: one provides the 6 meaningful lines, the left join do add 5 lines with a count of 0... ... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sat, Jan 7, 2023 at 8:46 PM Marc Millas wrote: > Hi, > > postgres 12, postgis

Re: impact join syntax ?? and gist index ??

discussion about the versions my project will use :-) Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sat, Jan 7, 2023 at 8:46 PM Marc Millas wrote: > Hi, > > postgres 12, postgis 3.0 > > I have a small table A, 11 rows with a varchar column x and a geometry >

Re: impact join syntax ?? and gist index ??

Index Cond: (geom ~ B.geom) Filter: st_within(B.geom, geom) Rows Removed by Filter: 0 Buffers: shared hit=2112857 Planning Time: 0.252 ms Execution Time: 11863.357 ms (26 lignes) Marc MILLAS Senior Architect +3360785033

Re: impact join syntax ?? and gist index ??

I read your answer, Tom, but I cannot connect it to my measurements: why adding the index did slow the request twice ?? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sat, Jan 7, 2023 at 10:33 PM Tom Lane wrote: > Marc Millas writes: > > 2023=# explain (analyze, buffer

alter table impact on view

lighten me? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: alter table impact on view

A bit sad Thanks.. Le lun. 30 janv. 2023 à 13:53, David Rowley a écrit : > On Tue, 31 Jan 2023 at 01:14, Marc Millas wrote: > > But if I alter table to change a column that is a varchar 20 into a > varchar 21 > > postgres refuse saying that it cannot due to the return ru

Re: Best Open Source OS for Postgresql

all cross possibilities (ie. 5 postgres x 6 postgis, less some impossibilities according to postgis matrix) so... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Jan 31, 2023 at 1:23 PM hubert depesz lubaczewski wrote: > On Tue, Jan 31, 2023 at 01:18:08PM +0100, Marc Millas w

Re: Best Open Source OS for Postgresql

Hello, What about postgis : 3.0, 3.3, 3.4 ?? Le mer. 1 févr. 2023 à 07:20, Tony Shelver a écrit : > > Copied to the list > On Wed, 1 Feb 2023 at 08:18, Tony Shelver wrote: > >> >> >> On Wed, 1 Feb 2023 at 08:04, Tony Shelver wrote: >> >>>

Re: Best Open Source OS for Postgresql

the whole thing with all associated libs ... Thanks Which was my customer requirelent Le mar. 31 janv. 2023 à 17:38, Adrian Klaver a écrit : > On 1/31/23 05:09, Marc Millas wrote: > > Sorry for inappropriate "reply". > > > > if you do check the debian postgis

Re: Postgres undeterministically uses a bad plan, how to convince it otherwise?

hings, one may get stupid results...it was an "expert only" functionality :-) Still, in some cases, it was very useful to manage the rare cases where the planner cannot, for whatever reason do a good job. OK its not the way postgres do behave. Still, in some cases... Marc M

pg_reload_conf()

sly, if I stop and restart the DB, select setting, boot_val, reset_val from pg_settings where name='log_connections'; on off on So, I am perplexed: what pg_reload_conf() is doing/not doing ? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: pg_reload_conf()

Thanks Adrian, the fact that the changes are visible only by the new backend, and NOT by the backend which did the changes was what I did missed. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Feb 20, 2023 at 6:01 PM Adrian Klaver wrote: > On 2/20/23 08:57, Marc Mil

Re: Oracle to PostgreSQL Migration

EDB do have a replication server which can be used to transfer real time data from oracle to postgres. don't know if it can be used to get to "no downtime" BTW what do you call "no downtime" as anyway a switch, as fast as it can be do take ""some"

SIze 0 in pg_stat_file, pg_stat_progress_copy

files --and when running a copy from the current logfile with a where clause to choose only the current day logs, the bytes total column is 0 what can provides such a behaviour ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: SIze 0 in pg_stat_file, pg_stat_progress_copy

Sorry... someone did setup the log as a named pipe... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Fri, Apr 14, 2023 at 4:26 PM Marc Millas wrote: > Hi, > > on a debian machine, with a postgres 14,2 server > > logs in a dedicated directory (not log) > when l

missing something about json syntax

l' from mytable, or select _data->'level' from anothertable sure if I look at the json field one is showed { "tag": "value", ... and the other is showed "{\"tag\":\"value\", ... not the very same so 2 questions: 1) how postgres can feed a json or jsonb column and CANNOT use the values in it ?? 2) how to "transform" the inappropriate json into a usable one ? of course, if what I am missing is very obvious, I apologize... Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: missing something about json syntax

can be considered a valid enough json to be inserted in a json column and at the same time invalid for all other json uses. just like if postgres was allowing to insert things that are not of the column type it's the first time I do encounter this kind of behaviour from postgres Marc MILLAS

Re: missing something about json syntax

Ok, thanks. Le jeu. 20 avr. 2023 à 22:42, Tom Lane a écrit : > Marc Millas writes: > > but it doesnt explain how postgres is able to put a scalar in a json or > > jsonb column without pb: > > I don't understand how this ('"{\"t\"}"') can

Death postgres

, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: Death postgres

Le sam. 6 mai 2023 à 09:46, Peter J. Holzer a écrit : > On 2023-05-06 03:14:20 +0200, Marc Millas wrote: > > postgres 14.2 on Linux redhat > > > > temp_file_limit set around 210 GB. > > > > a select request with 2 left join have crashed the server (oom kill

Re: Death postgres

Le sam. 6 mai 2023 à 06:18, Adrian Klaver a écrit : > On 5/5/23 18:14, Marc Millas wrote: > > Hi, > > > > postgres 14.2 on Linux redhat > > > > temp_file_limit set around 210 GB. > > > > a select request with 2 left join have crashed the server (oom k

Re: Death postgres

Le sam. 6 mai 2023 à 15:15, Ron a écrit : > On 5/6/23 07:19, Marc Millas wrote: > > > > Le sam. 6 mai 2023 à 09:46, Peter J. Holzer a écrit : > >> On 2023-05-06 03:14:20 +0200, Marc Millas wrote: >> > postgres 14.2 on Linux redhat >> > >> > te

Re: Death postgres

Le sam. 6 mai 2023 à 15:15, Ron a écrit : > On 5/6/23 07:19, Marc Millas wrote: > > > > Le sam. 6 mai 2023 à 09:46, Peter J. Holzer a écrit : > >> On 2023-05-06 03:14:20 +0200, Marc Millas wrote: >> > postgres 14.2 on Linux redhat >> > >> > te

Re: Death postgres

Le sam. 6 mai 2023 à 18:11, Adrian Klaver a écrit : > On 5/6/23 05:25, Marc Millas wrote: > > > > > > Le sam. 6 mai 2023 à 06:18, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> a écrit : > > > > On 5/5/23 18:14, Marc Millas wrote: > >

Re: Death postgres

Le sam. 6 mai 2023 à 21:46, Adrian Klaver a écrit : > On 5/6/23 10:13, Marc Millas wrote: > > > > > > > When you restarted the server where there any warnings shown? > > > > Sadly, I cannot. Will be done next tuesday. > > Cannot do what: > >

Re: Death postgres

On Sun, May 7, 2023 at 8:42 PM Laurenz Albe wrote: > On Sat, 2023-05-06 at 03:14 +0200, Marc Millas wrote: > > postgres 14.2 on Linux redhat > > > > temp_file_limit set around 210 GB. > > > > a select request with 2 left join have crashed the server (oom kill

Re: Death postgres

On Wed, May 10, 2023 at 7:24 PM Peter J. Holzer wrote: > On 2023-05-10 16:35:04 +0200, Marc Millas wrote: > > Unique (cost=72377463163.02..201012533981.80 rows=1021522829864 > width=97) > >-> Gather Merge (cost=72377463163.02..195904919832.48 > row

Re: Death postgres

On Thu, May 11, 2023 at 1:56 AM Peter J. Holzer wrote: > On 2023-05-10 22:52:47 +0200, Marc Millas wrote: > > On Wed, May 10, 2023 at 7:24 PM Peter J. Holzer > wrote: > > > > On 2023-05-10 16:35:04 +0200, Marc Millas wrote: > > > Unique (cost=723

order by

archar (?!?) between those 2 clusters. What can I check to to explain this difference as, to my understanding, it's not a postgresql.conf parameter. thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

gather merge

Hi, another new thread related to "death postgres": how to stop Gather Merge from going parallel ? ie. not forcing parallel to one thread as limitating max_parallel_workers (per_gatherer) thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: order by

Thanks, I do know about index options. that table have NO (zero) indexes. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, May 11, 2023 at 4:48 PM Adam Scott wrote: > Check the index creation has NULLS FIRST (or LAST) on both indexes that > are used. Use explain to se

Re: order by

On Thu, May 11, 2023 at 4:43 PM Adrian Klaver wrote: > On 5/11/23 07:29, Marc Millas wrote: > > Hi, > > > > I keep on investigating on the "death postgres" subject > > but open a new thread as I don't know if it's related to my pb. > > >

Re: order by

On Thu, May 11, 2023 at 5:23 PM Adrian Klaver wrote: > On 5/11/23 08:00, Marc Millas wrote: > > > > On Thu, May 11, 2023 at 4:43 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: > > > > On 5/11/23 07:29, Marc Millas wrote: > &g

Re: gather merge

so, I put max_parallel_workers_per_gather to 0, and it does work, no more parallel execution. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, May 11, 2023 at 4:38 PM Marc Millas wrote: > Hi, > > another new thread related to "death postgres": > how to

Re: Death postgres

On Thu, May 11, 2023 at 1:56 AM Peter J. Holzer wrote: > On 2023-05-10 22:52:47 +0200, Marc Millas wrote: > > On Wed, May 10, 2023 at 7:24 PM Peter J. Holzer > wrote: > > > > On 2023-05-10 16:35:04 +0200, Marc Millas wrote: > > > Unique (cost=723

Re: Death postgres

On Fri, May 12, 2023 at 8:31 AM Peter J. Holzer wrote: > On 2023-05-11 21:27:57 +0200, Marc Millas wrote: > > the 75 lines in each tables are not NULLs but '' empty varchar, > which, > > obviously is not the same thing. > > and which perfectly generates 50

Re: order by

On Thu, May 11, 2023 at 11:08 PM Ron wrote: > On 5/11/23 09:55, Marc Millas wrote: > > Thanks, > > I do know about index options. > > that table have NO (zero) indexes. > > > If the table has no indices, then why did you write "it looks like there > is

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

Oracle have One (1) DB per instance (in Oracle its not named a cluster as...there is only one !). So ... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, May 18, 2023 at 9:30 PM Adrian Klaver wrote: > On 5/18/23 11:56, Ron wrote: > > On 5/18/23 12:54, Rob Sarg

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

?? the sqlite thing ?? Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sun, May 21, 2023 at 7:15 PM Theodore M Rolle, Jr. wrote: > What about sqlcipher? > > On Sun, May 21, 2023, 07:16 Marc Millas wrote: > >> Oracle have One (1) DB per instance (in Oracle its n

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

Hi Thomas, to my understanding, there is ONE master key for TDE in 12c. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sun, May 21, 2023 at 9:47 PM Thomas Kellerer wrote: > > Marc Millas schrieb am 21.05.2023 um 13:13: > > Oracle have One (1) DB per instance (in Or

syntax pb

of type numeric but expression is of type text LINE 2: Select distinct test1.t, 'abc' as b, NULL as c, NULL as d HINT: You will need to rewrite or cast the expression. Can someone give a short SQL syntax hint ? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: syntax pb

ge, BTW) generates absurd errors. Too my understanding it looks like the parser did not parse the select distinct as we think he does. > >> Marc MILLAS > >> Senior Architect > >> +33607850334 > >> www.mokadb.com <http://www.mokadb.com> > >> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >

Re: syntax pb

Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, May 30, 2023 at 3:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, May 30, 2023, Marc Millas wrote: > >> >> I get: >> ERROR: column "d" is of type numeric

Re: syntax pb

Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, May 30, 2023 at 7:12 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, May 30, 2023 at 8:53 AM Marc Millas wrote > > >> This comes from a prod environment and even casting NULLs (which is

Re: syntax pb

Thanks for the explanation. Crystal clear, thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, May 30, 2023 at 7:31 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, May 30, 2023 at 8:53 AM Marc Millas > wrote > >> Too my

Re: Hash Index on Partitioned Table

y' parameter in create index doc). doing this it was easy to somewhat optimize the process according to number of available core/RAM/storage. hf Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, May 31, 2023 at 7:53 PM peter.boris...@kartographia.com < peter.boris...@

date format

load as char and then apply an appropriate transformation. no pb. But is there a direct way to do this ? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: date format

On Wed, Jun 14, 2023 at 7:27 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jun 14, 2023 at 9:42 AM Marc Millas > wrote: > >> Hi, >> >> I would like to load data from a file via file_fdw or COPY.. its a >> postgres 14 cluster >

  1   2   >