Re: [GENERAL] Hope for a new PostgreSQL era?

2011-12-08 Thread Rodger Donaldson
On Thu, 8 Dec 2011 16:34:49 -0800, Chris Travers wrote: > On Thu, Dec 8, 2011 at 4:09 PM, Rodger Donaldson > wrote: >> On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce >> wrote: >>> On 12/08/11 11:16 AM, Joshua D. Drake wrote: >>>>> >>&

Re: [GENERAL] Hope for a new PostgreSQL era?

2011-12-08 Thread Rodger Donaldson
On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce wrote: > On 12/08/11 11:16 AM, Joshua D. Drake wrote: >>> >>> um, I believe this is referring to Oracle RAC clustering, not HA >>> active/standby. I seriously doubt Oracle is dropping RAC. >> >> I meant worrying about it for Pg. > > the odds of Po

Re: [GENERAL] Performance tuning in Pgsql

2010-12-15 Thread Rodger Donaldson
old > ln -s /myothervolume/pg_xlog pg_xlog > /etc/init.d/postgresql-8.4 start Is there any particular reason that you're suggesting linking rather than simply mounting the partition at /var/lib/postgresql/8.4/main/pg_xlog (after copying the data across, naturally)? -- Rodger Donaldson

Re: [GENERAL] What Linux edition we should chose?

2010-06-03 Thread Rodger Donaldson
On 06/01/2010 03:34 AM, Tom Lane wrote: > Ivan Sergio Borgonovo writes: >> On Mon, 31 May 2010 08:47:25 -0600 >> Scott Marlowe wrote: >>> Pgsql is pretty easy to build from source. > >> Yeah it is. But what is it going to be an upgrade process? On a >> production box? > > If it makes you feel b

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-09 Thread Rodger Donaldson
On Tue, Mar 09, 2010 at 11:58:58AM -0500, Greg Smith wrote: > Rodger Donaldson wrote: > >Cyril Scetbon wrote: > >>Does anyone know what can be the differences between linux kernels > >>2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) > >>h

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-09 Thread Rodger Donaldson
Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 http://www.csamuel.org/2009/04/11/default-ext3-mode-changing-in-2630

Re: [GENERAL] Amazon EC2 CPU Utilization

2010-01-29 Thread Rodger Donaldson
Mike Bresnahan wrote: > I can understand that I will not get as much performance out of a EC2 instance as a dedicated server, but I don't understand why top(1) is showing 50% CPU utilization. If it were a memory speed problem wouldn't top(1) report 100% CPU utilization? A couple of points: top