pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mario Weilguni <roadrunner6@gmx.at>
To: pgsql-performance@postgresql.org
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Date: Tue, 08 Nov 2011 13:49:06 +0100
Message-ID: <4EB92542.2030502@gmx.at> (raw)
In-Reply-To: <CACBfhZMajgneA6x4r63bNayYtsfpmYV8UUOhBRcr5h-emmgxKw@mail.gmail.com>
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>

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?

view thread (23+ messages)

Message-ID: <4EB92542.2030502@gmx.at>
Permalink:  ../4EB92542.2030502@gmx.at/
Also on:    postgresql.org/message-id/4EB92542.2030502@gmx.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: roadrunner6@gmx.at
  Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
  In-Reply-To: <4EB92542.2030502@gmx.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox