Re: trigger impacting insertion of records

#PostGreSQL: idle in transaction^^2021-05-06 18:06:12 PDT^^bonzipay^^usmliv1^^127.0.0.1(38435)^^60949111.16a5^^2021-05-06 18:00:01 PDTLOG: unexpected EOF on client connection with an open transaction Please suggest the solution to troubleshoot it more. Rega

Re: idle_in_transaction_session_timeout

ok, But what is the workaround of this parameter in postgres 9.5, ,I need to increase the time of "idle in transaction" transactions. Regards, Atul On 5/7/21, luis.robe...@siscobra.com.br wrote: > > - Mensagem original ----- >> De: "Atul Kuma

strange behavior of WAL files

HI, We have a centos 6 enviornment where postgres 9.6 is running on it. We have strange behavior of WAL files of pg_xlog directory As we have set archive_command to archive WAL files at different location and the archive_command is working fine. So strange behavior is : We have a WAL file say

Re: strange behavior of WAL files

my query is Why is this happening ? please help me with your suggestions. Regards. On 6/4/21, Jehan-Guillaume de Rorthais wrote: > On Fri, 4 Jun 2021 15:39:30 +0530 > Atul Kumar wrote: > >> HI, >> >> We have a centos 6 enviornment where postgres 9.6 is runni

Re: strange behavior of WAL files

On 6/4/21, Tom Lane wrote: > Atul Kumar writes: >> once old WAL files of pg_xlog directory are archived in >> '/nfslogs/wal/' directory then these WAL files are getting generated >> with the same name in pg_xlog directory. > > Are you sure you a

Re: strange behavior of WAL files

, Tom Lane wrote: > Atul Kumar writes: >> once old WAL files of pg_xlog directory are archived in >> '/nfslogs/wal/' directory then these WAL files are getting generated >> with the same name in pg_xlog directory. > > Are you sure you are describing the behav

base directory size getting increased

Hi, I have a query from which I am trying to export the data into a csv file(around 10 lakhs record) but when I am doing so the base sub directory size of data directory is getting increased. can someone help me in telling 'why base sub directory size is getting increased'? my postgres version

Re: base directory size getting increased

telling how do I clean that 87GB of space of pgsql_tmp directory. Regards, Atul On 6/7/21, Laurenz Albe wrote: > On Mon, 2021-06-07 at 16:11 +0530, Atul Kumar wrote: >> I have a query from which I am trying to export the data into a csv >> file(around 10 lakhs record) but

Re: base directory size getting increased

Hi Sir, I don’t think there is any old connection connected as there is no process I found from pg_stat_activity. Is there any other way to trace out such sessions. Regards Atul On Monday, June 7, 2021, Ravi Krishna wrote: > > > > initially pgsql_tmp size was 87 GB and after execution

Re: base directory size getting increased

at 17:48 +0530, Atul Kumar wrote: > > initially pgsql_tmp size was 87 GB and after execution of query it was > > started increasinng beyond 87GBs so yes, pgsql_tmp directory size is > > getting increased while exporting data into csv file. > > > > But once I rolled ba

query issue

Hi, I have postgres 10 running on RDS instance. I have query below: select * from "op_KFDaBAZDSXc4YYts9"."UserFeedItems" where (("itemType" not in ('WELCOME_POST', 'UPLOAD_CONTACTS', 'BROADCAST_POST')) and ("userId" = '5d230d67bd99c5001b1ae757' and "is_deleted" in (true, false))) order by "score

Re: query issue

well with these parameters. Regards. On 6/15/21, Jehan-Guillaume de Rorthais wrote: > On Tue, 15 Jun 2021 16:12:11 +0530 > Atul Kumar wrote: > >> Hi, >> >> I have postgres 10 running on RDS instance. >> >> I have query below: > [...] >

Re: query issue

Items"."userId" = '5d230d67bd99c5001b1ae757'::text) AND ("UserFeedItems"."itemType" <> ALL ('{WELCOME_POST,UPLOAD_CONTACTS,BROADCAST_POST}'::text[]))) Rows Removed by Filter: 15478 Buffers: shared hit=4838 read=37

clear cache in postgresql

Hi, I have an postgres 10 instance on RDS. Sometimes I run a Postgres query it takes 30 seconds. Then, I immediately run the same query and it takes 2 seconds. It appears that Postgres has some sort of caching. Can I somehow see what that cache is holding? Can I force all caches to be cleared for

user privileges

Hi, My question can be silly but I need to ask that if a user is created without login privilege then what is the use of below command why don't postgres prompt error on it CREATE ROLE nolog_user WITH PASSWORD 'pass1'; as the user is created with login privileges then what is the use such user ?

[no subject]

Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '

Re:

newregeventid, l_newseasonid, false ); :new.iregeventid := l_newregeventid; :new.iseasonid := l_newseasonid; --} END IF; END$trigger$ samparticipantctimestamp BEFORE INSERT ON sam_participant FOR EACH ROW $trigger$BEGIN :NEW.dCreatedTime

Re:

Index Cond: ((icontainerid = '15257396'::numeric) AND (imemberid = m.imemberid)) Buffers: shared hit=75 Planning time: 7.206 ms Execution time: 6741.891 ms (56 rows) The query I shared has been calling one function also (function name: getGroupId()) Below

number of wal file is not reduced.

Hi, I have postgres 9.6 running server on centos 7, the number of wal file in pg_xlog directory is above 4000 so to save some disk space, I thought of reducing to 100. but there is no reduction in numbers. Please not that there is no replication is configured, the server is independent. What I

wal_keep_segments and max_wal_size

hi, (on postgres 9.6) I was just practicing to make my no. of wal files in pg_xlog directory to be the same/equal as I pass on wal_keep_segments paramater. say for example show wal_keep_segments; wal_keep_segments --- 125 so I want my wal files should not be grow in numbers mo

Re: number of wal file is not reduced.

:18:14PM +0530, Atul Kumar wrote: >> I have postgres 9.6 running server on centos 7, the number of wal file >> in pg_xlog directory is above 4000 so to save some disk space, I >> thought of reducing to 100. > ... >> Please suggest when the number of wal files will be redu

optimization issue

Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '

Re: optimization issue

Hi Lewis, I am new to postgres. Could you tell me how should I put the result on an analyzed temp table at least ? Please suggest. Regards. On Thursday, July 8, 2021, Michael Lewis wrote: > ((current_setting('env.groupid'::text))::integer)::numeric > > If you pass this value in directl

Re: optimization issue

Hi, Could you suggest me how should I teduce the heap blocks to optimise the query ? Regards. On Thursday, July 8, 2021, Atul Kumar wrote: > Hi, > > I have one query like below : > > > SELECT >

pganalyze setup

Hi, Could you provide me any link or blog to install and configure pganalyze setup on centos 7 machine. Also please let me whether pganalyze is an open source or not. Regards.

Re:

Hi, You can try to make a batch script in windows for taking incremental backup and schedule it in windows scheduler. Regards Atul On Friday, August 27, 2021, obi reddy wrote: > Hi everyone. > > how to take incremental backup in postgresql windows machine. > > > Thank you And Regards >

java.lang.ClassNotFoundException: batchprint.Batch

Hi, I have a function with below definition: CREATE OR REPLACE FUNCTION onesam.batchprint_individual( p1 character varying, p2 character varying, p3 character varying, p4 boolean, p5 boolean, p6 character varying, p7 integer, p8 integer) RETURNS integer LANGUAGE 'javau' COST 100 V

PostgreSQL's Max Identifier Length in Amazon RDS

Hi, Could someone help me in telling : how to increase Max Identifier Length in amazon RDS.running instance on postgres 10 ? I couldn't find the blog related to it so far, So kindly suggest. Regards, Atul

Re: Wal file query

it following link : > https://www.crunchydata.com/blog/postgres-wal-files-and-sequuence-numbers > > > Thanks > > Kashif Zeeshan > > > > On Tue, Apr 8, 2025 at 4:44 PM Atul Kumar wrote: > >> In streaming replication What is the way to check which "WAL file" is >> currently in use in primary and in standby ? >> >> >> Regards. >> >

Wal file query

In streaming replication What is the way to check which "WAL file" is currently in use in primary and in standby ? Regards.

No. Of wal files generated

Hi, Please could you help me by sharing any redhat linux command through which I can count the no. of wal files and no. of ".ready" files generated in last 10 minutes. Regards, Atul

Re: No. Of wal files generated

nk about using PgBackRest instead of > something you wrote yourself. > > On Fri, Mar 7, 2025 at 2:47 PM Atul Kumar wrote: > >> I want to check and compare the speed wal file generation process and >> archival process. >> >> So I want to check how many wal file got cre

Re: No. Of wal files generated

025 at 10:59 AM Atul Kumar wrote: > >> Hi, >> >> Please could you help me by sharing any redhat linux command through >> which I can count the no. of wal files and no. of ".ready" files generated >> in last 10 minutes. >> > > What problem are

<    1   2