Re: [PERFORM] Postgresql 9.3 for a Mobile Backend

On 8.5.2014 09:10, Rajiv Kasera wrote: > Dear Community friends, > > > > We are planning to use postgresql 9.3 for building a mobile backend. Can > we get a benchmark on the level of concurrency that can be supported by > Postgres 9.3 and it will be able to handle the spike in traffic if the >

Re: [PERFORM] Check memory consumption of postgresql query

On Thu, May 8, 2014 at 3:04 AM, Phan Công Minh wrote: > Hello PostgreSQL community , > > I'm doing benchmark between column store and traditional row-oriented store. > I would like to know if there is any way to measure memory consummed by a > query execution? In linux you can look at the memory

Re: [PERFORM] Specifications for a new server

> > Why do you even want to use JBOD? > Not for postgresql , but for distributed filesystems like hdfs/qfs (which are supposed to work on JBOD) with hypertable on top (so the nvram would help with the commits, since it is the biggest bottleneck when writing(commits need to be saved to multiple ser

Re: [PERFORM] Specifications for a new server

On 8 May 2014 10:11, Johann Spies wrote: > > Question: How do I dedicate a partition to indexes? Were do I configure > PostgreSQL to write them in a particular area? > > > I just discovered TABLESPACE which answered my question. Regards Johann -- Because experiencing your loyal love is better

Re: [PERFORM] Specifications for a new server

On 6 May 2014 13:07, Michael Stone wrote: > On Tue, May 06, 2014 at 11:13:42AM +0200, Johann Spies wrote: > >> Analysis or the SAR-logs showed that there were too much iowait in the >> CPU's on >> the old system which has a lower spec CPU than the ones considered for >> the new >> system. >> > >

Re: [PERFORM] Postgresql 9.3 for a Mobile Backend

2014-05-08 9:10 GMT+02:00 Rajiv Kasera : > Dear Community friends, > > > > We are planning to use postgresql 9.3 for building a mobile backend. Can > we get a benchmark on the level of concurrency that can be supported by > Postgres 9.3 and it will be able to handle the spike in traffic if the app

[PERFORM] Postgresql 9.3 for a Mobile Backend

Dear Community friends, We are planning to use postgresql 9.3 for building a mobile backend. Can we get a benchmark on the level of concurrency that can be supported by Postgres 9.3 and it will be able to handle the spike in traffic if the app gets popular. Any help regarding the same will

[PERFORM] Check memory consumption of postgresql query

Hello PostgreSQL community , I'm doing benchmark between column store and traditional row-oriented store. I would like to know if there is any way to measure memory consummed by a query execution? Thanks Minh,