On Mon, Sep 30, 2024 at 8:46 PM Philip Semanchuk <
phi...@americanefficient.com> wrote:
>
>
> > On Sep 26, 2024, at 7:03 AM, yudhi s
> wrote:
> >
> > In a RDS postgres ...
>
> > Is it fine to let it use "FreeLocalStorage" unless it goes till zero?
>
> Hi Yudhi,
> FreeLocalStorage and some of the
On Tue, Oct 1, 2024 at 4:10 AM Adrian Klaver
wrote:
> On 9/30/24 13:01, sud wrote:
> > Hello,
> > We are frequently seeing the total DB connection reaching ~2000+ whereas
>
> Where are you getting the ~2000 count from?
>
> > the total number of active sessions in pg_stat_activity staying <100 at
On 9/30/24 13:01, sud wrote:
Hello,
We are frequently seeing the total DB connection reaching ~2000+ whereas
Where are you getting the ~2000 count from?
the total number of active sessions in pg_stat_activity staying <100 at
any point in time. And when we see the sessions from DB side they
Hello,
We are frequently seeing the total DB connection reaching ~2000+ whereas
the total number of active sessions in pg_stat_activity staying <100 at any
point in time. And when we see the sessions from DB side they are showing
most of the sessions with state as 'idle' having backend_start/xact_s
> On Sep 26, 2024, at 7:03 AM, yudhi s wrote:
>
> In a RDS postgres ...
> Is it fine to let it use "FreeLocalStorage" unless it goes till zero?
Hi Yudhi,
FreeLocalStorage and some of the other things you ask about are specific to AWS
RDS, so you might have better luck getting answers on an
Let me try, Thanks Pavel.
On Mon, Sep 30, 2024 at 3:53 PM Pavel Stehule
wrote:
> Hi
>
> use format function
>
> do $$
> begin
> for i in 1..10
> loop
> execute format($_$
> create or replace function %I(a int)
> returns int as $__$
> begin
> return a + %s;
> end;
> $__$ language plpgsq
Hi
use format function
do $$
begin
for i in 1..10
loop
execute format($_$
create or replace function %I(a int)
returns int as $__$
begin
return a + %s;
end;
$__$ language plpgsql;
$_$, 'foo_' || i, i);
end loop;
end;
$$;
DO
(2024-09-30 12:21:29) postgres=# \sf foo_1
CREATE OR REPLACE
Guys,
I have a requirement to generate the plpgsql procedure code itself by
reading the postgresql metadata or system tables. I don't want to write a
plpgsql procedure every time for every table because I have many tables in
db. I want to generate the procedure for more than 100 tables and write al
On Mon, 2024-09-30 at 08:31 +0100, Vinícius Abrahão wrote:
> postgres=# create table backup_pg_statistic as select * from pg_statistic;
> 2024-09-30 08:25:56 BST [7400]:
> user=vinnix,db=postgres,app=psql,client=[local] ERROR: column "stavalues1"
> has pseudo-type anyarray
> 2024-09-30 08:25:56
Hello Folks,
Thanks for Your inspiration; and I made some progress (found
a way to avoid the issue).
The issue is most likely not related to postgres.
Ron Johnson said:
>> A configuration problem on the machine(s) can be ruled out,
> Famous last words.
Trust me. :)
> Is there a way to test
Morning,
postgres=# create table backup_pg_statistic as select * from pg_statistic;
2024-09-30 08:25:56 BST [7400]:
user=vinnix,db=postgres,app=psql,client=[local] ERROR: column "stavalues1"
has pseudo-type anyarray
2024-09-30 08:25:56 BST [7400]:
user=vinnix,db=postgres,app=psql,client=[local] S
11 matches
Mail list logo
