pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Priem <ap@cict.nl>
To: shridhar_daithankar@persistent.co.in
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning PostgreSQL
Date: Mon, 21 Jul 2003 11:40:42 +0200
Message-ID: <008e01c34f6c$27325c60$b696a8c0@APR> (raw)
References: <3F1C00B2.20319.147235A4@localhost>

Thanks, I will look at the site you sent me and purchase some hardware. Then
I will run some benchmarks.

Kind regards,
Alexander.

----- Original Message -----
From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
To: "Alexander Priem" <ap@cict.nl>
Cc: <pgsql-performance@postgresql.org>
Sent: Monday, July 21, 2003 11:33 AM
Subject: Re: [PERFORM] Tuning PostgreSQL


> Hi Alexander ,
>
> On 21 Jul 2003 at 11:23, Alexander Priem wrote:
> > So the memory settings I specified are pretty much OK?
>
> As of now yes, You need to test with these settings and make sure that
they
> perform as per your requirement. That tweaking will always be there...
>
> > What would be good guidelines for setting effective_cache_size, noatime
?
>
> I suggest you look at
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html.
>
> That should help you.
>
> > I use ext3 filesystem, which probably is not the best performer, is it?
>
> No. You also need to check ext2, reiser and XFS. There is no agreement
between
> users as in what works best. You need to benchmark and decide.
>
> > I will set the WAL on a separate drive. What do I need to change in the
conf
> > files to achive this?
>
> No. You need to shutdown postgresql server process and symlink WAL and
clog
> directories in postgresql database cluster to another place. That should
do it.
>
> HTH
>
> Bye
>  Shridhar
>
> --
> Meade's Maxim: Always remember that you are absolutely unique, just like
everyone else.
>




view thread (47+ messages)  latest in thread

Message-ID: <008e01c34f6c$27325c60$b696a8c0@APR>
Permalink:  ../008e01c34f6c$27325c60$b696a8c0@APR/
Also on:    postgresql.org/message-id/008e01c34f6c$27325c60$b696a8c0@APR

 · 

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: ap@cict.nl, shridhar_daithankar@persistent.co.in
  Subject: Re: Tuning PostgreSQL
  In-Reply-To: <008e01c34f6c$27325c60$b696a8c0@APR>

* 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