Re: [GENERAL] postgresql scalability issue

2010-11-09 Thread Ivan Voras
On 11/08/10 16:33, umut orhan wrote: > Hi all, > > > I've collected some interesting results during my experiments which I > couldn't > figure out the reason behind them and need your assistance. > > I'm running PostgreSQL 9.0 on a quad-core machine having two level on-chip > cache > hierarc

Re: [GENERAL] postgresql scalability issue

2010-11-08 Thread John R Pierce
On 11/08/10 7:33 AM, umut orhan wrote: Hi all, I've collected some interesting results during my experiments which I couldn't figure out the reason behind them and need your assistance. I'm running PostgreSQL 9.0 on a quad-core machine having two level on-chip cache hierarchy. PostgreSQL has

Re: [GENERAL] postgresql scalability issue

2010-11-08 Thread Scott Marlowe
On Mon, Nov 8, 2010 at 8:33 AM, umut orhan wrote: > Hi all, > I've collected some interesting results during my experiments which I > couldn't figure out the reason behind them and need your assistance. > I'm running PostgreSQL 9.0 on a quad-core machine having two level on-chip > cache hierarchy.

[GENERAL] postgresql scalability issue

2010-11-08 Thread umut orhan
Hi all, I've collected some interesting results during my experiments which I couldn't figure out the reason behind them and need your assistance. I'm running PostgreSQL 9.0 on a quad-core machine having two level on-chip cache hierarchy. PostgreSQL has a large and warmed-up buffer cache thu

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Jeff Davis
On Mon, 2007-01-22 at 17:37 -0300, Alvaro Herrera wrote: > brian stone wrote: > > I never considered MySQL because I really DO need transactions. MySQL > > also lacks many enterprise features we need; well they say they have > > them but from my testing they are a bit under-cooked. > > > > I need

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Alvaro Herrera
brian stone wrote: > I never considered MySQL because I really DO need transactions. MySQL > also lacks many enterprise features we need; well they say they have > them but from my testing they are a bit under-cooked. > > I need atomic actions across an N number of application servers. The > goa

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread brian stone
I never considered MySQL because I really DO need transactions. MySQL also lacks many enterprise features we need; well they say they have them but from my testing they are a bit under-cooked. I need atomic actions across an N number of application servers. The goal here is scalability, which

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-22 Thread Jeff Davis
On Sun, 2007-01-21 at 06:55 -0800, brian stone wrote: > Are there any built in tools or 3rd party tools for distributing a > postgresql database? I need an active active configuration; master- > master with fail over. The project I am working needs to support a > very large number of transactions

Re: [GENERAL] postgresql scalability, active-active cluster

2007-01-21 Thread Jim C. Nasby
On Sun, Jan 21, 2007 at 06:55:56AM -0800, brian stone wrote: > Are there any built in tools or 3rd party tools for distributing a postgresql > database? I need an active active configuration; master-master with fail > over. The project I am working needs to support a very large number of > tra

[GENERAL] postgresql scalability, active-active cluster

2007-01-21 Thread brian stone
Are there any built in tools or 3rd party tools for distributing a postgresql database? I need an active active configuration; master-master with fail over. The project I am working needs to support a very large number of transactions a second. It will eventually require a main frame, or some

Re: [GENERAL] PostgreSQL scalability concerns

2006-03-17 Thread Daniel Blaisdell
If you'd like to get some more detailed information, there is a Postgres-HA webinar on March 23rd that looks very interesting and should answer your questions. Direct Link: http://www.postgresql.org/about/event.347 -Daniel On 3/17/06, Guy Fraser <[EMAIL PROTECTED]> wrote: On Thu, 2006-16-03 at 13

Re: [GENERAL] PostgreSQL scalability concerns

2006-03-17 Thread Guy Fraser
On Thu, 2006-16-03 at 13:51 -0500, Robert Treat wrote: > On Wednesday 15 March 2006 18:14, Alen Garia - IT wrote: > > Hi, > > > > We are currently planning the deployment of our next generation > > enterprise database and we are wondering whether or not PostgreSQL could do > > the heavy lifting t

Re: [GENERAL] PostgreSQL scalability concerns

2006-03-16 Thread Robert Treat
On Wednesday 15 March 2006 18:14, Alen Garia - IT wrote: > Hi, > > We are currently planning the deployment of our next generation > enterprise database and we are wondering whether or not PostgreSQL could do > the heavy lifting that would be required. My post is a little bit long but > I hope i

Re: [GENERAL] PostgreSQL scalability concerns

2006-03-16 Thread Louis Gonzales
Hope this helps: http://www.postgresql.org/files/about/casestudies/wcgcasestudyonpostgresqlv1.2.pdf http://www.postgresql.org/about/users ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] PostgreSQL scalability concerns

2006-03-16 Thread Alen Garia - IT
Hi, We are currently planning the deployment of our next generation enterprise database and we are wondering whether or not PostgreSQL could do the heavy lifting that would be required. My post is a little bit long but I hope it will provide you with information to allow someone to provide a

Re: [GENERAL] PostgreSQL Scalability

2005-07-11 Thread Vivek Khera
On Jul 8, 2005, at 9:52 AM, [EMAIL PROTECTED] wrote: I am trying to get information about the Scalability options available for PostgreSQL. Assuming you a database that has a huge volume of reads and writes happening, what options have you got to scale your database. Many commercial RDBMS'

[GENERAL] PostgreSQL Scalability

2005-07-08 Thread postgresql
Hi I am trying to get information about the Scalability options available for PostgreSQL. Assuming you a database that has a huge volume of reads and writes happening, what options have you got to scale your database. Many commercial RDBMS' allow the clustering of Database servers and some other o