Re: [PERFORM] SURVEY: who is running postgresql on 8 or more CPUs?

2005-06-02 Thread ohp
/AMD/IBM): Intel > Processors (Type/Number/GHz): bi-Xeon 2.8G > RAM: 3g > Operating System: Unixware 714 > PostgreSQL Version: 8.0.3 > Database size (GB): 6G > Disk system: 6xU320 36G SCSI (software raid) > Type of application: from accounting to game > Your email contact:

[PERFORM] index as large as table

2005-08-20 Thread ohp
64 (GSM) FRANCE Email: ohp@pyrenet.fr -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [PERFORM] URGENT: Out of disk space pg_xlog

2006-12-22 Thread ohp
+33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr -- Make your life a dream, make your dream a reality. (St Exupery)

Re: [PERFORM] URGENT: Out of disk space pg_xlog

2006-12-23 Thread ohp
Thanks for your reply. I learnt something again! On Fri, 22 Dec 2006, Alvaro Herrera wrote: > Date: Fri, 22 Dec 2006 17:25:43 -0300 > From: Alvaro Herrera <[EMAIL PROTECTED]> > To: ohp@pyrenet.fr > Cc: Tom Lane <[EMAIL PROTECTED]>, > Kevin Grittner <[EMAIL PR

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-20 Thread ohp
Hi Tom, You still have an account on my Unixware Bi-Xeon hyperthreded machine. Feel free to use it for your tests. On Mon, 19 Apr 2004, Tom Lane wrote: > Date: Mon, 19 Apr 2004 20:53:09 -0400 > From: Tom Lane <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: Joe Conway <[EMAIL PROTECTED]>, scott.

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-21 Thread ohp
How long is this test supposed to run? I've launched just 1 for testing, the plan seems horrible; the test is cpu bound and hasn't finished yet after 17:02 min of CPU time, dual XEON 2.6G Unixware 713 The machine is a Fujitsu-Siemens TX 200 server On Mon, 19 Apr 2004, Tom Lane wrote: > Date: Mo

Re: [PERFORM] Wierd context-switching issue on Xeon

2004-04-29 Thread ohp
Hi I'd LOVE to contribute on this but I don't have vmstat and I'm not running linux. How can I help? Regards On Wed, 28 Apr 2004, Robert Creager wrote: > Date: Wed, 28 Apr 2004 18:57:53 -0600 > From: Robert Creager <[EMAIL PROTECTED]> > To: Josh Berkus <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED]

Re: [PERFORM] Slow in morning hours

2004-06-05 Thread ohp
Have you tried VACUUM ANALYZE at least one a day? Regards On Fri, 20 Feb 2004 [EMAIL PROTECTED] wrote: > Date: Fri, 20 Feb 2004 14:46:15 +0530 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [PERFORM] Slow in morning hours > > Hi All, > > I am using Linux 7.2

Re: [PERFORM] 7 hrs for a pg_restore?

2008-02-20 Thread ohp
On Wed, 20 Feb 2008, Pavan Deolasee wrote: > Date: Wed, 20 Feb 2008 14:31:09 +0530 > From: Pavan Deolasee <[EMAIL PROTECTED]> > To: Jeff Davis <[EMAIL PROTECTED]> > Cc: Douglas J Hunley <[EMAIL PROTECTED]>, > pgsql-performance@postgresql.org > Subject: Re: [PERFORM] 7 hrs for a pg_restore? >