From janio_2003@yahoo.com.br Sun Jun 20 16:40:23 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B3EC0D1B1C9 for ; Sun, 20 Jun 2004 13:40:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68428-09 for ; Sun, 20 Jun 2004 16:40:20 +0000 (GMT) Received: from smtp013.mail.yahoo.com (smtp013.mail.yahoo.com [216.136.173.57]) by svr1.postgresql.org (Postfix) with SMTP id F3D90D1B1B7 for ; Sun, 20 Jun 2004 13:40:19 -0300 (ADT) Received: from unknown (HELO pc02) (janio?2003@200.227.209.138 with login) by smtp013.mail.yahoo.com with SMTP; 20 Jun 2004 16:40:13 -0000 Message-ID: <039601c456e5$437b4c70$0200a8c0@pc02> From: "Janio Rosa da Silva" To: Subject: Hi! Date: Sun, 20 Jun 2004 13:39:38 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0373_01C456CC.08598C60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, HTML_20_30, HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: * X-Archive-Number: 200406/206 X-Sequence-Number: 7264 This is a multi-part message in MIME format. ------=_NextPart_000_0373_01C456CC.08598C60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am trying install the postgresql-7.4.3 simple installation. I did ./confi= gure command at the postgresql directory source. While the configuring proc= cess I receiving the follow message: checking for tar... /bin/tar checking for strip... strip checking whether it is possible to strip libraries... yes checking for bison... bison -y *** The installed version of Bison is too old. PostgreSQL needs *** Bison version 1.875 or later. checking for perl... /usr/bin/perl checking for main in -lbsd... no checking for setproctitle in -lutil... no checking for main in -lm... yes But, after this message the install proccess continue like this message. Th= e problem is that the installation never finish. I am thinking that the con= figure proccess is in loop. Have it anything relation with my hardware conf= iguration? The computer where I did this is: AMD K6-II 200 MHZ; 64 MB memo= ry; I would like why the configure proccess never finish. Regards, Janio ------=_NextPart_000_0373_01C456CC.08598C60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I am trying install the postgresql-7.4.3 s= imple=20 installation. I did ./configure command at the postgresql directory source.= =20 While the configuring proccess I receiving the follow message:

checking for tar... /bin/tar
checking f= or=20 strip... strip
checking whether it is possible to strip libraries...=20 yes
checking for bison... bison -y
*** The installed version of Bison= is=20 too old. PostgreSQL needs
*** Bison version 1.875 or later.
che= cking=20 for perl... /usr/bin/perl
checking for main in -lbsd... no
checking f= or=20 setproctitle in -lutil... no
checking for main in -lm... yes

But, after this message the install procce= ss=20 continue like this message. The problem is that the installation never fini= sh. I=20 am thinking that the configure proccess is in loop. Have it anything relati= on=20 with my hardware configuration? The computer where I did this is: AMD= =20 K6-II 200 MHZ; 64 MB memory;
I would like why the configure proccess nev= er=20 finish.

Regards,

Janio

------=_NextPart_000_0373_01C456CC.08598C60-- From josh@agliodbs.com Tue Jun 22 16:24:07 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B9B56D1B19C for ; Tue, 22 Jun 2004 13:24:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43207-09 for ; Tue, 22 Jun 2004 16:24:02 +0000 (GMT) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id A5F65D1B1C8 for ; Tue, 22 Jun 2004 13:24:01 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 5450198; Tue, 22 Jun 2004 09:25:40 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Janio Rosa da Silva" , Subject: Re: Hi! Date: Tue, 22 Jun 2004 09:23:26 -0700 User-Agent: KMail/1.4.3 References: <039601c456e5$437b4c70$0200a8c0@pc02> In-Reply-To: <039601c456e5$437b4c70$0200a8c0@pc02> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200406220923.26779.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/227 X-Sequence-Number: 7285 Janio, > I am trying install the postgresql-7.4.3 simple installation. I did > ./configure command at the postgresql directory source. While the > configuring proccess I receiving the follow message: This is the wrong list for this question. Please try PGSQL-ADMIN. You're much more likely to get help there. Sorry! -- Josh Berkus Aglio Database Solutions San Francisco From Daulat.Ram@cyient.com Thu Apr 13 06:25:17 2017 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cyYCG-0003F2-4y for pgsql-performance@arkaria.postgresql.org; Thu, 13 Apr 2017 06:25:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cyYCD-000344-SW for pgsql-performance@arkaria.postgresql.org; Thu, 13 Apr 2017 06:25:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cyYCC-00033A-Op for pgsql-performance@postgresql.org; Thu, 13 Apr 2017 06:25:32 +0000 Received: from mxgate01.infotech-enterprises.com ([110.76.168.168] helo=mxgate01.cyient.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cyYC4-0008Kd-4l for pgsql-performance@postgresql.org; Thu, 13 Apr 2017 06:25:31 +0000 X-IronPort-AV: E=Sophos;i="5.37,193,1488825000"; d="scan'208,217";a="69185284" Received: from unknown (HELO CYMADFPBSMTP) ([172.17.1.108]) by mxgate01.cyient.com with ESMTP; 13 Apr 2017 11:37:45 +0530 Received: from CYMADFPBSMTP.CORP.CYIENT.COM (CYMADFPBSMTP.CORP.CYIENT.COM [127.0.0.1]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id 5A42F81C22C4 for ; Thu, 13 Apr 2017 11:51:49 +0530 (IST) Received: from CYINMBX1.CORP.CYIENT.COM (unknown [172.17.4.161]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id 47F8881C22BC for ; Thu, 13 Apr 2017 11:51:49 +0530 (IST) Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX1.CORP.CYIENT.COM (172.17.4.161) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.27; Thu, 13 Apr 2017 11:55:17 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465]) by CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465%19]) with mapi id 15.01.0544.027; Thu, 13 Apr 2017 11:55:17 +0530 From: Daulat Ram To: "pgsql-performance@postgresql.org" Subject: Hi Thread-Topic: Hi Thread-Index: AdK0Hn5c1i8HeoH5S9e3nSKkBtafcA== Date: Thu, 13 Apr 2017 06:25:17 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.81] Content-Type: multipart/alternative; boundary="_000_cd6bfba7aab34d3e805b62a986e2ade3cyientcom_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.1 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_000_cd6bfba7aab34d3e805b62a986e2ade3cyientcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, I need to know the criteria behind for settings the work_mem in PostgreSQL,= please give the example also if possible. Regards, Daulat --_000_cd6bfba7aab34d3e805b62a986e2ade3cyientcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

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

Regards,

Daulat

--_000_cd6bfba7aab34d3e805b62a986e2ade3cyientcom_-- From glynastill@yahoo.co.uk Thu Apr 13 08:21:53 2017 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cya12-00074q-4G for pgsql-performance@arkaria.postgresql.org; Thu, 13 Apr 2017 08:22:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cya11-0003c2-7L for pgsql-performance@arkaria.postgresql.org; Thu, 13 Apr 2017 08:22:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cya10-0003bj-7V for pgsql-performance@postgresql.org; Thu, 13 Apr 2017 08:22:06 +0000 Received: from nm1-vm6.bullet.mail.ir2.yahoo.com ([212.82.96.77]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cya0s-00027C-Gy for pgsql-performance@postgresql.org; Thu, 13 Apr 2017 08:22:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1492071714; bh=Nn8YOMaV7kb35HTR1ZKoa4BTxZupjMDYie6Fzqd+hK0=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=EwefCy4dNnJ7nyNTm8dfwXLoy3tUxvB6TKOaRKm0J+fsNItaOgJtK756sMlFljZkBk16FUNQrHjleh7hT58wPbJeDFUMhuYCaO/2EUBgnYI1jMhVcwMOibZH6vMw3ZoG3x14uNA7LFpXzC9JYuBvoStF/dyyy78cZdoeu7noqpQNziiBHOCKG5TaHEgWMv4nIGpUiaQ9944HaEtI/w/duuzuZFzozOGqZQejDSjjHgBDYAHentCKi8rcroH9XzudVh0ZbZXAxDyzZ4Yy0Y7uyW8zseHVbrEhPqhM4fFL5nsCxtPin5gX/PgehaOU/1v0/+MzWvIWYpefZxFU+WEgKg== Received: from [212.82.98.124] by nm1.bullet.mail.ir2.yahoo.com with NNFMP; 13 Apr 2017 08:21:54 -0000 Received: from [212.82.98.104] by tm17.bullet.mail.ir2.yahoo.com with NNFMP; 13 Apr 2017 08:21:54 -0000 Received: from [127.0.0.1] by omp1041.mail.ir2.yahoo.com with NNFMP; 13 Apr 2017 08:21:54 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 773004.63303.bm@omp1041.mail.ir2.yahoo.com X-YMail-OSG: e7uTwNoVM1kI.JygHc83regzhdRvqkzsyOQRDCnuCqXYjjxLeimzvY.iXA5EQ8x JJiX5DX3zf8UJ.7XeodkmeEI4i0BstJxs8UZFR37MHykrqQFm96clcRBVNPO3F8D_8HLrqMNTg_Y S4Y1fsxllXyvBCItc.ycw2ysCbdpTS0HyqCQEGTklGg53CHPKhRwwFD5eVZrZeIK_t4U052ia1qX vCumkjuqVdSKji_v2aieDUQSl80TAqIUpfjUfLENsVxCXufsqEAFO8T0s6YtlQ5jSZ7dVDSkaxf3 Aul74qAlxWd3L1RrIS4pK3MEFkPIsdT4.aXBvZtpZnqUj.ah1U5.KYh0LsN0lGIDn1HyLsUEBsdf x73fxITuQOa1rzvr5Ou9FqFj7WKcW__d3Zl0mI4Y6maIMvGwtLYW6LJ2YzOu8NolvA.MWBu.5j_G pucPo7ldPAOt5QsGq8cSFYxa1a.GBSPJBnmo67wP7QUh7HsQL9vNvA4MCUbI1TfMKmzcK3rLQusY .uB18HhAGtoGfrumgcPfA3qQh5anjSQ-- Received: from jws700037.mail.ir2.yahoo.com by sendmailws165.mail.ir2.yahoo.com; Thu, 13 Apr 2017 08:21:54 +0000; 1492071714.238 Date: Thu, 13 Apr 2017 08:21:53 +0000 (UTC) From: Glyn Astill Reply-To: Glyn Astill To: Daulat Ram , "pgsql-performance@postgresql.org" Message-ID: <811150671.1545494.1492071713992@mail.yahoo.com> In-Reply-To: References: Subject: Re: Hi MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Mailer: WebService/1.1.9386 YahooMailNeo Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0 Content-Length: 1318 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > From: Daulat Ram > To: "pgsql-performance@postgresql.org" > Sent: Thursday, 13 April 2017, 7:25 > Subject: [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 Is there anything in particular from the manual pages you don't understand? It should be quite clear: https://www.postgresql.org/docs/current/static/runtime-config-resource.html "Specifies the amount of memory to be used by internal sort operations and hash tables before writing to temporary disk files. The value defaults to four megabytes (4MB). Note that for a complex query, several sort or hash operations might be running in parallel; each operation will be allowed to use as much memory as this value specifies before it starts to write data into temporary files." "Also, several running sessions could be doing such operations concurrently. Therefore, the total memory used could be many times the value of work_mem; it is necessary to keep this fact in mind when choosing the value. Sort operations are used for ORDER BY, DISTINCT, and merge joins. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN subqueries." Glyn -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance From Daulat.Ram@cyient.com Fri Aug 25 06:49:07 2017 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dl8R4-0003C5-94 for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 06:49:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dl8R2-0006gI-OT for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 06:49:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dl8R1-0006bN-TM for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 06:49:40 +0000 Received: from mxgate02.infotech-enterprises.com ([110.76.160.160] helo=mxgate02.cyient.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dl8Qs-0001zb-Jy for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 06:49:37 +0000 X-IronPort-AV: E=Sophos;i="5.41,424,1498501800"; d="scan'208,217";a="1230588" Received: from unknown (HELO CYMADFPASMTP) ([172.17.1.107]) by mxgate02.cyient.com with ESMTP; 25 Aug 2017 12:19:36 +0530 Received: from CYMADFPASMTP.CYIENT.COM (CYMADFPASMTP.CYIENT.COM [127.0.0.1]) by CYMADFPASMTP.CYIENT.COM (Service) with ESMTP id CF411C11CF0A for ; Fri, 25 Aug 2017 13:16:50 +0300 (IDT) Received: from CYINMBX5.CORP.CYIENT.COM (unknown [172.17.4.165]) by CYMADFPASMTP.CYIENT.COM (Service) with ESMTP id BD278C11CF03 for ; Fri, 25 Aug 2017 13:16:50 +0300 (IDT) Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX5.CORP.CYIENT.COM (172.17.4.165) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.27; Fri, 25 Aug 2017 12:19:07 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::7d7a:c752:6561:9895]) by CYINMBX4.CORP.CYIENT.COM ([fe80::7d7a:c752:6561:9895%19]) with mapi id 15.01.0544.027; Fri, 25 Aug 2017 12:19:07 +0530 From: Daulat Ram To: "pgsql-performance@postgresql.org" Subject: Re: Hi Thread-Topic: Hi Thread-Index: AdK0Hn5c1i8HeoH5S9e3nSKkBtafcBpT5OMg Date: Fri, 25 Aug 2017 06:49:07 +0000 Message-ID: <8476a0511c074ddd9eaf15a3eb2e71ce@cyient.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.81] Content-Type: multipart/alternative; boundary="_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_" MIME-Version: 1.0 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 =3D 'Inspection Completed' union SELECT 'Pe= nding', COUNT(*) FROM ud_document WHERE status =3D 'Pending' union SELECT '= Approved', COUNT(*) FROM ud_document WHERE status =3D 'Approved' union SELE= CT 'Rejected', COUNT(*) FROM ud_document WHERE status =3D 'Rejected' union = SELECT 'Payment Due',count(*) from ud_document where payment_status =3D 'Pa= yment Due' union SELECT 'Payment Done' ,count(*) from ud_document where pay= ment_status =3D 'Payment Done' And now I want to exclude the uniqueid=3D '201708141701018' from the above = query. how it can be ??? Regards, Daulat ________________________________ DISCLAIMER: This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies = of the original message. Check all attachments for viruses before opening t= hem. All views or opinions presented in this e-mail are those of the author= and may not reflect the opinion of Cyient or those of our affiliates. --_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

Would I request to hel= p me on this query.

SELECT 'Inspection Com= pleted' as "ALL Status" ,COUNT(*) as "Number of Count" = FROM ud_document WHERE status =3D 'Inspection Completed' union SELECT 'Pend= ing', COUNT(*) FROM ud_document WHERE status =3D 'Pending' union SELECT 'Approved', COUNT(*) FROM ud_document WHERE status =3D 'Approved' u= nion SELECT 'Rejected', COUNT(*) FROM ud_document WHERE status =3D 'Rejecte= d' union SELECT 'Payment Due',count(*) from ud_document where payment_statu= s =3D 'Payment Due' union SELECT 'Payment Done' ,count(*) from ud_document where payment_status =3D 'Payment Done'&n= bsp;

And now I want to excl= ude the uniqueid=3D '201708141701018' from the above query. how it can be ?= ??

Regards,

Daulat

DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies of the original message. Check all a= ttachments for viruses before opening them. All views or opinions presented= in this e-mail are those of the author and may not reflect the opinion of = Cyient or those of our affiliates.
--_000_8476a0511c074ddd9eaf15a3eb2e71cecyientcom_-- From david.g.johnston@gmail.com Fri Aug 25 14:42:20 2017 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dlFoX-0007hB-VA for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 14:42:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dlFoX-0003sA-D8 for pgsql-performance@arkaria.postgresql.org; Fri, 25 Aug 2017 14:42:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dlFoW-0003s1-S4 for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 14:42:25 +0000 Received: from mail-qk0-x22f.google.com ([2607:f8b0:400d:c09::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dlFoT-0003bZ-Qc for pgsql-performance@postgresql.org; Fri, 25 Aug 2017 14:42:23 +0000 Received: by mail-qk0-x22f.google.com with SMTP id a77so38696qkb.1 for ; Fri, 25 Aug 2017 07:42:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=C80gHvfLlbd8qzjD+Si8iviNZ5gMLQjk2m+LaaxAzS4=; b=Vw8z1QD3Fc/+aRDMPbvr5qDDlUyZHe4HMrucEEUww569uh3gb0NbYU2lgZ7ow51D16 XfKrnfCPgV51bpFWw+VVUrACqCJDxVfQO1XpVCnlifcwNJwDUHU1LmDmXYJCURH0sRQH 1PjXXpNdkjfrX4ECkzD51Um70iOWPyn1xZVSATzilLgIQsADif1QY/tkBELiEQ4SUcPO eJEU23D9CZ62myh0+1ZTmJdXF/6EUqqUWDIW5KXKf1Uktb+hiUpfbP3EDDTuczzeEQD1 APVrTfsjVENGlydi45Gw52XQPyTlg4A/Tle2VisDcYqaRHS6wAL2Fhrf8KheeoppLNMz lOmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=C80gHvfLlbd8qzjD+Si8iviNZ5gMLQjk2m+LaaxAzS4=; b=EXQgOrHr/5HSOKN6ezGTANuLlHBTA4tSVLjaWicBd15UFlJ3PioiJH8KJZTlxHEwgh JsohEOwAPn4f7wP26IVfVm3qludSdD8mnsGWN5xapHgGn5eOsDMJ7g+iWeiF8Q/VVSmO qbEZjxXrq4TTP4e0iS9f3m8UVVH6YU4vyYbtpKpoqHnNl/y2mXghQZ4uW6j+Osd3yyxb 9h7HZVcFw3oF1jKsM9dz56Sx2cvGlC3PcssIpJDOzQhAL9vmP2bpOMqj2m/Qs5bKdvtp +g4NDX2FXqlA50ntwGN+p+tMLDzNqn0iovCRpLqekESvDHl9lV0hmZZJgq9cRBT+DAfB GOYg== X-Gm-Message-State: AHYfb5hVJaQ2dxUt1LF6w/06Bmm1ulPIOSli+Vcs+Fg327DeQ6CFi1cO LMLarcC0c2BSxe/8gCvHq8l4tqKynz01 X-Received: by 10.55.65.134 with SMTP id o128mr14556025qka.161.1503672140919; Fri, 25 Aug 2017 07:42:20 -0700 (PDT) MIME-Version: 1.0 Received: by 10.12.193.209 with HTTP; Fri, 25 Aug 2017 07:42:20 -0700 (PDT) In-Reply-To: <8476a0511c074ddd9eaf15a3eb2e71ce@cyient.com> References: <8476a0511c074ddd9eaf15a3eb2e71ce@cyient.com> From: "David G. Johnston" Date: Fri, 25 Aug 2017 07:42:20 -0700 Message-ID: Subject: Re: Hi To: Daulat Ram Cc: "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary="001a1148a0bed17bad055794f39f" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a1148a0bed17bad055794f39f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Aug 24, 2017 at 11:49 PM, Daulat Ram wrote: > 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 =3D 'Inspection Completed' union SEL= ECT > 'Pending', COUNT(*) FROM ud_document WHERE status =3D 'Pending' union SEL= ECT > 'Approved', COUNT(*) FROM ud_document WHERE status =3D 'Approved' union > SELECT 'Rejected', COUNT(*) FROM ud_document WHERE status =3D 'Rejected' > union SELECT 'Payment Due',count(*) from ud_document where payment_status= =3D > 'Payment Due' union SELECT 'Payment Done' ,count(*) from ud_document wher= e > payment_status =3D 'Payment Done' > > > > And now I want to exclude the uniqueid=3D '201708141701018' from the abov= e > query. how it can be ??? > > > =E2=80=8BYour use of UNION here seems necessary. Just write a normal GROUP= BY aggregation query. You might need to get a bit creative since you are collapsing status and payment_status into a single column. "CASE ... WHEN ... THEN ... ELSE ... END" is quite helpful for doing stuff like that. For now I'll just leave them as two columns. =E2=80=8BSELECT status, payment_status, count(*) FROM ud_document WHERE uniqueid <> '201708141701018' GROUP BY 1, 2; David J. --001a1148a0bed17bad055794f39f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Thu, Au= g 24, 2017 at 11:49 PM, Daulat Ram <Daulat.Ram@cyient.com> wrote:

Hello, <= /span>

=C2=A0

Would I request to hel= p me on this query.

=C2=A0

SELECT 'Inspection= Completed' as "ALL Status" ,COUNT(*) as "Number of Coun= t" FROM ud_document WHERE status =3D 'Inspection Completed' un= ion SELECT 'Pending', COUNT(*) FROM ud_document WHERE status =3D &#= 39;Pending' union SELECT 'Approved', COUNT(*) FROM ud_document WHERE status =3D '= ;Approved' union SELECT 'Rejected', COUNT(*) FROM ud_document W= HERE status =3D 'Rejected' union SELECT 'Payment Due',count= (*) from ud_document where payment_status =3D 'Payment Due' union S= ELECT 'Payment Done' ,count(*) from ud_document where payment_status =3D 'Payment= Done'=C2=A0

=C2=A0

And now I want to excl= ude the uniqueid=3D '201708141701018' from the above query. how it = can be ???

=E2=80=8BYour use of UNION here seems necessary.=C2=A0 Just write a nor= mal GROUP BY aggregation query.=C2=A0 You might need to get a bit creative = since you are collapsing status and payment_status into a single column. = =C2=A0"CASE ... WHEN ... THEN ... ELSE ... END" is quite helpful = for doing stuff like that.=C2=A0 For now I'll just leave them as two co= lumns.

=E2=80=8BSELECT status, payment_status,= count(*)

FROM ud_document

WHERE uniqueid <> '20= 1708141701018'

GROUP BY 1, 2;

David J.

--001a1148a0bed17bad055794f39f--