Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 1F447B325B6
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  8 Nov 2011 08:49:16 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 14095-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  8 Nov 2011 12:49:10 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.22])
	by mail.postgresql.org (Postfix) with SMTP id 1C4DBB325B4
	for <pgsql-performance@postgresql.org>;
	Tue,  8 Nov 2011 08:49:08 -0400 (AST)
Received: (qmail invoked by alias); 08 Nov 2011 12:49:07 -0000
Received: from office.icomedias.com (EHLO [10.192.1.141]) [109.73.147.5]
	by mail.gmx.net (mp066) with SMTP; 08 Nov 2011 13:49:07 +0100
X-Authenticated: #5984785
X-Provags-ID: V01U2FsdGVkX1//cBIwPrT/+HubTEThdVrIUS+wqtyRD5+q3lKUgm
	uqjAbn/FTwhEt7
Message-ID: <4EB92542.2030502@gmx.at>
Date: Tue, 08 Nov 2011 13:49:06 +0100
From: Mario Weilguni <roadrunner6@gmx.at>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore
	Processor Server--Need help!!!!!!!
References: 
 <CACBfhZPO1GJv4nVunPXGA2EZq923On-CBGtxyhtQYAaSMCuBEQ@mail.gmail.com>
	<CAF-3MvOjY17pVZXSWgYDB5dMy-B07KiVYexR4RRutxZyXeKjbA@mail.gmail.com>
	<CACBfhZNBwjB=3xQrvqy6ManJUaRyKEOoV8dMv7jJYPtXn9XFcQ@mail.gmail.com>
	<CACBfhZNr5qnMN0=8hp1Fb3hA8jwoEXnJAahua1JT5f5gXT9tuA@mail.gmail.com>
	<4EAFC29A.40509@engene.se> <24830.1320154980@sss.pgh.pa.us>
	<CACBfhZNoq_hjZyMnBTnrxR8rif31QvJ5dtdgQMdPwO0+x2AKpQ@mail.gmail.com>
	<4EB2ACEF.8090305@gmx.at>
	<65a8332e0128eda27f0345da80946dc6.squirrel@sq.gransy.com>
	<4EB2F49F.3080903@gmx.at>
	<CACBfhZP7OUL+UpauYYSuNbOG-tGbB+TwKzhY7FkwrdvxDaM8Jg@mail.gmail.com>
	<c5df85c09ae21f15f73e510f51b3c128.squirrel@sq.gransy.com>
	<CACBfhZMajgneA6x4r63bNayYtsfpmYV8UUOhBRcr5h-emmgxKw@mail.gmail.com>
In-Reply-To: 
 <CACBfhZMajgneA6x4r63bNayYtsfpmYV8UUOhBRcr5h-emmgxKw@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------020404030200080203070501"
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.798 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201111/116
X-Sequence-Number: 45627

This is a multi-part message in MIME format.
--------------020404030200080203070501
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Am 08.11.2011 13:15, schrieb Mohamed Hashim:
> Hi Sam,Tomas
>
> In my first post i have mentioned all how much shared (shared buffers, 
> effective cache size, work mem, etc.) and my OS and hardware 
> information and what are the basic settings i have changed
>
> and regarding Explain analyze i gave one sample query because if i 
> tune that particular table which has records almost 16crore i thought 
> my problem will solve...
>
Just curios, are those array items [1] and [2] just samples and you 
actually use more which are performance-related (used as condition)? If 
just those two are relevant I would change the schema to use real 
columns instead. And you seem to use partitioning, but you have no 
partition condition?

--------------020404030200080203070501
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Am 08.11.2011 13:15, schrieb Mohamed Hashim:
    <blockquote
cite="mid:CACBfhZMajgneA6x4r63bNayYtsfpmYV8UUOhBRcr5h-emmgxKw@mail.gmail.com"
      type="cite"><font face="trebuchet ms,sans-serif">Hi Sam,Tomas <br>
        <br>
        In my first post i have mentioned all how much shared </font>(shared
      buffers, effective cache size, work mem, etc.) and my OS and
      hardware information and what are the basic settings i have
      changed <br>
      <br>
      and regarding Explain analyze i gave one sample query because if i
      tune that particular table which has records almost 16crore i
      thought my problem will solve...<br>
      <br>
    </blockquote>
    Just curios, are those array items [1] and [2] just samples and you
    actually use more which are performance-related (used as condition)?
    If just those two are relevant I would change the schema to use real
    columns instead. And you seem to use partitioning, but you have no
    partition condition?
  </body>
</html>

--------------020404030200080203070501--