Re: Speed up indexing in Lucene.net 3.0.3

ing. The current implementation stops processing each time another 500 records are queried from the database. BlockingCollection could be used so one producer extracts from the database then many consumers process then a few consumers add to Lucene. On 2023/01/15 07:08:50 Ron Grabowski wrote: >

[gphoto-devel] Add Canon R8 to gphoto 2 library

I have no access to get camera usb output per instructions. Add Canon R8 camera to gphoto 2 library - ___ Gphoto-devel mailing list Gphoto-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gphoto-devel

[Sprinklerforum] Re: Dry Sprinkler Heads

According to this article... 1937. https://www.sprinklerage.com/dry-barrel-sprinklers/#:~:text=The%20first%20UL%2Dlisted%20dry,three%2Dquarters%20of%20a%20century . On Tue, Feb 6, 2024 at 3:12 PM James Crawford wrote: > I was asked today when the first dry heads came into use and did not have

[geo] Re: [prag] Re: [HPAC] Solar geoengineering could start soon if it starts small | MIT Technology Review

ough indirect impact on reducing polar amplification to affect the jet stream and polar ice melt - these global climate effects would be overwhelmingly positive. . Best, Ron On Tue, Feb 6, 2024 at 4:17 PM Oswald Petersen wrote: > Dear Herb and Mike > > > > Prenotice > &

Re: [spring] draft-ietf-spring-srv6-srh-compression

n your draft. Ron Juniper Business Use Only From: Tal Mizrahi Sent: Tuesday, February 6, 2024 9:46 AM To: Andrew Alston - IETF Cc: Antoine FRESSANCOURT ; Robert Raszuk ; Ron Bonica ; spring@ietf.org Subject: Re: [spring] draft-ietf-spring-srv6-srh-compressio

Re: Question on partitioning

On Tue, Feb 6, 2024 at 2:40 PM veem v wrote: > Thank you Laurenz. Got it. > > So basically , you mean to say any DDL on a table won't allow the table to > be read by other processes. I was under the assumption that it should allow > the read queries to move ahead at least. I must be wrong here.

[geo] Re: [prag] Re: [HPAC] Solar geoengineering could start soon if it starts small | MIT Technology Review

is not an urgently workable option. At the risk of beating a dead horse I'm again attaching a draft of this proposal that many of you may have seen: https://drive.google.com/file/d/1o5xQogx1kKgD-QlM4MVPdWeL2BzBtwUm/view?usp=sharing Best, Ron On Mon, Feb 5, 2024 at 12:38 PM wrote: > Hi Herb and G

[geo] Fwd: Reminder for The Emperor’s New Climate Scenarios - Bad Advice Makes Risky Business

Dear Colleagues, Link to actuaries report on underestimated risk from climate change, presented at recent 2/4/2024 MEER Talk. Thank you Barbara! Best, Ron -- Forwarded message - From: Barbara Sneath Date: Mon, Feb 5, 2024 at 10:10 PM Subject: Re: Reminder for The Emperor’s New

Exclude certain application pgaudit logging?

Currently, we use Object audit logging to capture all READ access to columns FOO_1, FOO_2 and FOO_3 in table BAR.SCRABBLE. (They are the three columns have PII data.) The problem is that the application legitimately reads these columns thousands of times per day. Thus, the log fills up with

Re: Unused indexes

index without having to drop the index. Its only purpose is to make the DBA's life easier. IMNSHO, that's an excellent reason to have such a feature. > but Ron is correct, we have nothing equivalent. General usage in Postgres > is to drop the index if it is unused. If you need to create it ag

(flink) branch master updated: [FLINK-34256][docs] Add documentation for mini-batch regular join

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 1ebcaf5b348 [FLINK-34256][docs] Add documentation

[geo] Fwd: Federal Register :: Scientific Integrity Policy Draft for Public Comment

Dear Colleagues, FYI Best, Ron -- Forwarded message - From: Barbara Sneath Date: Sun, Feb 4, 2024 at 4:06 PM Subject: Federal Register :: Scientific Integrity Policy Draft for Public Comment To: Ron Baiman Hi Ron, The Scientific Integrity policy draft is now open for public

[geo] Fwd: Climate change opinion and recent presidential elections

Thanks Barbara. Interesting. -- Forwarded message - From: Barbara Sneath Date: Sun, Feb 4, 2024 at 3:53 PM Subject: Climate change opinion and recent presidential elections To: Ron Baiman Hi Ron, Voters’ attitudes to climate change are changing. Best wishes, Barbara

Stus-List Re: C Custom 52

I don't see a photo Is this a C 110 or a custom 52?? On Mon, Feb 5, 2024, 5:41 PM Joel Delamirande via CnC-List < cnc-list@cnc-list.com> wrote: > Is it still alive that boat > > Joel Delamirande > *www.jdroofing.ca * > > > > On Mon, Feb 5, 2024 at 11:41 AM

Re: Improving pg_dump performance when handling large numbers of LOBs

that use of LOBs for this purpose was > not necessary. > > Wyatt > > On Mon, Feb 5, 2024 at 11:36 AM Ron Johnson > wrote: > >> On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis >> wrote: >> >>> Hi, >>> >>> We've inherited a series of leg

Re: Improving pg_dump performance when handling large numbers of LOBs

On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis wrote: > Hi, > > We've inherited a series of legacy PG 12 clusters that each contain a > database that we need to migrate to a PG 15 cluster. Each database contains > about 150 million large objects totaling about 250GB. > 250*10^9 / (150*10^6) = 1667

Re: Unused indexes

On Mon, Feb 5, 2024 at 9:02 AM arun chirappurath wrote: > Hi All, > > Do we have a script to get unused indexes for 30 days and once identified > do we have an option to disable and enable when required? > The pg_stat_*_tables tables idx_* columns has accumulated usage since the last time you

Re: [spring] draft-ietf-spring-srv6-srh-compression

Folks, Has anyone proposed a solution to the L4 checksum problem that Andrew talks about? Ron Juniper Business Use Only From: spring on behalf of Andrew Alston - IETF Sent: Monday, February 5, 2024 5:21 AM

Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY

On Mon, Feb 5, 2024 at 7:23 AM Sean v wrote: > This is related to a question I asked on dbs.stackexchange.com: > https://dba.stackexchange.com/questions/335501/why-doesnt-postgres-apply-limit-on-groups-when-retrieving-n-results-per-group > > But to reiterate - I have a query like this: > >

(flink) branch master updated: [FLINK-34353][table-planner] Fix unclear exception without setting minibatch size when enable minibatch optimization

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 de2d175decc [FLINK-34353][table-planner] Fix

(flink) branch master updated: [FLINK-34229][table-runtime] Set CodeGeneratorContext of outer class as ancestor context when generate inner classes to avoid naming conflicts

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 a603f2bb853 [FLINK-34229][table-runtime] Set

Re: Question on partitioning

On Sun, Feb 4, 2024 at 4:40 PM veem v wrote: > Hello All, > In postgresql, Is it possible to partition an existing nonpartitioned > table having data already residing in it and indexes and constraints > defined in it, without the need of manually moving the data around, to make > it faster?

Re: How to do faster DML

On Sat, Feb 3, 2024 at 11:09 AM Lok P wrote: [snip] > show maintenance_work_mem; - 4155MB > show work_mem; - 8MB > show shared_buffers ; -22029684 > Those are pretty small values. What are your server specs?

Re: How to do faster DML

On Sun, Feb 4, 2024 at 10:30 AM Lok P wrote: > On Sun, Feb 4, 2024 at 8:14 PM Dennis White > wrote: > >> I'm surprised no one has mentioned perhaps it's a good idea to partition >> this table while adding the pk. By your own statements the table is >> difficult to work with as is. Without

Re: [RBW] Rapid rise derailleur rec

I'm a metallurgist and licensed PE - relaxing RD spring absolutely extends spring life. OP's question - Microshift R10 (made by Sun XCD) https://www.charlottecycles.com/product/microshift-r10-rear-derailleur-377496-1.htm On Friday, February 2, 2024 at 11:08:38 AM UTC-6 John Dewey wrote: >

Re: How to do faster DML

On Sat, Feb 3, 2024 at 8:55 AM Lok P wrote: > Apology. One correction, the query is like below. I. E filter will be on > on ctid which I believe is equivalent of rowid in oracle and we will not > need the index on Id column then. > > But, it still runs long, so thinking any other way to make

[geo] Fwd: Deadline Feb 2nd 2023: Expert Input Welcome for the 2024/2025 Edition of the 10 New Insights in Climate Science - 10insightsclimate

. ). These don’t have to have been peer reviewed. It’s a very quick and simple questionnaire! Best, Ron Sent from my iPhone Begin forwarded message: > From: Barbara Sneath > Date: January 31, 2024 at 6:35:01 PM EST > To: Ron Baiman > Subject: Deadline Feb 2nd 2023: Expert I

Re: Query running longer

On Thu, Feb 1, 2024 at 4:13 PM Laurenz Albe wrote: > On Fri, 2024-02-02 at 02:27 +0530, veem v wrote: > > We have the below query which is running for ~45 seconds on postgres > aurora reader instance. > > I have captured the explain analyze. Want to understand, where exactly > the resources are

Re: [RBW] Dialing in a Brooks Saddle

My bikes with B-17 are semi upright. My bikes with level saddle/stem and drop bars are Swallow or Pro On Wednesday, January 31, 2024 at 1:50:46 AM UTC-6 Steven Sweedler wrote: > FWIW my bikes are set up with B-17 s level and with the bars level to the > saddle, works for me. > > Steven

Re: [GTALUG] An anomaly with the `date` command

Colin McGregor via talk wrote on 2024-01-30 14:14: For calendar oddities try typing the following into a BASH terminal : cal 9 1752 The seemingly odd result will be correct for what is now Halifax, Nova Scotia, but incorrect for what is now Quebec City, Quebec. Anyone know why?

Re: Query performance in 9.6.24 vs 14.10

According to my tests, sometimes JIT is a little faster, and sometimes it's a little slower. Mostly within the realm of statistical noise (especially with each query having a sample size of only 13, on a VM that lives on a probably-busy host). On Mon, Jan 29, 2024 at 9:18 AM Ron Johnson wrote

Re: Query performance in 9.6.24 vs 14.10

Yes, jit=on. I'll test them with jit=off, to see the difference. (The application is 3rd party, so will change it at the system level.) On Mon, Jan 29, 2024 at 7:09 AM Bob Jolliffe wrote: > Out of curiosity, is the pg14 running with the default jit=on setting? > > This is obviously entirely

[RBW] Re: [650B] Re: Onza pedal pla

http://mombatbicycles.com/MOMBAT/PartsForSalePages/pedals.html Contact this bike shop and ask if you can mail your pedals in for rebuild. On Sunday, January 28, 2024 at 7:22:05 PM UTC-6 ber...@bernardduhon.com wrote: > Cartridge bearing goes to the end of the spindle & cannot be removed > >

Re: Scriptable way to validate a pg_dump restore ?

On Mon, Jan 29, 2024 at 3:12 AM Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Hi > > Let's say I've got a scenario where I'm doing a pg_dump replication rather > than online streaming, e.g. due to air-gap or whatever. > > Is there a scriptable way to validate the restore ? e.g.

Re: Query performance in 9.6.24 vs 14.10

On Sun, Jan 28, 2024 at 10:44 PM David Rowley wrote: > On Mon, 29 Jan 2024 at 07:37, Ron Johnson wrote: > >> 08 9.6.24 1,142.164 1,160.801 1,103.716 1,249.852 1,191.081 >> 14.10 159.354 155.111 155.111 162.797 158.157 86.72% >> > > Your speedup per cent calcul

(flink) branch master updated: [FLINK-34222][table-planner] Supports mini-batch for streaming regular join

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 20450485b20 [FLINK-34222][table-planner] Supports

Query performance in 9.6.24 vs 14.10

(I don't know how this will look in text mode. Hopefully it will be comprehensible in the archives.) This is the summary of EXPLAIN (ANALYZE) on eight frequently-run complex queries from our application, extracted from the Postgresql log because either the BIND or SELECT takes longer than 3000

The Onscreen Keyboard Issue

Hi Candy, Using the Freedom Scientific Focus 40 Blue U Braille display, there is a hot key that if the on screen keyboard does not show up you can press to make it show up.  The unit must be connected when you do this. The hot key is a Q chord on the display.  I do not know if this works for

[RBW] Re: play in Onza pedals

Pedal clicking is usually in the big bushings or wear in the shaft itself. You'll note rebuilds kits include these two items, plus the bearings. Found this on ebay - price is right if it matches your pedal. https://www.ebay.com/itm/155873406654 On Friday, January 26, 2024 at 9:19:41 AM

(flink) branch master updated: [FLINK-34221][table-runtime] Introduce MiniBatchStreamingJoinOperator

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 8170c457cb7 [FLINK-34221][table-runtime] Introduce

Re: [linux] Linux-Ottawa / NCF collaboration

Dianne Skoll wrote on 2024-01-25 14:00: I would call this a MAJOR obstacle. I am missing something. What was the original email that started this thread off? What is the "this" that is a major obstacle? That email seems not to have reached me. Same here - seems like the conversation

Re: Re: [linux] Strange Email Issues with this list - gmail spamming myself

Dianne Skoll wrote on 2024-01-25 12:59: I'd be willing to have a look on the server and see how easy it would be to change to the latest 2.x release of GNU Mailman. Since mailman2 requires python2, which has been deprecated since 2020, might be worth going to mailman3. I've got some

Re: permission denied on socket

On Thu, Jan 25, 2024 at 3:32 PM Adrian Klaver wrote: [snip] > Best guess is you are using a version of psql that is expecting the > socket to be somewhere else then where it actually is. > Is "permission denied" really the error you get when the socket does not exist? Trying "psql

Re: permission denied on socket

On Thu, Jan 25, 2024 at 3:23 PM Atul Kumar wrote: > Hi, > > I have postgres 13 running on centos 7. > > I am facing an issue while trying to connect the cluster using the below > command. > > -bash-4.2$ psql postgres > > psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: >

Re:

On Thu, Jan 25, 2024 at 12:29 PM Tom Lane wrote: > Ron Johnson writes: > > EXPLAIN SELECT works inside a FOR loop, but only the first line of the > > EXPLAIN output is stored. What's the magic sauce for seeing the whole > > EXPLAIN output? > > The usual way is to ru

[no subject]

PG 14.10 (and 9.6.24, which we're migrating off of). EXPLAIN SELECT works inside a FOR loop, but only the first line of the EXPLAIN output is stored. What's the magic sauce for seeing the whole EXPLAIN output? (The purpose is to generate many queries and see how the BIND and SELECT times change

(flink) 03/06: [FLINK-34100][table] Introduce UnalignedWindowTableFunctionOperator for unaligned window

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 9a22ff7e961cb5d8b52401e567e59954bff35d50 Author: xuyang AuthorDate: Fri Jan 19 17:48:46 2024 +0800 [FLINK-34100][table

(flink) 04/06: [FLINK-34100][table] Support session window table function without pulling up with window agg

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 f1871fc31aa64e51fb812e6de457bad9e1c020c3 Author: xuyang AuthorDate: Mon Jan 22 11:31:56 2024 +0800 [FLINK-34100][table

(flink) 05/06: [FLINK-34100][table] Fix the window table function outputs wrong row kind

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 bab14f9fabec6adc2f2a6aad8ecbeef59e34e911 Author: xuyang AuthorDate: Wed Jan 24 20:09:39 2024 +0800 [FLINK-34100][table

(flink) branch master updated (78e31f0dcc4 -> 80f6e063310)

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 78e31f0dcc4 [FLINK-34144][docs] Update the documentation about dynamic source parallelism inference new 65f02285315

(flink) 06/06: [FLINK-34100][table] Merge SlicingWindowOperator and UnslicingWindowOperator

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 80f6e063310555c80978aefce3a8e570cb6315e9 Author: xuyang AuthorDate: Thu Jan 25 19:22:38 2024 +0800 [FLINK-34100][table

(flink) 02/06: [FLINK-34100][table] Extract a WindowTableFunctionOperatorBase from WindowTableFunctionOperator to prepare for introducing unaligned window table function

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 de4e9e7382e79b6b1ac0f17ae87d5c84fbe7820c Author: xuyang AuthorDate: Fri Jan 19 17:16:27 2024 +0800 [FLINK-34100][table

(flink) 01/06: [FLINK-34100][table] Add function getDescription for internal interface WindowAssigner

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 65f022853151c79a67c387147633fecfe8e838e4 Author: xuyang AuthorDate: Fri Jan 19 17:09:29 2024 +0800 [FLINK-34100][table

Re: Long execution of SQL query to Kafka + Hive (q77 TPC-DS)

Hi, Can you help to explain the q77 execution plan? And find which operator takes a long time in flink UI? Best Ron Вова Фролов 于2024年1月24日周三 09:09写道： > Hello, > > I am executing a heterogeneous SQL query (part of the data is in Hive > and part in Kafka. The query utilizes TPC-

Re: [PATCH] awk: fix segfault when compiled by clang

unavailable at the time I sent the message. Presumably it was encountering difficulties which resulted in it becoming forgetful. It is archived elsewhere: https://marc.info/?l=busybox=1=202401=2 Ron ___ busybox mailing list busybox@busybox.net http://lists

(flink) 02/03: [FLINK-34048][table] introduce basic interface and class for unslicing window

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 7306a851e1a34dd002dfbcce219b61ee872fca55 Author: xuyang AuthorDate: Fri Jan 19 15:27:22 2024 +0800 [FLINK-34048][table

(flink) 03/03: [FLINK-34048][table] introduce unslicing window agg for session window tvf

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 de7322112cbf594ae4b74163b5e58892e6cdf4ca Author: xuyang AuthorDate: Fri Jan 19 16:37:06 2024 +0800 [FLINK-34048][table

(flink) 01/03: [FLINK-34048][table-planner] Add isAlignedWindow for WindowSpec interface

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 b6e608e183622c5eb4efd312cd7c00a9f0832c68 Author: xuyang AuthorDate: Fri Jan 19 14:31:44 2024 +0800 [FLINK-34048][table

(flink) branch master updated (1bf27c63624 -> de7322112cb)

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 1bf27c63624 [FLINK-34220][table-runtime] Introduce BufferBundle for minibatch join new b6e608e1836 [FLINK-34048

(flink) branch master updated: [FLINK-34220][table-runtime] Introduce BufferBundle for minibatch join

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 1bf27c63624 [FLINK-34220][table-runtime] Introduce

Re: [CODE4LIB] Mobile Printing - Payment Processing

specific questions about TBS and/or their products, I'd be happy to answer them on or off the list. Thanks, Ron Western Washington University -Original Message- From: Code for Libraries On Behalf Of charles meyer Sent: Wednesday, January 24, 2024 2:45 PM To: CODE4LIB@LISTS.CLIR.ORG Subject

[geo] Gideon Futerman on SRM and Global Catastrophic Risk at Jan 25, HPAC General Meeting, 2024, 4:30 EST

r.ac.uk/media/uploads/files/SRM_workshop_report_003.pdf>. See also his recent paper (under review) Gideon et al. (2023) on this topic: https://egusphere.copernicus.org/preprints/2023/egusphere-2023-1753/ Hope you can make it! Best, Ron For the HPAC SC -- You received this message because yo

Re: [RBW] B17 alternatives

Silly me, never considered there was an alternative to Brooks. I'm backed up, with a couple stashed Select and L/E saddles I bought for $99 close-out. But if I was in the saddle market, I'd go to BikeTiresDirect and buy a B17 Special at their discount. On Wednesday, January 24, 2024 at

Re: Backup certain months old data

On Mon, Jan 22, 2024 at 10:12 PM Siraj G wrote: > Hello! > > I would like to know how we can backup certain months old data from PgSQL > Use the COPY command. > and then delete it. > That would depend on how many records, how big the records are, and if there's index support on the "date"

Re: Mimic ALIAS in Postgresql?

; is actually an interesting exception to this.) > > 1: https://guides.rubyonrails.org/active_record_querying.html#find > > You may well be correct, but I have to ask the OP (Ron) if this is the > case in the current situation. I find it difficult to conceive of a > "fra

Re: [MOPO] Norman Jewison died

Sad to hear even if he was nearly 100. One of my favorite directors, and like Robert Wise, comfortable and excellent in every genre.  He will be mourned... Ron On Monday, January 22, 2024 at 05:19:17 PM PST, Christopher Quarles wrote: https://variety.com/2024/film/obituaries-people

Re: gr-lora CMake error

That repository is much too old to build under modern GNU Radio. It hasn't been updated in 7 years. There are some alternatives. It looks like the most maintained is this one. https://github.com/tapparelj/gr-lora_sdr Another one that should build. https://github.com/rpp0/gr-lora Ron On 1

Re: unbale to list schema

On Wed, Jan 17, 2024 at 1:46 PM Atul Kumar wrote: > Hi, > > I am not able to find any solution to list all schemas in all databases at > once, to check the structure of the whole cluster. > > As I need to give a few privileges to a user to all databases, their > schemas and schemas' objects

Re: [Elecraft] Dust Covers

I just saw that David sent you the info, you can see some of mine on my QRZ.com, there may be other dealers but I have received excellent, personalized service,and excellent work. *Have a nice day!* Ron Wilcox KF7ZN RN, BHS, BSN, CCM Ham Radio Volunteer Examiner Vice President Utah DX Association

Re: [Elecraft] Dust Covers

JSE repair, I have dust covers for all of my gear and have been very pleased. *Have a nice day!* Ron Wilcox KF7ZN RN, BHS, BSN, CCM Ham Radio Volunteer Examiner Vice President Utah DX Association HamSCI On Sat, Jan 20, 2024 at 12:19 PM Mike Rees wrote: > I purchased a used SP3. The sel

[geo] Fwd: CPR Initiative’s 3rd Public Hearing on Climate Action – Climate Protection and Restoration Initiative

Dear Colleagues, FYI , See link below. (Thanks for sharing Barbara!) Best, Ron -- Forwarded message - From: Barbara Sneath Date: Fri, Jan 19, 2024 at 4:09 PM Subject: CPR Initiative’s 3rd Public Hearing on Climate Action – Climate Protection and Restoration Initiative To: Ron

Re: B-tree index balance?

On Fri, Jan 19, 2024 at 11:37 AM Tom Lane wrote: > Ron Johnson writes: > > On an RDMS which I used in the 1990s and 2000s, b-tree indices of > sequences > > would get unbalanced, since every new leaf was added to the far right > > corner of the tree. > >

B-tree index balance?

On an RDMS which I used in the 1990s and 2000s, b-tree indices of sequences would get unbalanced, since every new leaf was added to the far right corner of the tree. Sure, they would auto-balance *to a degree* during node splits, but all those "far-right corner" inserts still left them pretty

[PATCH] awk: fix segfault when compiled by clang

de so both gcc and clang generate code that works. Signed-off-by: Ron Yorston --- editors/awk.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/editors/awk.c b/editors/awk.c index aa485c782..0981c6735 100644 --- a/editors/awk.c +++ b/editors/awk.c @@ -3006,7 +3006,7 @@

Re: Re: [VOTE] FLIP-389: Annotate SingleThreadFetcherManager as PublicEvolving

+1（binding） Best, Ron Xuyang 于2024年1月19日周五 14:00写道： > +1 (non-binding) > > > -- > > Best！ > Xuyang > > > > > > 在 2024-01-19 10:16:23，"Qingsheng Ren" 写道： > >+1 (binding) > > > >Thanks for the work, Hongshun! > >

Re: Re: [VOTE] FLIP-415: Introduce a new join operator to support minibatch

+1(binding) Best, Ron Xuyang 于2024年1月19日周五 13:58写道： > +1 (non-binding)-- > > Best！ > Xuyang > > > > > > 在 2024-01-19 13:28:52，"Lincoln Lee" 写道： > >+1 (binding) > > > >Best, > >Lincoln Lee > > > > > >Ben

[geo] Gideon Futerman on SRM and Global Catastrophic Risk at Thurs Feb. 8, 2024, 4:30 EST, HPAC General Meeting

his topic: https://egusphere.copernicus.org/preprints/2023/egusphere-2023-1753/ Hope you can make it! Best, Ron For the HPAC SC If you'd like to include some pre-reading for context, the workshop report that much of the talk will be based on is here <https://www.cser.ac.uk/

Re: pg_basebackup Restore problem

Perfectly understandable, but tar *did* fail. Time to start debugging your shell script. On Wed, Jan 17, 2024 at 4:26 PM Johnathan Tiamoh wrote: > Ok. > > I'm a little confused because has always work > > On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson > wrote: > >

Re: pg_basebackup Restore problem

Then you've got a bug somewhere in: tar -h -zxvf $PATH_FOLDER/* .tar.gz ls $PATH_FOLDER/*.tar.gz | xargs -I {} tar -h -zxvf {} On Wed, Jan 17, 2024 at 4:07 PM Johnathan Tiamoh wrote: > Yes. > > I am trying to restore the backups on a standby > > On Wed, Jan 17, 2024

Re: pg_basebackup Restore problem

Why aren't you letting pg_basebackup maintain the WAL files it needs? > > > On Wed, Jan 17, 2024 at 11:46 AM Ron Johnson > wrote: > >> 1. What's in $PATH_FOLDER? >> 2. What pg_basebackup command did you use? >> 3. Why aren't you letting pg_basebackup maintain the

[geo] Re: What Works – Climate Solutions Summit

Dear Colleagues, FYI. Thanks for sharing Barbara! Best, Ron On Mon, Jan 15, 2024 at 11:26 PM Barbara Sneath wrote: > Hi Ron, > > I apologize if I have already sent this information to you to disseminate > amongst the HPAC etc. members. Berlin in June. Abstracts due 31 Jan.

[RBW] Re: FS -looong winter storm list

an Albatross bar on the Viner? > > -Rich, Colder than it should be in Iowa. > > > > On Tuesday, January 16, 2024 at 11:14:39 AM UTC-6 Ron Mc wrote: > > Make tortilla soup, pedal it off watching tv > > > > -- You received this message because you are subscribe

Re: pg_basebackup Restore problem

t? > /tnt/backup/current > > This is where the backup files are. > > > > > > On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson > wrote: > >> On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh < >> johnathantia...@gmail.com> wrote: >> >>> Hell

Re: Initiate backup from routine?

On Wed, Jan 17, 2024 at 9:41 AM Troels Arvin wrote: > Hello, > > I would like to allow a co-worker to perform a backup of a database, such > that the backup is saved to the database server itself. One use case is > that (s)he would like an extra backup of a database, just before an > application

Re: pg_basebackup Restore problem

On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh wrote: > Hello, > > I am trying to restore a pg_basebackup and have the following errors. > > You need to tell us the PG version number *and* show us the full command you ran. > nohup: ignoring input > tar: /tnt/backup/current/7400.tar.gz: Not

Re: WAL file clean up

On Tue, Jan 16, 2024 at 10:03 PM Brad White wrote: > I have the 'archive_cleanup_command' command specified, but I still have > WAL files. > The documentation seems to indicate that it will run automatically, but it > doesn't seem to be running. > > archive_cleanup_command =

Re: replication not replicating

On Tue, Jan 16, 2024 at 6:26 PM Brad White wrote: > On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson > wrote: > >> On Tue, Jan 16, 2024 at 4:10 PM Brad White wrote: >> >>> Errors from the primary >>> >>> 2024-01-15 00:00:51.157 CST [2660] ERROR: re

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote: > On 1/16/24 15:39, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > >> On 1/16/24 10:20, Ron Johnson wrote: >> >> Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > On 1/16/24 10:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name). > > We have an application runnin

Re: replication not replicating

On Tue, Jan 16, 2024 at 4:10 PM Brad White wrote: > Errors from the primary > > 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment > 0001000200A2 has already been removed > 2024-01-15 00:00:51.157 CST [2660] STATEMENT: START_REPLICATION > 2/A200 TIMELINE 1 >

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 2:24 PM Adrian Klaver wrote: > > On 1/16/24 10:11 AM, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver > wrote: > >> On 1/16/24 09:20, Ron Johnson wrote: >> > Some RDBMSs have CREATE ALIAS, which allows you to refer

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 1:09 PM Adrian Klaver wrote: > On 1/16/24 09:59, Ron Johnson wrote: > > > Performance-killing alternatives are not really altternatives. > > Unless it is the only one that solves your problem. > Amputating one head cures one's migraines, but nobody

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: > On 1/16/24 09:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > > different name (while also referring to it by the original name). > > > > > > > Ma

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 12:10 PM Adrian Klaver wrote: > On 1/16/24 09:04, Dominique Devienne wrote: > > On Tue, Jan 16, 2024 at 5:07 PM Adrian Klaver > > wrote: > > > > On 1/16/24 00:06, Dominique Devienne wrote: > > > On Mon, Jan 15, 2024 at 5:17 AM

Re: postgres sql assistance

"*invalid input syntax for type boolean: "15"*" That is the problem. You can't insert 15 into a column of type "boolean". On Tue, Jan 16, 2024 at 7:35 AM arun chirappurath wrote: > Dear all, > > I am an accidental postgres DBA and learning things every day. Apologies > for my questions if not

Mimic ALIAS in Postgresql?

Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current developer) extensively uses this with two

Re: [GTALUG] "AI" on getting correct technical answers

Steve Petrie via talk wrote on 2024-01-16 05:41: A. SSO (single sign on) -- Is it an SSO offer, when my Firefox browser "helpfully" asks me if I would like it [my browser] to "remember" my login credentials ?? No, SSO where one signs in to a site they've never visited via their Google

Re: [RBW] Re: Silver crank surprise and the weight of things

What makes a bike joyous is not 1 mph, 15 mph, or 23 mph, but the dynamic changes between those velocities. On Sunday, January 14, 2024 at 7:25:57 PM UTC-6 John Hawrylak, Woodstown NJ wrote: > Chris made some good points. I am not justifying a heavy bike, merely > pointing out what you

Re: [RBW] Re: Silver crank surprise and the weight of things

The scalar involved here, 6 lbs, and 15 lbs, hardly fits into weight weenie discussion. But I do remember a thread about why some bikes feel faster. Less energy going into changing the rotational speed of components means more energy going directly into drive. On Sunday, January 14, 2024

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 >

<    1   2   3   4   5   6   7   8   9   10   >