Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

From: Mario Weilguni <roadrunner6(at)gmx(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Date: 2011-11-08 12:49:06
Message-ID: 4EB92542.2030502@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zhidong 2011-11-08 13:36:06 Re: IP range in pg_hba.conf?
Previous Message Tomas Vondra 2011-11-08 12:40:25 Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

Browse pgsql-performance by date

  From Date Subject
Next Message Albe Laurenz 2011-11-08 13:18:18 Re: SSL encryption makes bytea transfer slow
Previous Message Tomas Vondra 2011-11-08 12:40:25 Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!