pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedEntry point for Postgresql Performance
3+ messages / 3 participants
[nested] [flat]
* Entry point for Postgresql Performance
@ 2009-03-12 10:52 Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nagalingam, Karthikeyan @ 2009-03-12 10:52 UTC (permalink / raw)
To: pgsql-performance
Hi,
Can you guide me, Where is the entry point to get the documentation
for Postgresql performance tuning, Optimization for Postgresql with
Storage controller.
Your recommendation and suggestion are welcome.
Regards
Karthikeyan.N
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Entry point for Postgresql Performance
@ 2009-03-12 11:10 Ashish Karalkar <ashishka@synechron.com>
parent: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ashish Karalkar @ 2009-03-12 11:10 UTC (permalink / raw)
To: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>; +Cc: pgsql-performance
Nagalingam, Karthikeyan wrote:
> Hi,
> Can you guide me, Where is the entry point to get the
> documentation for Postgresql performance tuning, Optimization for
> Postgresql with Storage controller.
>
> Your recommendation and suggestion are welcome.
>
> Regards
> Karthikeyan.N
>
>
Take a look at
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/
http://www.scribd.com/doc/4846381/PostgreSQL-Performance-Tuning
http://www.linuxjournal.com/article/4791
With Regards
--Ashish
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Entry point for Postgresql Performance
@ 2009-03-12 17:41 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
parent: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
1 sibling, 0 replies; 3+ messages in thread
From: Rajesh Kumar Mallah @ 2009-03-12 17:41 UTC (permalink / raw)
To: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>; +Cc: pgsql-performance
Databases are usually IO bound , vmstat results can confirm individual
cases and setups.
In case the server is IO bound the entry point should be setting up
properly performing
IO. RAID10 helps a great extent in improving IO bandwidth by
parallelizing the IO operations,
more spindles the better. Also write caches helps in great deal in
caching the writes and making
commits faster.
In my opinion system level tools (like vmstat) at peak load times can
be an entry point
in understanding the bottlenecks of a particular setup.
if there is swapping u absolutely need to double the ram . ( excess
ram can be used in disk block caching)
if its cpu bound add more cores or high speed cpus
if its io bound put better raid arrays & controller.
regds
mallah.
On Thu, Mar 12, 2009 at 4:22 PM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@netapp.com> wrote:
> Hi,
> Can you guide me, Where is the entry point to get the documentation for
> Postgresql performance tuning, Optimization for Postgresql with Storage
> controller.
>
> Your recommendation and suggestion are welcome.
>
> Regards
> Karthikeyan.N
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-03-12 17:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-12 10:52 Entry point for Postgresql Performance Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
2009-03-12 11:10 ` Ashish Karalkar <ashishka@synechron.com>
2009-03-12 17:41 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
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