On 6/28/2019 8:07 PM, David Rowley wrote:
On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org wrote:
create trigger tr_on_table_modified after insert or delete or update
on some_table for each row execute procedure on_table_modified();
I can see in the output the notices with the expec
On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org wrote:
> create trigger tr_on_table_modified after insert or delete or update
> on some_table for each row execute procedure on_table_modified();
> I can see in the output the notices with the expected values, but the value
> in the upda
I have a trigger that is created like so:
create trigger tr_on_table_modified after insert or delete or update
on some_table for each row execute procedure on_table_modified();
CREATE OR REPLACE FUNCTION on_table_modified() RETURNS trigger
LANGUAGE plpgsql $$
/* some cod
On Fri, Jun 28, 2019 at 07:43:30AM -0400, Brad Nicholson wrote:
> So if all the checksums are being recalculated on the replica, this
> approach should be relatively safe, should it not?
Yep.
> Assuming pg_checksums is doing the right thing (and it looks to me like it
> should be).
The constrain
On 6/28/19 4:41 PM, Benedict Holland wrote:
Hello all,
I really can't figure this one out. I am trying to get debug working on
a postgrseql 10 database on ubuntu. I installed the proper package
postgresql-10-pldebugger*. *When I go to create the extention, I get the
error:
create extension
On 6/28/19 5:41 PM, Benedict Holland wrote:
Hello all,
I really can't figure this one out. I am trying to get debug working
on a postgrseql 10 database on ubuntu. I installed the proper package
postgresql-10-pldebugger*. *When I go to create the extention, I get
the error:
create extension
Hello all,
I really can't figure this one out. I am trying to get debug working on a
postgrseql 10 database on ubuntu. I installed the proper package
postgresql-10-pldebugger*. *When I go to create the extention, I get the
error:
create extension pldbgapi
ERROR: could not open extension control f
>
> Actually we have notice that Auto vacuum in PG10 keeps vacuuming the
> master tables and that takes a lot of time and Don't go the child table to
> remove the dead tuples.
>
What do the logs say actually got done during these long running
autovacuums? Is it feasible to increase the work allo
Hi All,
I have a large table partioned by month. I would like to run a query -
which adds derived data to the current data and inserts the data into a new
table. The new table is the target for users.
How can I iterate over the partition tables to insert data and build the
new table?
This is do
Hello Experts,
I have couple of questions on pg_controldata output.
postgres=# \! pg_controldata $PGDATA|grep checkpoint
*Latest checkpoint location: 2/9D029BB0, Latest checkpoint's
REDO location:2/97002D60Latest checkpoint's REDO WAL file:
000300020097*
Latest ch
On 2019-06-28 10:15, Tom Lane wrote:
t...@exquisiteimages.com writes:
I started an Analyze command on a database Wednesday evening at around
9:00PM. it is now Friday morning at 8:00 and it is still running.
...
I did try to execute:
SELECT pg_cancel_backend(4029);
and
SELECT pg_terminate_backend
t...@exquisiteimages.com writes:
> I started an Analyze command on a database Wednesday evening at around
> 9:00PM. it is now Friday morning at 8:00 and it is still running.
> ...
> I did try to execute:
> SELECT pg_cancel_backend(4029);
> and
> SELECT pg_terminate_backend(4029);
> but neither had
Thanks lot it's working fine now.
Regards,
Prakash.R
On Fri, Jun 28, 2019, 17:46 Fabrízio de Royes Mello
wrote:
>
> Em qui, 27 de jun de 2019 às 22:01, Prakash Ramakrishnan <
> prakash.ramakrishnan...@nielsen.com> escreveu:
>
>> Hi Fabrizo,
>>
>> After applying the update command getting this e
Hello,
I started an Analyze command on a database Wednesday evening at around
9:00PM. it is now Friday morning at 8:00 and it is still running.
If I execute the query:
select max(last_analyze) from pg_stat_user_tables;
The result I receive is:
6/27/2019 8:27 AM
So it appears that no analyze
Em qui, 27 de jun de 2019 às 22:01, Prakash Ramakrishnan <
prakash.ramakrishnan...@nielsen.com> escreveu:
> Hi Fabrizo,
>
> After applying the update command getting this error ,
>
> postg...@shacoyuhss001.enterprisenet.org:/home/postgres
> ==> psql
> psql (11.4, server 11.3)
> Type "help" for hel
Michael Paquier wrote on 06/27/2019 11:17:10 PM:
> From: Michael Paquier
> To: Brad Nicholson
> Cc: Grigory Smolkin , pgsql-
> gene...@lists.postgresql.org
> Date: 06/27/2019 11:17 PM
> Subject: [EXTERNAL] Re: Re: Enabling checksums on a streaming replica
>
> On Wed, Jun 26, 2019 at 02:08:19PM
16 matches
Mail list logo
