Re: [GENERAL] Columnar store as default for PostgreSQL 10?

2016-05-17 Thread Bráulio Bhavamitra
Alvaro, is this related or dependent on https://www.pgcon.org/2016/schedule/events/920.en.html ? On Mon, Apr 25, 2016 at 11:20 AM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Bráulio Bhavamitra wrote: > > Hi all, > > > > I'm finally having performance issues wit

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

2016-04-25 Thread Bráulio Bhavamitra
On Mon, Apr 25, 2016 at 11:20 AM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Bráulio Bhavamitra wrote: > > Hi all, > > > > I'm finally having performance issues with PostgreSQL when doing big > > analytics queries over almost the entire databa

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

2016-04-21 Thread Bráulio Bhavamitra
On Thu, Apr 21, 2016 at 1:39 PM Geoff Winkless wrote: > On 21 April 2016 at 17:08, David G. Johnston > wrote: > > I have little experience (and nothing practical) with columnar store but > at > > a high level I don't see the point. I would hope

Re: [GENERAL] Feature request: fsync and commit_delay options per database

2015-06-30 Thread Bráulio Bhavamitra
On Tue, Jun 30, 2015 at 3:43 AM, Jeff Janes jeff.ja...@gmail.com wrote: 2015-06-29 15:18 GMT-07:00 Bráulio Bhavamitra brauli...@gmail.com: Hello all, After reading http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing I've tried to use commit_delay to make commits

[GENERAL] Feature request: fsync and commit_delay options per database

2015-06-29 Thread Bráulio Bhavamitra
Hello all, After reading http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing I've tried to use commit_delay to make commits really slow on a test environment. Unfortunetely, the maximum value is 100ms (100_000 microseconds). Besides increasing it, it would be great

Re: [GENERAL] Feature request: fsync and commit_delay options per database

2015-06-29 Thread Bráulio Bhavamitra
On Mon, Jun 29, 2015 at 7:43 PM, Tom Lane t...@sss.pgh.pa.us wrote: =?UTF-8?Q?Br=C3=A1ulio_Bhavamitra?= brauli...@gmail.com writes: Besides increasing it, it would be great to have these two options (fsync and commit_delay) per database, that is, valid only for databases configured with them.