Re: Planet Postgres and the curse of AI

2024-07-18 Thread Laurenz Albe
On Wed, 2024-07-17 at 13:21 -0400, Greg Sabino Mullane wrote: > I've been noticing a growing trend of blog posts written mostly, if not > entirely, with AI > (aka LLMs, ChatGPT, etc.). I'm not sure where to raise this issue. I > considered a blog post, > but this mailing list seemed a better foru

Re. Select with where condition times out

2024-07-18 Thread sivapostg...@yahoo.com
Hello,PG V11 Select count(*) from table1Returns 10456432 Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' Times out The above query was working fine for the past 2 years.   Backup was taken a day back.  Need to recover complete data as far as possible. Any possible way(s) to do

Re: Re. Select with where condition times out

2024-07-18 Thread Kashif Zeeshan
Hi It can be caused due to Table Bloat, table bloat can slow down queries. Use the pg_repack extension or VACUUM FULL to try ti fix this table bloat issue. You can refer to following link https://supabase.com/blog/postgres-bloat Regards Kashif Zeeshan On Thu, Jul 18, 2024 at 2:38 PM sivapostg...

Re: Regarding vacuum freeze locking mechanism

2024-07-18 Thread Durgamahesh Manne
Hi David. Excellent response from you .Great Regards, Durga Mahesh On Thu, Jul 18, 2024 at 11:28 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, July 17, 2024, Durgamahesh Manne > wrote: > >> >> Could you please provide more clarity on this? Which lock triggers on the

Re: Re. Select with where condition times out

2024-07-18 Thread Francisco Olarte
On Thu, 18 Jul 2024 at 11:38, sivapostg...@yahoo.com wrote: > Hello, > PG V11 > > Select count(*) from table1 > Returns 10456432 > > Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' > Times out How do you send the query / how does it time out? Is that the real query? Is table

Re: Planet Postgres and the curse of AI

2024-07-18 Thread Laurenz Albe
I wrote: > On Wed, 2024-07-17 at 13:21 -0400, Greg Sabino Mullane wrote: > > I've been noticing a growing trend of blog posts written mostly, if not > > entirely, with AI > > (aka LLMs, ChatGPT, etc.). I'm not sure where to raise this issue. I > > considered a blog post, > > but this mailing list

Re: PgbackRest and EDB Query

2024-07-18 Thread KK CHN
Hi list, Thank you all for your inputs, I am trying pgbacrest with Enterprised DB. Locally pgbackrest works for EDB but when I am trying for remote repository I am facing an issue ( from the remote host to EDB server password less authentication part ) Trying to use a remote host as Repo Ser

Re: Planet Postgres and the curse of AI

2024-07-18 Thread David Rowley
On Fri, 19 Jul 2024 at 00:31, Laurenz Albe wrote: > Perhaps there could be a way to report misleading, bad content and a policy > that says > that you can be banned if you repeatedly write grossly misleading and > counterfactual > content. Stuff like "to improve performance, set fast_mode = on

Re: PgbackRest and EDB Query

2024-07-18 Thread Ruben Morais
In the documentatio you have how to do it: https://pgbackrest.org/user-guide.html#repo-host/setup-ssh On Thu, Jul 18, 2024, 14:10 KK CHN wrote: > > > Hi list, > > Thank you all for your inputs, I am trying pgbacrest with > Enterprised DB. Locally pgbackrest works for EDB but when I am trying

Re: Planet Postgres and the curse of AI

2024-07-18 Thread Greg Sabino Mullane
> But to what degree exactly should that be allowed? Somewhat ironically, here's a distinction chatgpt and I came up with: LLM-generated content: Content where the substantial part of the text is directly created by LLMs without significant human alteration or editing. Human-edited or reviewed c

Re: PgbackRest and EDB Query

2024-07-18 Thread azeem subhani
Hi, By following these steps, you should be able to connect to the EDB server from the Repo server using passwordless authentication: 1. First, generate an SSH key pair on the client machine(Repo Server machine): * ssh-keygen -t rsa -b 2048 -f ~/.ssh/id_rsa_enteprisedb -N ""* 2. Copy the Pu

Re: PgbackRest and EDB Query

2024-07-18 Thread Kashif Zeeshan
Hi On Thu, Jul 18, 2024 at 6:10 PM KK CHN wrote: > > > Hi list, > > Thank you all for your inputs, I am trying pgbacrest with > Enterprised DB. Locally pgbackrest works for EDB but when I am trying for > remote repository I am facing an issue ( from the remote host to EDB > server password

Re: PgbackRest and EDB Query

2024-07-18 Thread azeem subhani
Hi, passwordless connection can be established using ssh key, and when you don't specify the ssh key in command using -i switch:* -i /path/to/your/private/key* You simply need to set the SSH key as the default key which I have explained earlier, how to do that. As you are currently trying through