Re: Delete a table automatic?

Hi, I too agree with Adrian Klaver, the trigger is the only option Thanks, V Muralidharan +91 9940302900 On Tue, 1 Nov 2022, 19:46 Peter J. Holzer, wrote: > On 2022-11-01 07:41:14 -0600, Rob Sargent wrote: > > On 11/1/22 03:31, jian he wrote: > > > > On Tue, Nov 1, 2022 at 2:33 PM 黄宁 wr

Re: How different is AWS-RDS postgres?

Not important who does what with whom re Catalina/Tomcat ;) I will indeed re-examine timeouts and such as inserting 100sK record is not instantaneous by any stretch. Tomcat is the new kid on my block as prior to this release I managed a naked port with a Selector and that had no trouble with t

Re: vacuumdb not letting me connect to db

> On Feb 5, 2021, at 9:37 AM, Ron wrote: > >> On 2/5/21 10:22 AM, Rob Sargent wrote: >> >> >>> On 2/5/21 9:11 AM, Ron wrote: >>> Obviously... don't use 300 threads. >>> >> No, no Ron. Clearly the answer is more CPUs > > I hope you're being sarcastic. > > -- > Angular momentum makes the

Re: stale WAL files?

>>> On Sat, Mar 30, 2019 at 5:03 PM Gmail wrote: >>> >>> >>> > On Mar 30, 2019, at 10:54 AM, Gmail wrote: >>> > >>> > >>> >>>> On Mar 29, 2019, at 6:58 AM, Michael Paquier >>> >>&

Re: stale WAL files?

I’m under fighting a nasty cold. It may take a day or two for me to response to recent questions and suggestion.

Re: stale WAL files?

> On Mar 30, 2019, at 10:54 AM, Gmail wrote: > > >>>> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: >>> >>> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >>> This is pg10 so it's pg_wal. ls -ltr >>>

Re: stale WAL files?

> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: > >> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >> This is pg10 so it's pg_wal. ls -ltr >> >> >> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >> 00010CEA00B1 >> -rw---. 1 postgres postgres 167772

Re: stale WAL files?

> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: > >> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >> This is pg10 so it's pg_wal. ls -ltr >> >> >> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >> 00010CEA00B1 >> -rw---. 1 postgres postgres 16777

Re: stale WAL files?

> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: > >> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >> This is pg10 so it's pg_wal. ls -ltr >> >> >> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >> 00010CEA00B1 >> -rw---. 1 postgres postgres 16777

Re: Display table entries using partial column entry

> On Dec 10, 2017, at 4:10 PM, Melvin Davidson wrote: > > > >> On Sun, Dec 10, 2017 at 4:50 PM, Sherman Willden >> wrote: >> The database table has five columns; 'id aria artist a_artist album_title'. >> I assume I will use a SELECT * FROM aria_precis WHERE type command. >> >> I want to a

building a server

So I revisited https://momjian.us/main/writings/pgsql/hw_selection.pdf Near the end (page 24) I spotted: Heavy use of server-side functions might generate significant CPU load Just want to confirm that this referring to workload on the mainly-single-threaded server not an advocacy for mor