[PERFORM] Unable to find PostgreSQL 9.5.6 software in PostgreSQL site.

Dear expert, I have to download PostgreSQL 9.5.6 version for windows 64 bit. am unable to find this version in PostgreSQL site. Could anyone tell me how I can find this software. Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.

[PERFORM] How to grant only create schemas and create database objects permission to user.

Dear expert, I have to create a user which have permission to create schemas and create database objects in database. I am using postgres 9.1. Could you please assist me? Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.

[PERFORM] Rollback table data.

Dear Expert, Is there any way to rollback table data in PostgreSQL? Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. -- Mobile: +91-9953975849 | Ext 1078

Re: FW: Re: [PERFORM] Query is running very slow......

[mailto:tomas.von...@2ndquadrant.com] Sent: 25 May, 2017 9:08 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance@postgresql.org Subject: [EXTERNAL] Re: FW: Re: [PERFORM] Query is running very slow.. On 5/25/17 2:26 PM, Dinesh Chandra 12108 wrote: > Hi Tomas, > &

FW: Re: [PERFORM] Query is running very slow......

age- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Tomas Vondra Sent: 24 May, 2017 10:56 PM To: pgsql-performance@postgresql.org Subject: [EXTERNAL] Re: [PERFORM] Query is running very slow.. Hi, On 5/24/17 7:04 PM, Dinesh Chandra 12108

[PERFORM] Query is running very slow......

Dear Expert, While executing the blow query, its taking too long time to fetch output. Could you please help to fine tune the same? SELECT date_trunc('day', insert_time), workflow.project.project_name, workflow.tool_performance.project_id, workflow.tool_performance.user_id,

Re: [PERFORM] Log update query along with username who has executed the same.

com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Rick Otten [mailto:rottenwindf...@gmail.com] Sent: 23 May, 2017 6:19 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance@postgresql.org Subject: [EXTERNAL] Re: [PERFORM] Log update

[PERFORM] Log update query along with username who has executed the same.

Dear Expert, May you please provide the solution for below query. I have to create a log for all the update query executed in database along with its username who has executed that query. However, I am able to log all the update queries in my pg_log file but it's not showing particular user

[PERFORM] Create a materialized view in PostgreSQL which can be access by all the user account

Hi Experts, How can we create a materialized view in PostgreSQL which can be access by all the user account in all Database? Regards, Dinesh Chandra

Re: [PERFORM] Filter certain range of IP address.

han...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Rick Otten [mailto:rottenwindf...@gmail.com] Sent: 07 April, 2017 9:26 PM To: David G. Johnston <david.g.johns...@gmail.com> Cc: Dinesh Chandra 12108 <dinesh.chan...@cyient.com>; vinny <vi.

Re: [PERFORM] Filter certain range of IP address.

305,India. -Original Message- From: vinny [mailto:vi...@xs4all.nl] Sent: 07 April, 2017 7:52 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance-ow...@postgresql.org; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Filter certain range of IP address. On

[PERFORM] Filter certain range of IP address.

Hi expert, May I know how to select a range of IP address. Example: I have number of different-2 IP's present in a table. I have to select only that IP address which does not start from prefix "172.23.110". Thanks in advance Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)|

[PERFORM] How to send content of log file in official mailid.

Hi, I have to send content of a log file in my mail Id. Could you please assist me to do this? I am using Postgres-9.1 with Linux OS. Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. -- Mobile:

Re: [PERFORM] Auto generate number in Postgres-9.1.

| t -Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Josh Berkus Sent: Monday, March 20, 2017 6:43 AM To: Dinesh Chandra 12108; pgsql-performance-ow...@postgresql.org Cc: pgsql-performance@postgresql.org Subject

[PERFORM] Auto generate number in Postgres-9.1.

Dear expert, I have to add one column "ID" in postgres table which will generate Auto Incremented number . Example: Suppose I have five records and if I insert 1 new record It should auto generate 6. If I truncate the same table

Re: [PERFORM] Performance issue in PostgreSQL server...

reSQL)| Cyient Ltd. Noida. -Original Message- From: Justin Pryzby [mailto:pry...@telsasoft.com] Sent: 06 March, 2017 10:54 AM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: Nur Agus <nuragus.li...@gmail.com>; Jeff Janes <jeff.ja...@gmail.com>; pgsql-performanc

Re: [PERFORM] Performance issue in PostgreSQL server...

. From: Nur Agus [mailto:nuragus.li...@gmail.com] Sent: 03 March, 2017 5:54 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance issue in PostgreSQL server... Hello Dinesh, You can try the EXPLAIN tool psql=> EX

[PERFORM] Performance issue in PostgreSQL server...

Dear Experts, I need your suggestions to resolve the performance issue reported on our PostgreSQL9.1 production database having 1.5 TB Size. I have observed that, some select queries with order by clause are taking lot of time in execution and forcing applications to give slow response. The

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

<rottenwindf...@gmail.com>; Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? It'd be so nice to have some checks to guarantee the backup is trustworthy. Restoring th

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

] Sent: 02 March, 2017 6:45 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? This reminds me - I have had a case where the exit code for pg_dump was succ

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

] Sent: 27 February, 2017 7:31 PM To: John Gorman <jgor...@eldocomp.com> Cc: Rick Otten <rottenwindf...@gmail.com>; Dinesh Chandra 12108 <dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org; pgsql-performance-ow...@postgresql.org Subject: Re: [PERFORM] How Can I

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

ttenwindf...@gmail.com>; Dinesh Chandra 12108 <dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org; pgsql-performance-ow...@postgresql.org Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? On 2017-02-27 14:29, John Gorman wrote: > Even though i

[PERFORM] How Can I check PostgreSQL backup is successfully or not ?

Hi, We are taking daily full backup of PostgreSQL database using PG_DUMP which is automatic scheduled through Cronjobs. How can I check my yesterday backup is successfully or not? Is there any query or view by which I can check it? Regards, Dinesh Chandra |Database administrator

Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1.

. -- Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com<mailto:%7cdinesh.chan...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Luis Fernando Simone [mailto:luis.sim...@datacoper.com.br] Sent: 23 February, 2017 10:29 PM To: Dinesh Chandra

Re: [PERFORM] How to log quires which are taking time in PostgreSQL 9.1.

meter can be helpful in tracking down unoptimized queries in your applications. Only superusers can change this setting. On 02/23/2017 09:21 AM, Dinesh Chandra 12108 wrote: Dear expert, I want to log only that queries which are taking around 5 minutes to execute. I have a database size >1.

[PERFORM] How to log quires which are taking time in PostgreSQL 9.1.

Dear expert, I want to log only that queries which are taking around 5 minutes to execute. I have a database size >1.5T and using PostgreSQL 9.1 with Linux OS. Thanks in advance. Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.

Re: [PERFORM] Backup taking long time !!!

| Ext 1078 |dinesh.chan...@cyient.com<mailto:%7cdinesh.chan...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: 20 January, 2017 5:19 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyien

Re: [PERFORM] Backup taking long time !!!

. -- Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com<mailto:%7cdinesh.chan...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Madusudanan.B.N [mailto:b.n.madusuda...@gmail.com] Sent: 20 January, 2017 5:04 PM To: Dinesh Chandra 12108 <di

[PERFORM] Backup taking long time !!!

Hi Expert, I have a database having size around 1350 GB, created in PostgreSQL-9.1 in Linux platform. I am using pg_dump to take backup which takes around 12 hours to complete. Could you please suggest me how I can make my backup fast so that it complete in less hours? Thanks in advance.

[PERFORM] Invalid page header in block 25561983 of relation pg_tblspc

Dear Expert, I am getting the below error in my database. ERROR: invalid page header in block 25561983 of relation pg_tblspc/55703433/PG_9.1_201105231/55703436/113490260 Can you please suggest me how to resolve it? I think its related to block corruption. How can I find particular block in

[PERFORM] How to vacuum entire database excluding some tables in PostgreSQL9.1.

Dear Expert, Could you please suggest me for the below query? I want to vacuum the entire database with the exception of several tables. Because there are some tables which are very big in size, so I just want to exclude them. Thanks in advance. Regards, Dinesh Chandra |Database

Re: [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1.

, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. -Original Message- From: Mark Kirkwood [mailto:mark.kirkw...@catalyst.net.nz] Sent: 17 December, 2016 7:28 AM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org Subject: Re: [PERFORM

[PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1.

Dear expert, In postgreSQL-9.1,the size of pgsql_tmp inside tablespace (Temp tablespace) is increased by 544G in one day. However, the DBsize is as usual but tablespace size is getting increased. Could you please suggest why it is happening ? Regards, Dinesh Chandra |Database administrator