pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedConfirm calculus
4+ messages / 3 participants
[nested] [flat]
* Confirm calculus
@ 2010-06-16 13:45 Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
0 siblings, 0 replies; 4+ messages in thread
From: Juan Pablo Sandoval Rivera @ 2010-06-16 13:45 UTC (permalink / raw)
To: pgsql-performance
Good morning List
In relation to the process of tuning the engine PostgreSQL database, especially
7.3.7 version that is being used currently, agreaceria me clarify a procedure
If I have a server with 2 GB of RAM, it is said that the shared memory segment for
the engine of the database on a dedicated server should be between 25% and maximum 33% of the RAM.
I'm doing the calculation would be the next agradeze I confirm if I am
correct
1 MB = 1,048,576
* 2 = 2097152 1048576
25% would be 2097152 * 25 / 100 = 524288
Then the shared_buffers should be 524288 / 8 = 65536 for 25% of 2 GB
or should be 524 288?
Sincerely.
Juan Pablo Sandoval Rivera
Tecnologo Prof. en Ing. de Sistemas
Linux User : 322765
msn : juan_pablos@hotmail.com
yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)
UIN : 276125187 (ICQ)
Jabber : juan_pablos@www.jabberES.org
Skype : juan.pablo.sandoval.rivera
APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Confirm calculus
@ 2010-06-16 13:46 Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
2010-06-16 19:26 ` Re: Confirm calculus Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-16 19:34 ` Re: Confirm calculus Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Juan Pablo Sandoval Rivera @ 2010-06-16 13:46 UTC (permalink / raw)
To: pgsql-performance
Good morning List
In relation to the process of tuning the engine PostgreSQL database, especially
7.3.7 version that is being used currently, agreaceria me clarify a procedure
If I have a server with 2 GB of RAM, it is said that the shared memory segment for
the engine of the database on a dedicated server should be between 25% and maximum 33% of the RAM.
I'm doing the calculation would be the next agradeze I confirm if I am
correct
1 MB = 1,048,576
* 2 = 2097152 1048576
25% would be 2097152 * 25 / 100 = 524288
Then the shared_buffers should be 524288 / 8 = 65536 for 25% of 2 GB
or should be 524 288?
Sincerely.
Juan Pablo Sandoval Rivera
Tecnologo Prof. en Ing. de Sistemas
Linux User : 322765
msn : juan_pablos@hotmail.com
yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)
UIN : 276125187 (ICQ)
Jabber : juan_pablos@www.jabberES.org
Skype : juan.pablo.sandoval.rivera
APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Confirm calculus
2010-06-16 13:46 Confirm calculus Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
@ 2010-06-16 19:26 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2010-06-16 19:26 UTC (permalink / raw)
To: pgsql-performance; juapabsan@tutopia.com
Juan Pablo Sandoval Rivera <juapabsan@tutopia.com> wrote:
> In relation to the process of tuning the engine PostgreSQL
> database, especially 7.3.7 version that is being used currently,
Do you really mean PostgreSQL version 7.3.7 (not 8.3.7)? If so, you
should really consider upgrading. Performance is going to be much
better, not to mention all the new features and bug fixes.
> it is said that the shared memory segment for the engine of the
> database on a dedicated server should be between 25% and maximum
> 33% of the RAM.
I think that started being a recommended practice with 8.1 or 8.2;
in my limited experience with older versions, it didn't pay to go
beyond somewhere in the 100MB to 200MB range.
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Confirm calculus
2010-06-16 13:46 Confirm calculus Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
@ 2010-06-16 19:34 ` Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2010-06-16 19:34 UTC (permalink / raw)
To: juapabsan@tutopia.com; +Cc: pgsql-performance
On Wed, Jun 16, 2010 at 7:46 AM, Juan Pablo Sandoval Rivera
<juapabsan@tutopia.com> wrote:
> Good morning List
>
> In relation to the process of tuning the engine PostgreSQL database, especially
> 7.3.7 version that is being used currently, agreaceria me clarify a procedure
I concur with the other poster on keeping shared_mem lower on this
older version. Also, you should be running at the very least the
latest version of 7.3, which is 7.3.21 and available here:
ftp://ftp-archives.postgresql.org/pub/source/
Tuning 7.3 is more an effort in futility at this point, considering
that a non-tuned 8.3 or 8.4 install will still be much much faster.
If the lack of auto-casts in 8.3 impacts you negatively then at least
look at 8.2.latest.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-06-16 19:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-16 13:45 Confirm calculus Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
2010-06-16 13:46 Confirm calculus Juan Pablo Sandoval Rivera <juapabsan@tutopia.com>
2010-06-16 19:26 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-16 19:34 ` Scott Marlowe <scott.marlowe@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