Skip site navigation (1) Skip section navigation (2)

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

From: Mohamed Hashim <nmdhashim(at)gmail(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: Mario Weilguni <roadrunner6(at)gmx(dot)at>, 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:15:50
Message-ID: CACBfhZMajgneA6x4r63bNayYtsfpmYV8UUOhBRcr5h-emmgxKw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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...

Regards
Hashim

On Tue, Nov 8, 2011 at 5:20 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:

> On 8 Listopad 2011, 4:21, Mohamed Hashim wrote:
> > Hi all,
> >
> > Thanks for all your responses.
> >
> > Sorry for late response
> >
> > Earlier we used Postgres8.3.10 with Desktop computer (as server) and
> > configuration of the system (I2 core with 4GB RAM) and also the
> > application
> > was slow  i dint change any postgres config settings.
> >
> > May be because of low config We thought the aplication is slow so we
> opted
> > to go for higher configuration server(with RAID 1) which i mentioned
> > earlier.
> >
> > I thought the application will go fast but unfortunately there is no
> > improvement so i tried to change the postgres config settings and trying
> > to
> > tune my queries wherever possible but still i was not able
> > to..........improve the performance..
>
> As Sam Gendler already wrote, we really can't help you until you post all
> the relevant info. So far we've seen a single EXPLAIN ANALYZE output and
> very vague description of the hardware.
>
> We need to know more about the hardware and the basic config options
> (shared buffers, effective cache size, work mem, etc.). We need to know
> how much memory is actually available to PostgreSQL and page cache (how
> much is consumed by the application - as I understand it it runs on the
> same machine). We need to know what OS it's running on, and we need to see
> iostat/vmstat output collected when the app is slow.
>
> Please read this and perform the basic tuning (and let us know what values
> you've used):
>
> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
>
> Also post
>
> > So will it helpful if we try GIST or GIN for integer array[] colum
> > (source_detail) with enable_seqscan=off and
> > default_statistics_target=1000?
>
> This is severely premature - it might help, but you should do the basic
> tuning first. It might actually cause you more trouble. You've already
> done this mistake - fixing something withouth veryfying it's actually a
> problem - by requesting a RAID1 config. Don't do that mistake again.
>
> Tomas
>
>


-- 
Regards
Mohamed Hashim.N
Mobile:09894587678

In response to

Responses

pgsql-performance by date

Next:From: Albe LaurenzDate: 2011-11-08 12:35:29
Subject: Re: SSL encryption makes bytea transfer slow
Previous:From: Tomas VondraDate: 2011-11-08 11:50:08
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

pgsql-general by date

Next:From: Tomas VondraDate: 2011-11-08 12:40:25
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!
Previous:From: Tomas VondraDate: 2011-11-08 11:50:08
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group