Re: [GENERAL] Background Writer and performances

2006-07-18 Thread Jan Wieck
On 7/10/2006 9:49 AM, Martijn van Oosterhout wrote: On Mon, Jul 10, 2006 at 02:56:48PM +0200, DANTE Alexandra wrote: ** I would like to send charts to show you exactly what happens on the server but, with the pictures, this e-mail is not posted on the mailing li

Re: [GENERAL] Background Writer and performances

2006-07-10 Thread DANTE Alexandra
These graphs represent traffic to the disks, and have been generated from a "home-made" tool based on "top", "vmstat" and "iostat". Only PostgreSQL accesses to them, a JVM is launched via BenchmarkSQL but does not access to the disks on which are stored the data. BenchmarkSQL stores its reports

Re: [GENERAL] Background Writer and performances

2006-07-10 Thread DANTE Alexandra
Hello List, I have uploaded charts on a ftp server. You can access to these 6 graphs by doing ftp visibull.frec.bull.fr login : ftp password : ftp You are under the "/" directory and with "ls" command you see the directory "PGS_bgwriter". In this directory, the 3 charts joined to this e-mail a

Re: [GENERAL] Background Writer and performances

2006-07-10 Thread Martijn van Oosterhout
On Mon, Jul 10, 2006 at 05:06:56PM +0200, DANTE Alexandra wrote: > Hello List, > > I have uploaded charts on a ftp server. > You can access to these 6 graphs by doing > ftp visibull.frec.bull.fr Or more easily, by putting this in your web-browser: ftp://visibull.frec.bull.fr/PGS_bgwriter/ I'm p

Re: [GENERAL] Background Writer and performances

2006-07-10 Thread Martijn van Oosterhout
On Mon, Jul 10, 2006 at 02:56:48PM +0200, DANTE Alexandra wrote: > ** > I would like to send charts to show you exactly what happens on the > server but, with the pictures, this e-mail is not posted on the mailing > list. > I can send charts to a personal e-mail ad

[GENERAL] Background Writer and performances

2006-07-10 Thread DANTE Alexandra
Hello List, I’m using BenchmarkSQL to evaluate, characterize and optimize PostgreSQL in transaction processing. I work with PostgreSQL 8.1.3 on RHEL4-AS, Itanium-2 processor, 8GB RAM. The database, generated via BenchmarkSQL and used, is a 200-warehouses database and its size is about 20GB.