At 12:16 AM 12/13/2004 -0600, Guy Rouillier wrote:
(3) If we go with more disks, should we attempt to split tables and
indexes onto different drives (i.e., tablespaces), or just put all the
disks in hardware RAID5 and use a single tablespace?
Fast inserts = fast writes.
RAID5 = slower writes.
You m
Guy Rouillier wrote:
Seeking advice on system configuration (and I have read the techdocs.)
Probably worth reading the archives for the "performance" list.
We are converting a data collection system from Oracle to PostgreSQL
8.0. We are currently getting about 64 million rows per month; data is
pu
Hi!
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von
> Guy Rouillier
> Gesendet: Montag, 13. Dezember 2004 07:17
> An: PostgreSQL General
> Betreff: [GENERAL] High volume inserts - more disks or more CPUs?
> (1
Seeking advice on system configuration (and I have read the techdocs.)
We are converting a data collection system from Oracle to PostgreSQL
8.0. We are currently getting about 64 million rows per month; data is
put into a new table each month. The number of simultaneous connections
is very small: