Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YWPFW-0007tf-9z for pgsql-performance@arkaria.postgresql.org; Fri, 13 Mar 2015 13:03:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YWPFV-0002gQ-JA for pgsql-performance@arkaria.postgresql.org; Fri, 13 Mar 2015 13:03:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YWPFS-0002Ze-2k for pgsql-performance@postgresql.org; Fri, 13 Mar 2015 13:03:30 +0000 Received: from mail-oi0-x233.google.com ([2607:f8b0:4003:c06::233]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YWPFL-0002zt-8y for pgsql-performance@postgresql.org; Fri, 13 Mar 2015 13:03:27 +0000 Received: by oiba3 with SMTP id a3so9664719oib.1 for ; Fri, 13 Mar 2015 06:03:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zetainteractive.com; s=google; h=reply-to:from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to:cc:content-type; bh=/qQ52xAkipEUSLrkI7pxDpGQami8ReTvTUuSmItc858=; b=gzzURd/zQC5okxiODpAf+MUEBv0V52TPvV2pj2P/M567xgQXgi9PGcHiQZMkSqa//1 FaUAcNrhORIUv6965hyT/QYwzChjV4lxe1AWeF1SA0Y7wiRJ9TkkWGS+8YvPDvD2fLnl mU7NYN/eXQIS5co0gKlgGky/xFu+6HCAxHN+8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:reply-to:from:references:in-reply-to :mime-version:thread-index:date:message-id:subject:to:cc :content-type; bh=/qQ52xAkipEUSLrkI7pxDpGQami8ReTvTUuSmItc858=; b=jIzY4g7bQ6UWTGWt/987hjzmIzV7dAuZc9JJMHmv63JxUy2dJEUmOKrrgJ3qkR4/Dp YAyEivc9TFi6wyGk9HiuQwBSFHiuugwDny9/6Dq7babKW97LYMB1IDKZ2dy3Sw0LqJox 4NItBP7CqfrW0f3dRm3vC/GED8L+C6/AXiegv2AnYAtCEuLNOa5Vuf3CQ9KRw/02cVXd Cw7FqNykieOW/6KRykNhXklwx7tYrlWJBmjn8geWFtPWoRY7bentE79Kr1dTlzgwFBBG zO/Qjww2S/yEjEeHbC6qpCdtF/9ZpIHm4my/u/UvL8gZ8l/pyngrlccwiVDvaL2+GtE9 8Mvg== X-Gm-Message-State: ALoCoQkNUo/rYTHUnfIrfQzkj5054wIOCqmslu6cedwX7oVGWptFvUnxq8reapIyFEP0EB2fSxk3 X-Received: by 10.182.42.133 with SMTP id o5mr38198034obl.36.1426251802076; Fri, 13 Mar 2015 06:03:22 -0700 (PDT) Reply-To: From: Vivekanand Joshi References: <84a6fe4be04c3ef0a714851977860ac8@mail.gmail.com> In-Reply-To: MIME-Version: 1.0 X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQGXPdRf3VxuG24kJ8WwflsQcHnAgQJFdAGLnXp0q9A= Date: Fri, 13 Mar 2015 18:33:22 +0530 Message-ID: <160b8780d89add7f23c4eb9c3debb99d@mail.gmail.com> Subject: Re: Performance issues To: Varadharajan Mukundan Cc: pgsql-performance@postgresql.org Content-Type: multipart/related; boundary=001a11c2df7c07e58005112b20d3 X-Pg-Spam-Score: -2.7 (--) 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 --001a11c2df7c07e58005112b20d3 Content-Type: multipart/alternative; boundary=001a11c2df7c07e57d05112b20d2 --001a11c2df7c07e57d05112b20d2 Content-Type: text/plain; charset=UTF-8 10 million records in s_f_promotion_history table. *From:* Varadharajan Mukundan [mailto:srinathsmn@gmail.com] *Sent:* Friday, March 13, 2015 6:29 PM *To:* vjoshi@zetainteractive.com *Cc:* pgsql-performance@postgresql.org *Subject:* Re: [PERFORM] Performance issues Hi Vivekanand,