Re: [VOTE] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-08 Thread Ron Liu
there is an objection or not enough votes. [1] https://cwiki.apache.org/confluence/display/FLINK/FLIP-448%3A+Introduce+Pluggable+Workflow+Scheduler+Interface+for+Materialized+Table [2] https://lists.apache.org/thread/57xfo6p25rbrhcg01dhyok46zt6jc5q1 Best, Ron Ron Liu 于2024年5月9日周四 13:52写道: > Hi Dev, Thank

[VOTE] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-08 Thread Ron Liu
/confluence/display/FLINK/FLIP-448%3A+Introduce+Pluggable+Workflow+Scheduler+Interface+for+Materialized+Table [2] https://lists.apache.org/thread/57xfo6p25rbrhcg01dhyok46zt6jc5q1 Best, Ron

Attempting to Activate Account with Gmail Address

2024-05-08 Thread Ron Gordon
Per Post Edit Apr-2024 by TerryE, I am warning the forum through the “AOO dev mailing list" that I have applied for an account. Unfortunately, I have a gmail address. My proposed User ID is RGordon3503 AOO Ver 4.1.15 on MacOS 14.4.1 Thank you, Ron Gordon rucanoe...@gmail.com

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-08 Thread Ron Liu
Hi, Dev Thank you all for joining this thread and giving your comments and suggestions, they have helped improve this proposal and I look forward to further feedback. If there are no further comments, I'd like to close the discussion and start the voting one day later. Best, Ron Ron Liu 于2024年

Forcing INTERVAL days display, even if the interval is less than one day

2024-05-07 Thread Ron Johnson
PG 9.6.24, if relevant. (Hopefully we're migrating next month.) Displaying how long ago a date was is easy, but interval casts "helpfully" suppress "X days ago" if the interval is less than one day ago. How do I make it display "days ago", even when days ago is zero? Explicitly casting "day to

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-07 Thread Ron Liu
/blob/29736b8c01924b7da03d4bcbfd9c812a8e5a08b4/flink-table/flink-table-api-java/src/main/java/org/apache/flink/table/operations/Operation.java Best, Ron Ron Liu 于2024年5月7日周二 14:30写道: > > 4. It appears that in the section on `public interfaces`, within > `Workflow

(flink) 01/08: [FLINK-35195][test/test-filesystem] test-filesystem Catalog support create generic table

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 84f0632b15c2a192aa22a525c7b4937f80f20a34 Author: fengli AuthorDate: Tue Apr 30 16:23:25 2024 +0800 [FLINK-35195][test

(flink) 06/08: [FLINK-35195][table] Introduce MaterializedTableChange to support update materialized table refresh status and RefreshHandler

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 192e1e8fb04c3a8c88673fde1b66dd359b5b0fe0 Author: fengli AuthorDate: Mon May 6 20:21:09 2024 +0800 [FLINK-35195][table

(flink) 07/08: [FLINK-35195][table] Introduce DropMaterializedTableOperation to support drop materialized table

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit e0d342a2a6ba320c1fe0f7a42239254d25f95fd5 Author: fengli AuthorDate: Mon May 6 20:22:19 2024 +0800 [FLINK-35195][table

(flink) 05/08: [FLINK-35195][table] Introduce ContinuousRefreshHandler and serializer for continuous refresh mode

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit c99eb54ce8f362d970c173a2a579e8fc28ac Author: fengli AuthorDate: Mon May 6 20:19:49 2024 +0800 [FLINK-35195][table

(flink) 08/08: [FLINK-35195][table] Support execute CreateMaterializedTableOperation for continuous refresh mode in SqlGateway

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 29736b8c01924b7da03d4bcbfd9c812a8e5a08b4 Author: fengli AuthorDate: Mon May 6 20:24:16 2024 +0800 [FLINK-35195][table

(flink) 04/08: [FLINK-35195][table] Convert SqlCreateMaterializedTable node to CreateMaterializedTableOperation

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit e28e495cdd3e0e7cbb58685cb09e1fa08af7223e Author: fengli AuthorDate: Mon May 6 20:17:57 2024 +0800 [FLINK-35195][table

(flink) 03/08: [FLINK-35195][table] Convert CatalogMaterializedTable to CatalogTable to generate execution plan for planner

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit d8491c0f9c07f0d3d5e1428cad54902acb6ae0d0 Author: fengli AuthorDate: Mon May 6 20:12:54 2024 +0800 [FLINK-35195][table

(flink) 02/08: [FLINK-35195][table] Introduce materialized table reflated config options

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit b037f56b10c7dce4505ed6f4e28030350742a523 Author: fengli AuthorDate: Mon May 6 20:07:09 2024 +0800 [FLINK-35195][table

(flink) branch master updated (ea4112aefa7 -> 29736b8c019)

2024-05-07 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/flink.git from ea4112aefa7 [FLINK-35161][state] Implement StateExecutor for ForStStateBackend new 84f0632b15c [FLINK-35195][test

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-07 Thread Ron Liu
ter and the caller. Best, Ron Ron Liu 于2024年5月6日周一 20:48写道: > Hi, Xuyang > > Thanks for joining this discussion > > > 1. In the sequence diagram, it appears that there is a missing step for > obtaining the refresh handler from the catalog during the suspend operation. > >

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-06 Thread Ron Liu
oint. Can you give more description? Best, Ron Xuyang 于2024年5月6日周一 20:26写道: > Hi, Ron. > > Thanks for driving this. After reading the entire flip, I have the > following questions: > > > > > 1. In the sequence diagram, it appears that there is a missing step for > obt

(flink) branch release-1.17 updated: [FLINK-34379][table] Fix OutOfMemoryError with large queries

2024-05-05 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch release-1.17 in repository https://gitbox.apache.org/repos/asf/flink.git The following commit(s) were added to refs/heads/release-1.17 by this push: new d2f93a5527b [FLINK-34379][table] Fix

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-05-04 Thread Ron Liu
provide the necessary information without the need to provide a new interface. I've updated the public interface section of FLIP. Best, Ron Lincoln Lee 于2024年4月30日周二 21:27写道: > Thanks Ron for starting this flip! It will complete the user story for > flip-435[1]. > > Regarding the Workflow

Re: [External] : Re: New candidate JEP: 471: Deprecate the Memory-Access Methods in sun.misc.Unsafe for Removal

2024-05-03 Thread Ron Pressler
* could be tricky as the GC relocates arrays, so an array element that’s at the start of a cache line at time t0 might not be at the start of a cache line at time t1 — but that’s unrelated to this JEP. What is related to this JEP is that you’re using Unsafe to determine the size of an oop (in particular, to tell if oops are compressed or no)t. Is that what you’re asking for? — Ron

Re: Freelance Opportunity : Django Developer for building A Dialer

2024-05-03 Thread Raunak Ron
I am Interested. On Monday 29 April 2024 at 19:45:53 UTC+5:30 Pankaj Saini wrote: > I am interested in this position. > > I have an experience in Django Development with strong Python. > > On Tue, Apr 2, 2024, 10:49 PM Abhishek J > wrote: > >> Dear Developers, >> >> I need to build an android

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

2024-05-02 Thread Ron Johnson
On Thu, May 2, 2024 at 8:28 PM Amit Sharma wrote: > Hello, > > Has anyone tried delta/incremental data migration for Oracle to PostgreSQL > using Ora2pg? Or what are the best options to run delta migration for > Oracle to PostgreSQL? > What do the ora2pg docs say about whether or not that

[jira] [Updated] (SPARK-48091) Using `explode` together with `transform` in the same select statement causes aliases in the transformed column to be ignored

2024-05-02 Thread Ron Serruya (Jira)
[ https://issues.apache.org/jira/browse/SPARK-48091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ron Serruya updated SPARK-48091: Description: When using an `explode` function, and `transform` function in the same select

Re: Prevent users from executing pg_dump against tables

2024-05-02 Thread Ron Johnson
On Thu, May 2, 2024 at 1:47 AM RAJAMOHAN wrote: > Hello all, > > In our production db infrastructure, we have one read_only role which has > read privileges against all tables in schema A. > > We are planning to grant this role to some developers for viewing the > data, but also I want to limit

[jira] [Created] (SPARK-48091) Using `explode` together with `transform` in the same select statement causes aliases in the transformed column to be ignored

2024-05-02 Thread Ron Serruya (Jira)
Ron Serruya created SPARK-48091: --- Summary: Using `explode` together with `transform` in the same select statement causes aliases in the transformed column to be ignored Key: SPARK-48091 URL: https

[PATCH] ash: fix parsing of alias expansion + bash features

2024-05-02 Thread Ron Yorston
28 589+561 __pgetc 607 --607 -- (add/remove: 0/1 grow/shrink: 1/0 up/down: 561/-607) Total: -46 bytes Signed-off-by: Ron Yorston --- shell/ash.c | 12 ++-- 1 file

Re: Linked directory or explicit reference

2024-05-02 Thread Ron Johnson
On Thu, May 2, 2024 at 12:50 AM Senor Cervesa wrote: [snip] > I'm not sure what would trigger "directory not empty". The lost+found directory.

Pgadmin4 for arm64 Linux

2024-05-02 Thread Ron Jewell
I’m running Linux on VMWare installed on my iMac. Is there an arm64 pgadmin4 for Linux? If not could you suggest an alternative? Thanks Ron.

installing Pgadmin4 onto linux using the download pgadmin4-8.5-arm64.dmg

2024-05-01 Thread Ron Jewell
computer running linux. Could someone in support can work up a video on installing arm64 pgadmin4 from an DMG download —not on a Mac --- but onto Linux? The Surely I’m not the only one out there trying to install pgadmin4 from pgadmin4-8.5-arm64.dmg on an arm64 linux OS. Thanks Ron

Re: Posgresql 14 and CarbonBlack on RHEL8?

2024-05-01 Thread Ron Johnson
On Tue, Apr 30, 2024 at 10:07 PM Tom Lane wrote: > Ron Johnson writes: > > When running stress tests on the systems (in prod, during the maintenance > > window), 171K events/second are generated on the RHEL8 servers, and CB > > needs (according to top(1)) 325% of CPU to h

Re: [PATCH v2] fixdep: add fstat error handling

2024-05-01 Thread Ron Yorston
alone that perror displays. > >Ah, a great point. Any preference between just stripping the fprintfs vs >a better argument to perror, as we do in some places (but not very >consistently)? Or: fprintf(stderr, "fixdep: fstat %s %s\

Posgresql 14 and CarbonBlack on RHEL8?

2024-04-30 Thread Ron Johnson
(CarbonBlack is cross-platform AV software sold by VMware.) Currently we're running PG 9.6.24 on RHEL 6.10 with CB (version unknown to me) in production, and testing PG 14.11 on RHEL 8.9 with CB 2.15.2 (hopefully going into production next month). Both old and new VMs are 32 CPU with 128GB RAM.

Re: Linked directory or explicit reference

2024-04-30 Thread Ron Johnson
On Tue, Apr 30, 2024 at 7:00 PM Senor Cervesa wrote: > Hi All; > > When doing an initial install of PostgreSQL on RHEL 7 or 8 derived OS via > rpm, what are pros, cons and recommendations of these 2 procedures for > utilizing a second disk? > > Secondary SSD or RAID mounted at /disk2. > > Option

(flink) branch master updated: [FLINK-35194][table] Support describe job statement for SqlGateway

2024-04-30 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git The following commit(s) were added to refs/heads/master by this push: new 44528e0ee9f [FLINK-35194][table] Support describe

(flink) branch master updated: [FLINK-35184][table-runtime] Fix mini-batch join hash collision when use InputSideHasNoUniqueKeyBundle

2024-04-29 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git The following commit(s) were added to refs/heads/master by this push: new f543cc543e9 [FLINK-35184][table-runtime] Fix mini

(flink) branch master updated: [FLINK-35191][table-api] Support alter materialized table related syntax: suspend, resume, refresh, set and reset

2024-04-29 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git The following commit(s) were added to refs/heads/master by this push: new 330f524d185 [FLINK-35191][table-api] Support alter

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-04-28 Thread Ron Liu
ache/flink/blob/b1544e4e513d2b75b350c20dbb1c17a8232c22fd/flink-table/flink-table-api-java/src/main/java/org/apache/flink/table/catalog/listener/CatalogModificationListener.java#L31 Best, Ron Ron Liu 于2024年4月28日周日 23:53写道: > Hi, Shengkai > > Thanks for your feedback and suggestion, it looks very useful for this > proposal

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-04-28 Thread Ron Liu
lated needs of materialized table. Based on your feedback, I have optimized and updated the FLIP related section. Best, Ron Shengkai Fang 于2024年4月28日周日 15:47写道: > Hi, Liu. > > Thanks for your proposal. I have some questions about the FLIP: > > *WorkflowScheduler* > > 1. How to g

(flink) 03/03: [FLINK-35189][test-utils] Introduce test-filesystem connector and catalog based on filesystem to support materialized table

2024-04-26 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 714d1cb2e0bd0df03393492dc87cbd800af63e1b Author: fengli AuthorDate: Wed Apr 24 18:18:47 2024 +0800 [FLINK-35189][test

(flink) branch master updated (f64654e9749 -> 714d1cb2e0b)

2024-04-26 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/flink.git from f64654e9749 add HTTP options to java-storage client new 00d69e53fe7 [FLINK-35189][table-common

(flink) 02/03: [FLINK-35189][connectors/filesystem] Modify the visibility of filesystem connector related methods to protected

2024-04-26 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit e3cda01cac737c97a104feae0e35da1eb91a8751 Author: fengli AuthorDate: Wed Apr 24 18:14:53 2024 +0800 [FLINK-35189

(flink) 01/03: [FLINK-35189][table-common] CatalogPropertiesUtil support serialize and deserialize materialized table

2024-04-26 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 00d69e53fe7b263293608f0a949525441b82e09e Author: fengli AuthorDate: Wed Apr 24 18:11:03 2024 +0800 [FLINK-35189][table

Re: [VOTE] FLIP-445: Support dynamic parallelism inference for HiveSource

2024-04-25 Thread Ron Liu
+1(binding) Best, Ron Rui Fan <1996fan...@gmail.com> 于2024年4月26日周五 12:55写道: > +1(binding) > > Best, > Rui > > On Fri, Apr 26, 2024 at 10:26 AM Muhammet Orazov > wrote: > > > Hey Xia, > > > > +1 (non-binding) > > > > Thanks and b

(flink) branch master updated: [FLINK-35190][table-api] Support create materialized table syntax

2024-04-25 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git The following commit(s) were added to refs/heads/master by this push: new 512f3fbaac8 [FLINK-35190][table-api] Support create

Re: best migration solution

2024-04-25 Thread Ron Johnson
On Thu, Apr 25, 2024 at 3:55 AM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > we have to migrate from hosted PG12 to containerized PG16 on private > cloud. > > > > some of the installed PG12 extensions are not offered on the containerized > PG16, eg. PostGIS related extensions like

Re: [DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-04-25 Thread Ron Liu
e background? So I don't think it is necessary. [1] https://cwiki.apache.org/confluence/display/FLINK/FLIP-435%3A+Introduce+a+New+Materialized+Table+for+Simplifying+Data+Pipelines Best, Ron Feng Jin 于2024年4月25日周四 00:46写道: > Hi Ron > > Thank you for initiating this FLIP. > > My

Re: [Dwarf-discuss] Proposal: Error: Duplicate DW_AT_LNAME 1d

2024-04-24 Thread Ron Brender via Dwarf-discuss
ust leave well-enough alone. I just updated the document to match the website (and make DW_LNAME_HIP = 0x0029). So any change causes work for me. Similarly it creates work for anyone who is actually trying to use code DW_LNAME_Assembly. Why bother? Ron On Wed, Apr 24, 2024 at 12:25 PM Car

Re: [Dwarf-discuss] Proposal: Error: Duplicate DW_AT_LNAME 1d

2024-04-24 Thread Ron Brender via Dwarf-discuss
if that information is presented in the Agenda for a meeting that would probably suffice, although it is the minutes that should be complete and definitive. Thanks, Ron On Wed, Apr 24, 2024 at 12:30 PM Cary Coutant wrote: > >> It appears that DW_LNAME_HIP, proposed in 230120.4, never got >&g

(flink) branch master updated (9cc649898d0 -> 8576178c4c0)

2024-04-24 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/flink.git from 9cc649898d0 [FLINK-35148][core] Improve InstantiationUtil for checking nullary public constructor new 2a9876d7ebc

(flink) 01/02: [FLINK-35188][table-api] Introduce CatalogMaterializedTable interface to support materialized table

2024-04-24 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 2a9876d7ebc75b9e650653b996c02af3d217b41a Author: fengli AuthorDate: Tue Apr 23 10:01:31 2024 +0800 [FLINK-35188][table

(flink) 02/02: [FLINK-35188][table-api] Introduce RefreshHandler interface to support materialized table

2024-04-24 Thread ron
This is an automated email from the ASF dual-hosted git repository. ron pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git commit 8576178c4c084c38897e395479df11f15a4ea402 Author: fengli AuthorDate: Tue Apr 23 10:02:16 2024 +0800 [FLINK-35188][table

Re: [Dwarf-discuss] Proposal: Error: Duplicate DW_AT_LNAME 1d

2024-04-24 Thread Ron Brender via Dwarf-discuss
, I'll fix it for V6. The next available code is 0x0027. What makes you think the code should be 0x0029? Ron On Tue, Apr 23, 2024 at 8:06 PM Adrian Prantl via Dwarf-discuss < dwarf-discuss@lists.dwarfstd.org> wrote: > # Error: Duplicate DW_AT_LNAME 1d > > ## Overview > &

Re: Backup_Long Running

2024-04-24 Thread Ron Johnson
PgBackRest is in the PGDG repositories (RHEL & Debian). The documentation is thorough, and discoverable via Google, On Wed, Apr 24, 2024 at 8:30 AM jaya kumar wrote: > Thanks for your update. Can you have any link or document to configure L0 > & L1 backup using pgbackrest tool. Also share the

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 5:56 PM Adrian Klaver wrote: > On 4/22/24 14:35, Ron Johnson wrote: > > > > > > > On Stack Exchange, I've got a question on how to determine when > > to run > > > CLUSTER. It ties in strongly with this threa

Re: issue with reading hostname

2024-04-22 Thread Ron Johnson
; Can we edit the socket to change the hostname in it ? > > Regards. > > On Tue, Apr 23, 2024 at 2:41 AM Ron Johnson > wrote: > >> On Mon, Apr 22, 2024 at 4:14 PM Atul Kumar wrote: >> >>> Hi, >>> >>> I have postgresql version 15 runnin

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 5:03 PM Adrian Klaver wrote: > On 4/22/24 13:59, Ron Johnson wrote: > > On Mon, Apr 22, 2024 at 4:21 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote: > > [snip] > > > > Which gets us back to your comment upst

Re: issue with reading hostname

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 4:14 PM Atul Kumar wrote: > Hi, > > I have postgresql version 15 running on centos7. > > I have below query that reads hostname from /tmp directory: > > psql postgres -A -t -p 5432 -h /tmp/ -c 'SELECT pg_is_in_recovery();' > If you installed from the PGDG repository

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 4:21 PM Adrian Klaver wrote: [snip] > Which gets us back to your comment upstream: > > "What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the > PK, if the PK is a sequence (whether that be an actual sequence, or a > timestamp or something else that grows

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 3:14 PM Adrian Klaver wrote: > > > On 4/22/24 11:45 AM, Ron Johnson wrote: > > On Mon, Apr 22, 2024 at 12:29 PM David G. Johnston > > mailto:david.g.johns...@gmail.com>> wrote: > > > > > > > > On Mon, Apr 22

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 12:29 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > > > On Mon, Apr 22, 2024, 08:37 Ron Johnson wrote: > >> On Mon, Apr 22, 2024 at 10:25 AM Tom Lane wrote: >> >>> Marcos Pegoraro writes: >>> > But w

[geo] Fwd: Addressing the Urgent Need for Direct Climate Cooling: Rationale and Options

2024-04-22 Thread Ron Baiman
ct-climate-cooling-rationale-and-options Best, Ron -- You received this message because you are subscribed to the Google Groups "geoengineering" group. To unsubscribe from this group and stop receiving emails from it, send an email to geoengineering+unsubscr...@googlegroups.com. To

Re: CLUSTER vs. VACUUM FULL

2024-04-22 Thread Ron Johnson
On Mon, Apr 22, 2024 at 10:25 AM Tom Lane wrote: > Marcos Pegoraro writes: > > But wouldn't it be good that VACUUM FULL uses that index defined by > > Cluster, if it exists ? > > No ... what would be the difference then? > What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the

[DISCUSS] FLIP-448: Introduce Pluggable Workflow Scheduler Interface for Materialized Table

2024-04-22 Thread Ron Liu
LINK/FLIP-448%3A+Introduce+Pluggable+Workflow+Scheduler+Interface+for+Materialized+Table Best, Ron

[RESULT][VOTE] FLIP-435: Introduce a New Materialized Table for Simplifying Data Pipelines

2024-04-22 Thread Ron Liu
Hi, Dev I'm happy to announce that FLIP-435: Introduce a New Materialized Table for Simplifying Data Pipelines[1] has been accepted with 13 approving votes (8 binding) [2] - Ron Liu(binding) - Feng Jin - Rui Fan(binding) - Yuepeng Pan - Ahmed Hamdy - Ferenc Csaky - Lincoln Lee(binding) - Leonard

Re: CLUSTER vs. VACUUM FULL

2024-04-21 Thread Ron Johnson
On Sun, Apr 21, 2024 at 9:35 PM David Rowley wrote: > On Mon, 22 Apr 2024 at 12:16, Ron Johnson wrote: > > > > On Sun, Apr 21, 2024 at 6:45 PM Tom Lane wrote: > >> > >> Ron Johnson writes: > >> > Why is VACUUM FULL recommended for compressing a tab

Re: CLUSTER vs. VACUUM FULL

2024-04-21 Thread Ron Johnson
On Sun, Apr 21, 2024 at 6:45 PM Tom Lane wrote: > Ron Johnson writes: > > Why is VACUUM FULL recommended for compressing a table, when CLUSTER does > > the same thing (similarly doubling disk space), and apparently runs just > as > > fast? > > CLUSTER makes

Re: CLUSTER vs. VACUUM FULL

2024-04-21 Thread Ron Johnson
On Sun, Apr 21, 2024 at 6:45 PM Tom Lane wrote: > Ron Johnson writes: > > Why is VACUUM FULL recommended for compressing a table, when CLUSTER does > > the same thing (similarly doubling disk space), and apparently runs just > as > > fast? > > CLUSTER makes

CLUSTER vs. VACUUM FULL

2024-04-21 Thread Ron Johnson
PG 14.11 on RHEL8 Why is VACUUM FULL recommended for compressing a table, when CLUSTER does the same thing (similarly doubling disk space), and apparently runs just as fast? My tests: Table: CDSLBXW.public.log Time 1 Time 2 Time 3 secssecssecs VACUUM FULL 44.2

Re: error in trigger creation

2024-04-21 Thread Ron Johnson
On Sun, Apr 21, 2024 at 2:58 PM yudhi s wrote: > the partition drop from parent is taking longer as it scans all the > partitions of the child table > Does the relevant supporting index exist on the child table?

Re: [go-nuts] compiling go-1.22.2 and go-1.21.9 fail due to timeout during test of net/http package

2024-04-21 Thread Ron Hermsen
://pastebin.com/Hnkv1p2W output part2: https://pastebin.com/KQmVW9T1 To compare with 1.22.1 which pass without issues: output: https://pastebin.com/YzM684sg Op zo 21 apr 2024 om 04:53 schreef Ian Lance Taylor : > On Sat, Apr 20, 2024 at 7:34 PM Ron Hermsen wrote: > > > > compiling g

[go-nuts] compiling go-1.22.2 and go-1.21.9 fail due to timeout during test of net/http package

2024-04-20 Thread Ron Hermsen
compiling go-1.22.2 and go-1.21.9 fail due to timeout during test of net/http package I tried a number of earlier releases but looks only the latest two fail. (each build takes about 40min, so didn't try more options) ok net 8.598s panic: test timed out after 9m0s running tests: FAIL

Bug#826576: Additional information

2024-04-19 Thread Ron Murray
+PzE9OncPIgEzmN1ph9u4dfB90kzl64OjPviL5xcazDTBj5wVUmzks3R6RlhV42 plFZhxs8Mhz2aCXfmlMZYKlDbvVtBEdd55CL/c9u1M5XOwSbpRyHzeqsOUcONgWD Lz9s4f2pvNmyPT+VDhsZ3SrPJTFd5MB4CCx4fQWEf34DL3NoEsE= =JnJj -END PGP SIGNATURE- -- Ron Murray PGP Fingerprint: 4D99 70E3 2317 334B 141E 7B63 12F7 E865 B5E2 E761

Re: [help] Error in database import

2024-04-19 Thread Ron Johnson
On Fri, Apr 19, 2024 at 11:58 PM Tu Ho wrote: > Hi, > > I am currently having a project where I need to combine 2 large database. > I was not however able to import an excel file .csv into the database. The > error was ERROR: syntax error at or near "OIDS" LINE 1: ...ing Site" , > "International

[Pce] Rtgdir early review of draft-ietf-pce-stateful-pce-optional-09

2024-04-19 Thread Ron Bonica via Datatracker
Reviewer: Ron Bonica Review result: Ready This draft is direct and well-written. It has clearly been reviewed by experts and is ready for publication. ___ Pce mailing list Pce@ietf.org https://www.ietf.org/mailman/listinfo/pce

Re: [EVDL] Adding a FM radio to a Tesla

2024-04-18 Thread Ron via EV
>From the log: /runsv backgammon root 3825 0.0 0.0 2456 252 ?Ss Apr15 0:00 runsv backgammon-input root 3826 0.0 0.0 2456 1288 ?Ss Apr15 Is there really a backgammon game? If so, does this indicate that it's running as root instead of a more

Re: Passing Tags or Additional Port Data to Change Parameters of Downstream Blocks

2024-04-18 Thread Ron Economos
/drmpeg/gr-dvbs2/blob/master/lib/bbheader_bb_impl.cc#L496 Then it's sent downstream and all the subsequent blocks use it for configuration (and also pass it downstream to the next block). Ron On 4/18/24 09:39, Matt Clemons wrote: Hello, I’ve been using the dtv/dvbt blocks in GnuRadio

Re: [DISCUSS] FLIP-445: Support dynamic parallelism inference for HiveSource

2024-04-18 Thread Ron Liu
Hi, Xia Thanks for updating, looks good to me. Best, Ron Xia Sun 于2024年4月18日周四 19:11写道: > Hi Ron, > Yes, presenting it in a table might be more intuitive. I have already added > the table in the "Public Interfaces | New Config Option" chapter of FLIP. > PTAL~ > > R

Re: [DISCUSS] FLIP-445: Support dynamic parallelism inference for HiveSource

2024-04-18 Thread Ron Liu
think you should list the various behaviors of these two options that coexist in FLIP by a table, only then users can know how the dynamic and static parallelism inference work. Best, Ron Xia Sun 于2024年4月18日周四 16:33写道: > Hi Ron and Lijie, > Thanks for joining the discussion and sharing y

Re: [DISCUSS] FLIP-445: Support dynamic parallelism inference for HiveSource

2024-04-17 Thread Ron liu
or will the manually set parallelism take effect, and who has the higher priority? Best, Ron Xia Sun 于2024年4月17日周三 12:08写道: > Hi Jeyhun, Muhammet, > Thanks for all the feedback! > > > Could you please mention the default values for the new configurations > > (e.g., table.e

Re: [9fans] troll paper

2024-04-17 Thread ron minnich
The author of the paper not only helped get the conference going this year, he worked hard this and last year to make sure our youtube channel worked. He also has done a lot of work to get faculty from U. Bamberg in Germany on board. The author was a major part of making IWP9 2024 go so well.

Re: [VOTE] FLIP-435: Introduce a New Materialized Table for Simplifying Data Pipelines

2024-04-17 Thread Ron liu
+1(binding) Best, Ron Ron liu 于2024年4月17日周三 14:27写道: > Hi Dev, > > Thank you to everyone for the feedback on FLIP-435: Introduce a New > Materialized Table for Simplifying Data Pipelines[1][2]. > > I'd like to start a vote for it. The vote will be open for at least

[VOTE] FLIP-435: Introduce a New Materialized Table for Simplifying Data Pipelines

2024-04-17 Thread Ron liu
/confluence/display/FLINK/FLIP-435%3A+Introduce+a+New+Materialized+Table+for+Simplifying+Data+Pipelines [2] https://lists.apache.org/thread/c1gnn3bvbfs8v1trlf975t327s4rsffs Best, Ron

Re: efficiency random values / sequential ID values in indexes

2024-04-15 Thread Ron Johnson
On Mon, Apr 15, 2024 at 6:05 AM Sanjay Minni wrote: > Hi > > Is there any appreciable difference in using random values or sequential > values in indexes > > in a multi tenanted application there is a choice that the single field > ID's value is totally random / UUID or the numbers are created

Re: Failing streaming replication on PostgreSQL 14

2024-04-15 Thread Ron Johnson
On Mon, Apr 15, 2024 at 2:53 AM Nicolas Seinlet wrote: > Hello everyone, > > Since I moved some clusters from PostgreSQL 12 to 14, I noticed random > failures in streaming replication. I say "random" mostly because I haven't > got the source of the issue. > > I'm using the Ubuntu/cyphered

Re: [ANNOUNCE] New Apache Flink Committer - Zakelly Lan

2024-04-14 Thread Ron liu
Congratulations! Best, Ron Yuan Mei 于2024年4月15日周一 10:51写道: > Hi everyone, > > On behalf of the PMC, I'm happy to let you know that Zakelly Lan has become > a new Flink Committer! > > Zakelly has been continuously contributing to the Flink project since 2020, &

Recursively trace all Foreign Key "referenced by" tables?

2024-04-13 Thread Ron Johnson
The attached PG function dba.get_fk_referenced_by() has been tested on PG 9.6 and 14. A recursive bash function (also attached) calls the PG function, and displays the whole tree of tables that the table in question depends on. Output also attached. Is there a better way to do this? (I'm

[Sprinklerforum] Re: Suction Control Valve

2024-04-13 Thread Ron Greenman
I would guess that anyone here who knew George misses him. And in the spirit of George, anyone reading this who finds the forum useful and is not a member of AFSA ought to join before the day is done. And also join your local chapter. On Sat, Apr 13, 2024 at 10:10 AM wrote: > We need a ‘smiley

Re: [Semibug] Need an example of libxo usage

2024-04-12 Thread Ron / BCLUG
(Apologies if this is a duplicate - been mucking about with email server settings.) Mike Wayne wrote on 2024-04-12 12:57: What I can not figure out is how to select fields to print. To customize the output fields for the lastlogin command using libxo with XML formatting in FreeBSD,

Re: [Semibug] Need an example of libxo usage

2024-04-12 Thread Ron / BCLUG
Mike Wayne wrote on 2024-04-12 12:57: What I can not figure out is how to select fields to print. To customize the output fields for the lastlogin command using libxo with XML formatting in FreeBSD, you'll need to use the -f option to specify the fields you want to include. Here's how you

Re: [DISCUSS] FLIP-435: Introduce a New Dynamic Table for Simplifying Data Pipelines

2024-04-12 Thread Ron liu
FLIP-282 [1] has also introduced Update & Delete API for modifying table. 1. https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=235838061 Best, Ron Ron liu 于2024年4月12日周五 19:49写道: > Hi, jgrier > > Thanks for your insightful input. > > First of all, very

Re: [ANNOUNCE] New Apache Flink PMC Member - Lincoln Lee

2024-04-12 Thread Ron liu
Congratulations, Lincoln! Best, Ron Junrui Lee 于2024年4月12日周五 18:54写道: > Congratulations, Lincoln! > > Best, > Junrui > > Aleksandr Pilipenko 于2024年4月12日周五 18:29写道: > > > Congratulations, Lincoln! > > > > Best Regards > > Aleksandr > > >

Re: [ANNOUNCE] New Apache Flink PMC Member - Jing Ge

2024-04-12 Thread Ron liu
Congratulations, Jing! Best, Ron Junrui Lee 于2024年4月12日周五 18:54写道: > Congratulations, Jing! > > Best, > Junrui > > Aleksandr Pilipenko 于2024年4月12日周五 18:28写道: > > > Congratulations, Jing! > > > > Best Regards, > > Aleksandr > > >

Re: [DISCUSS] FLIP-435: Introduce a New Dynamic Table for Simplifying Data Pipelines

2024-04-12 Thread Ron liu
us statement may not be that accurate, this is not a new concept, it is just a new type of table, similar to the capabilities of materialized view, but simplifies the data processing pipeline, which is also aligned with the long term vision of Flink SQL. Best, Ron Jamie Grier 于2024年4月11日周四 05:59

[EVDL] improved "go" pedal design

2024-04-11 Thread Ron Freund via EV
/watch?v=jrFphMKvuKw -Ron -- next part -- An HTML attachment was scrubbed... URL: <http://lists.evdl.org/private.cgi/ev-evdl.org/attachments/20240411/6c8955e4/attachment.htm> ___ Address messages to ev@lists.evdl.org No

[kdenlive] [Bug 485356] New: External proxy preset, error when setting multiple profiles

2024-04-11 Thread Ron
. I'm seeing this in kdenlive built locally from: c806935cdc8870115503a1f217f0554a0f83d1fc Checking the 24.02.1 Appimage, I'm not seeing the button to pop up an edit profile dialog at all - so now I'm not sure if this is a new option, or something that is not enabled for the AppImage? Cheers,

Re: [Gen-art] Genart last call review of draft-murchison-rfc8536bis-12

2024-04-10 Thread Ron Even
Hi Ken, Thanks for the clarification I have no more qusetions Roni On Mon, 8 Apr 2024 at 15:04 Ken Murchison wrote: > Hi Roni, > > Thank you for the review. Responses inline below. > > > On 4/8/24 7:26 AM, Roni Even via Datatracker wrote: > > Reviewer: Roni Even > Review result: Ready with

Re: [EVDL] Tesla settles with family

2024-04-09 Thread Ron via EV
Regarding pedal misapplication, I think you nailed it. I'm a pretty old guy, so my driver training might have been different than what is available now. Driver training #1: my dad was an amateur stock car racer and stunt driver. He taught us quite a few neat things. One of the things he taught

PL/pgSQL techniques better than bash for dynamic DO?

2024-04-09 Thread Ron Johnson
PG 9.6.11, if relevant, migrating to PG 14 Real Soon Now. I must purge the oldest X period of records from 70 tables, every Sunday. The field name, interval (X days or months) and date (CURRENT_DATE or CURRENT_TIMESTAMP) varies for each table. Thus, I put all the relevant data in a tab-separated

Re: [DISCUSS] FLIP-435: Introduce a New Dynamic Table for Simplifying Data Pipelines

2024-04-09 Thread Ron liu
Hi, Dev My rankings are: 1. Derived Table 2. Materialized Table 3. Live Table 4. Materialized View Best, Ron Ron liu 于2024年4月9日周二 20:07写道: > Hi, Dev > > After several rounds of discussion, there is currently no consensus on the > name of the new concept. Timo has proposed th

Re: [DISCUSS] FLIP-435: Introduce a New Dynamic Table for Simplifying Data Pipelines

2024-04-09 Thread Ron liu
Friday. I look forward to everyone voting on the name in this thread. Of course, we also welcome new input regarding the name. Best, Ron Ron liu 于2024年4月9日周二 19:49写道: > Hi, Dev > > Sorry for my previous statement was not quite accurate. We will hold a > vote for the name within t

  1   2   3   4   5   6   7   8   9   10   >