What is talxy?
Shared buffers, Sort memory, Effective Cache Size
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > PostgreSQL database development > Shared buffers, Sort memory, Effective Cache Size 27 April 2004 15:12:20

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

Shared buffers, Sort memory, Effective Cache Size

FrГ©dГ©ric Robinet 27 April 2004 15:12:20
 Hello,

I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL 7.4
running on. What are the bests settings for shared buffers, sort memory and
effective cache size?

My main database have a small/mid range size: some tables may have 1 or 2
millions of records.

Thanks

FrГ©dГ©ric Robinet
Fr@Mims.be


-------------------­--------(end of broadcast)---------­------------------
TIP 4: Don't 'kill -9' the postmaster

Add comment
Qing Zhao 21 April 2004 20:01:30 permanent link ]
 Hello,

I have recently configured my PG7.3 on a G5 (8GB RAM) with
shmmax set to 512MB and shared_buffer=50000­, sort_mem=4096
and effective cache size = 10000. It seems working great so far but
I am wondering if I should make effctive cache size larger myself.

Tnaks!

Qing
On Apr 21, 2004, at 9:29 AM, FrГ©dГ©ric Robinet wrote:
Hello,>
I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL > 7.4> running on. What are the bests settings for shared buffers, sort > memory and> effective cache size?>
My main database have a small/mid range size: some tables may have 1 > or 2> millions of records.>
Thanks>
FrГ©dГ©ric Robinet> Fr@Mims.be>
-------------------­--------(end of > broadcast)---------­------------------> TIP 4: Don't 'kill -9' the postmaster>


-------------------­--------(end of broadcast)---------­------------------
TIP 7: don't forget to increase your free space map settings

Add comment
Manfred Koizar 27 April 2004 15:12:20 permanent link ]
 On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao@supplyfx.com­>
wrote:>I have recently configured my PG7.3 on a G5 (8GB RAM) with>shmmax set to 512MB and shared_buffer=50000­, sort_mem=4096>and effective cache size = 10000. It seems working great so far but>I am wondering if I should make effctive cache size larger myself.

Yes, much larger! And while you are at it make shared_buffers smaller.

Servus
Manfred

-------------------­--------(end of broadcast)---------­------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgres­ql.org/docs/faqs/FAQ­.html

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > PostgreSQL database development > Shared buffers, Sort memory, Effective Cache Size 27 April 2004 15:12:20

see also:
[JBoss Seam] - Re: seam annotations in…
[JBoss Eclipse IDE (users)]…
[JBoss Portal] - Themes/Layouts
пройди тесты:
see also:
Hello,to everyone!
World’s Most Unusual Christmas Trees
Photo DVD Maker New Website Unveiled…

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .