-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a two relevant tables:
fastgraph=# \d object
Table "public.object"
Column | Type | Modifiers
- ++--
id | bigint | not null default nextval
On Tue, 6 Nov 2007, Dimitri Fontaine wrote:
Some knowing-better-than-me people on #postgresql had the remark that
depending on the write transaction volumes (40 to 60 percent of my tps, but
no so much for this hardware), I could somewhat benefit in setting the WAL on
the OS raid1, and having 8 r
Le mardi 06 novembre 2007, Tore Halset a écrit :
> Interesting. Do you have any benchmarking numbers? Did you test with
> software raid 10 as well?
Just some basic pg_restore figures, which only make sense (for me anyway) when
compared to restoring same data on other machines, and to show the eff
On Nov 6, 2007, at 12:36 , Claus Guttesen wrote:
All of our existing servers are from Dell, but I want to look at some
other options as well. We are currently looking at rack boxes with 8
internal SAS discs. Two mirrored for OS, Two mirrored for WAL and 4
in
raid 10 for the base.
Here are o
On Nov 6, 2007, at 12:53 , Dimitri Fontaine wrote:
Le mardi 06 novembre 2007, Tore Halset a écrit :
1) Dell 2900 (5U)
8 * 146 GB SAS 15Krpm 3,5"
8GB ram
Perc 5/i. battery backup. 256MB ram.
2 * 4 Xeon 2,66GHz
In fact you can add 2 hot-plug disks on this setup, connected to the
frontpane. We'v
Tore,
* Tore Halset ([EMAIL PROTECTED]) wrote:
> All of our existing servers are from Dell, but I want to look at some other
> options as well. We are currently looking at rack boxes with 8 internal SAS
> discs. Two mirrored for OS, Two mirrored for WAL and 4 in raid 10 for the
> base.
I'm a b
Hi List,
Le mardi 06 novembre 2007, Tore Halset a écrit :
> 1) Dell 2900 (5U)
> 8 * 146 GB SAS 15Krpm 3,5"
> 8GB ram
> Perc 5/i. battery backup. 256MB ram.
> 2 * 4 Xeon 2,66GHz
In fact you can add 2 hot-plug disks on this setup, connected to the
frontpane. We've bought this very same model with
> All of our existing servers are from Dell, but I want to look at some
> other options as well. We are currently looking at rack boxes with 8
> internal SAS discs. Two mirrored for OS, Two mirrored for WAL and 4 in
> raid 10 for the base.
>
> Here are our current alternatives:
>
> 1) Dell 2900 (5U
Hello.
We are planning to move from MS SQL Server to PostgreSQL for our
production system. Bot read and write performance are equally
important. Writing is the bottleneck of our current MS SQL Server
system.
All of our existing servers are from Dell, but I want to look at some
other opt
