Re: [PERFORM] Hi

Hello, Would I request to help me on this query. SELECT 'Inspection Completed' as "ALL Status" ,COUNT(*) as "Number of Count" FROM ud_document WHERE status = 'Inspection Completed' union SELECT 'Pending', COUNT(*) FROM ud_document WHERE status = 'Pending' union SELECT 'Approved', COUNT(*) FROM

[PERFORM] Create view

Dear team, Can you please let me know how we can create a view using db link, A base table column having serial datatype. And we want to create a view of that table on server B. But unable to create and getting the below issue. Error: ERROR: type "serial" does not exist LINE 17: as roaster_tes

[PERFORM] How to access data of SQL server database from PostgreSQL

Hi team, I need to connect to MS-SQL server 2008/2012 from PostgreSQL 9.5 in Windows7 environment to fetch the tables of SQL server. Please help on this. Regards, Daulat DISCLAIMER: This email message is for the sole use of the intended recipient(s) and ma

[PERFORM] CREATE EXTENSION postgis;

Hi team, Is this possible to create the postgis extension by CREATE EXTENSION postgis; in PostgreSQL 9.1 As I know the template_postgis database is created by default during postgis installation to support the spatial objects. I am getting below the error messages while creating postgis exten

Re: [PERFORM] Unable to start the slave instance

- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: 05 July, 2017 6:40 PM To: Daulat Ram Cc: pgsql-performance@postgresql.org Subject: [EXTERNAL]Re: [PERFORM] Unable to start the slave instance On Wed, Jul 5, 2017 at 3:26 AM, Daulat Ram wrote: > Hi experts, > > We have con

[PERFORM] Unable to start the slave instance

Hi experts, We have configured a replication environment in Windows 10. But I am getting below the error messages while starting slave instance. Error: 2017-07-05 00:00:02 IST LOG: restored log file "00010022" from archive 2017-07-05 00:00:02 IST LOG: WAL file is from differen

[PERFORM] Unable to start the slave instance

Hi experts, We have configured a replication environment in Windows 10. But I am getting an error below the error messages while starting slave instance. Error: 2017-07-05 00:00:02 IST LOG: restored log file "00010022" from archive 2017-07-05 00:00:02 IST LOG: WAL file is from

[PERFORM] Query is very much slow

Hi team, We are getting very slow response of this query. SELECT date_trunc('day', insert_time),workflow.project.project_name, workflow.tool_performance.project_id,workflow.tool_performance.user_id,workflow.tool_performance.step_id,count(*), round(sum(execution_time)/1000) as Sum_time_sec,round(

[PERFORM] Hi

Hello, I need to know the criteria behind for settings the work_mem in PostgreSQL, please give the example also if possible. Regards, Daulat