[PERFORM] Scalability in postgres

HI. Someone had some experience of bad performance with postgres in some server with many processors? I have a server with 4 CPUS dual core and gives me a very good performance but I have experienced problems with another server that has 8 CPUS quad core (32 cores). The second one only gives me

Re: [PERFORM] Scalability in postgres

Thanks David... 2009/5/28 David Rees > On Thu, May 28, 2009 at 11:50 AM, Fabrix wrote: > > Monitoring (nmon, htop, vmstat) see that everything is fine (memory, HD, > > eth, etc) except that processors regularly climb to 100%. > > What kind of load are you putting the s

Re: [PERFORM] Scalability in postgres

Thanks Scott 2009/5/28 Scott Marlowe > On Thu, May 28, 2009 at 12:50 PM, Fabrix wrote: > > > > HI. > > > > Someone had some experience of bad performance with postgres in some > server > > with many processors? > > Seems to depend on the processors and

Re: [PERFORM] Scalability in postgres

2009/5/28 Scott Mead > On Thu, May 28, 2009 at 4:53 PM, Fabrix wrote: > >> >> >>> >>> Wow, that's some serious context-switching right there - 300k context >>> switches a second mean that the processors are spending a lot of their >>>

Re: [PERFORM] Scalability in postgres

2009/5/28 Flavio Henrique Araque Gurgel > - "Scott Marlowe" escreveu: > > On Thu, May 28, 2009 at 12:50 PM, Fabrix wrote: > > > > > > HI. > > > > > > Someone had some experience of bad performance with postgres in some > server

Re: [PERFORM] Scalability in postgres

2009/5/28 Greg Smith > On Thu, 28 May 2009, Flavio Henrique Araque Gurgel wrote: > > It is 2.6.24 We had to apply the kswapd patch also. It's important >> specially if you see your system % going as high as 99% in top and loosing >> the machine's control. I have read something about 2.6.28 had t

Re: [PERFORM] Scalability in postgres

2009/5/29 Scott Mead > 2009/5/29 Greg Smith > >> On Fri, 29 May 2009, Grzegorz Ja?kiewicz wrote: >> >> if it is implemented somewhere else better, shouldn't that make it >>> obvious that postgresql should solve it internally ? >>> >> >> Opening a database connection has some overhead to it that

Re: [PERFORM] Scalability in postgres

1 1 97 1 0 0 0 0 46943572 117004 170335680032 204 2007 2986 1 1 98 0 0 Now i don't think the probles is NUMA. The developer team will fix de aplication and then i will test again. I believe that when the application closes the connection the problem could be solved, and then 16 cores in a server does the work instead of a 32 or 24. Regards... --Fabrix

[PERFORM] Postgresql Configutation and overflow

Good day, I have been reading about the configuration of postgresql, but I have a server who does not give me the performance that should. The tables are indexed and made vacuum regularly, i monitor with top, ps and pg_stat_activity and when i checked was slow without a heavy load overage. Befor

[PERFORM] Questions about enabling SSL

Hi all... If ssl is enable in postgresql decreanse the performance of the database? How much? Thanks in advance

Re: [PERFORM] Questions about enabling SSL

Thanks Michael... 2008/2/11, Michael Fuhr <[EMAIL PROTECTED]>: > > On Mon, Feb 11, 2008 at 05:37:51PM -0700, Michael Fuhr wrote: > > On Mon, Feb 11, 2008 at 04:58:35PM -0700, fabrix peñuelas wrote: > > > If ssl is enable in postgresql decreanse the performance of the