Re: Suddenly all queries moved to seq scan

2024-11-20 Thread Efrain J. Berdecia
Make sure to run analyze on the entire database, possibly using vacuumdb would be faster. Also, check for invalid indexes. Efrain J. Berdecia On Wednesday, November 20, 2024 at 08:02:36 AM EST, Daniel Gustafsson wrote: > On 20 Nov 2024, at 11:50, Sreejith P wrote: > We are

Re: Bash function from psql (v14)

2024-11-09 Thread Efrain J. Berdecia
Maybe try using full path... Yahoo Mail: Search, Organize, Conquer On Sat, Nov 9, 2024 at 12:41 PM, Murthy Nunna wrote: Hi,   I am trying to code bash function and call it from psql. But it is failing. How can I get this to work. Creating a separate script instead of a function work

Re: Question on indexes

2024-10-10 Thread Efrain J. Berdecia
They are extremely efficient for joins!!! Yahoo Mail: Search, Organize, Conquer On Thu, Oct 10, 2024 at 2:52 PM, Christophe Pettus wrote: > On Oct 10, 2024, at 11:49, sud wrote: > > Hi, > I have never used any 'hash index' but saw documents in the past suggesting > issues around hash

Re: pg_restore enhancements

2023-11-22 Thread Efrain J. Berdecia
to either the COPY command or pg_restore. Thanks,Efrain J. Berdecia On Wednesday, November 22, 2023 at 11:37:13 AM EST, Adrian Klaver wrote: On 11/22/23 05:25, Efrain J. Berdecia wrote: > After working for a site where we are constantly doing logical pg_dump > to refresh environme

Re: pg_restore enhancements

2023-11-22 Thread Efrain J. Berdecia
Thanks, I'm trying to gage the interest on such a feature enhancement.  Up to now I have not actively contributed to the Postgres Project but this is itching my rusty programming fingers lol Thanks,Efrain J. Berdecia On Wednesday, November 22, 2023 at 08:28:18 AM EST, David G. Joh

pg_restore enhancements

2023-11-22 Thread Efrain J. Berdecia
to post this to the PG-developer group :-) Thanks,Efrain J. Berdecia