[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 |dinesh.chan...@cyient.com

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

e- From: Tomas Vondra [mailto:tomas.von...@2ndquadrant.com] Sent: 25 May, 2017 9:08 PM To: Dinesh Chandra 12108 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, > > Please f

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

d, Noida - 201 305,India. -Original Message- 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.. H

[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, workflow.tool_performa

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 Cc: pgsql-performance@postgresql.org Subject: [EXTERNAL] Re: [PERFORM] Log update query along with username who has ex

[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 who

[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 Cc: Dinesh Chandra 12108 ; vinny ; pgsql-performance-ow...@postgresql.org; pgsql-performance@postgresql.org Subje

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 Cc: pgsql-performance-ow...@postgresql.org; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Filter certain range of IP address. On 2017-04-07 16:13, Dinesh Chandra 12108 w

[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.

alled | boolean | 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@postg

[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...

trator (Oracle/PostgreSQL)| Cyient Ltd. Noida. -Original Message- From: Justin Pryzby [mailto:pry...@telsasoft.com] Sent: 06 March, 2017 10:54 AM To: Dinesh Chandra 12108 Cc: Nur Agus ; Jeff Janes ; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance issue in PostgreSQL

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

,Noida-Dadri Road, Noida - 201 305,India. From: Nur Agus [mailto:nuragus.li...@gmail.com] Sent: 03 March, 2017 5:54 PM To: Dinesh Chandra 12108 Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance issue in PostgreSQL server... Hello Dinesh, You can try the EXPLAIN tool psql=&g

[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 co

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

kups. Sent from my BlackBerry 10 smartphone. From: Rick Otten Sent: Thursday, March 2, 2017 08:19 To: Dinesh Chandra 12108 Cc: pgsql-performance@postgresql.org<mailto:pgsql-performance@postgresql.org> Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? This remi

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

] Sent: 02 March, 2017 6:45 PM To: Dinesh Chandra 12108 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 successful, but the backup was still corrupted on

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

] Sent: 27 February, 2017 7:31 PM To: John Gorman Cc: Rick Otten ; Dinesh Chandra 12108 ; 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: > Ev

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

. -- Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. -Original Message- From: vinny [mailto:vi...@xs4all.nl] Sent: 27 February, 2017 7:31 PM To: John Gorman Cc: Rick Otten ; Dinesh Chandra 12108 ; pgsql-performance

[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 (Oracle/Postgre

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 Cc: Madusudanan.B.N ; pgsql-perfo

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 Cc:

[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. Regar

[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 which

[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 administrator

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 ; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Size of Temporary tablespace is

[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 (Ora