Re: Perfomance Tuning - Mailing list pgsql-performance

From Jonathan Gardner
Subject Re: Perfomance Tuning
Date
Msg-id 200308080940.21517.jgardner@jonathangardner.net
Whole thread Raw
In response to Perfomance Tuning  (mixo <mixo@coza.net.za>)
Responses Re: Perfomance Tuning  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 08 August 2003 03:28, mixo wrote:
> I have just installed redhat linux 9 which ships with Pg
> 7.3.2. Pg has to be setup so that data inserts (blobs) should
> be able to handle at least 8M at a time. The machine has
> two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and
> a 36 Gig hd with 1 Gig swap and 3 equal size ext3 partitions.
> What would be the recomended setup for good performance
> considering that the db will have about 15 users for
> 9 hours in a day, and about 10 or so users throughout the day
> who wont be conistenly using the db.
>

Redhat puts ext3 on by default. Consider switching to a non-journaling FS
(ext2?) with the partition that holds your data and WAL.

Consider having a seperate partition for the WAL as well.

These are things that are more difficult to change later on. Everything else
is tweaking.

Is it absolutely necessary to store 8MB files in the database? I find it
cumbersome. Storing them on a file server has been a better alternative for
me.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/M9J0WgwF3QvpWNwRAlT5AJ9EmDourbCiqj7MFOqfBospc2dW7gCfZKz0
JQjn/2KAeh1SPJfN601LoFg=
=PW6k
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Perfomance Tuning
Next
From: Manfred Koizar
Date:
Subject: Index correlation (was: Moving postgresql.conf tunables into 2003... )