Re: [PERFORM] Does fsync on/off for wal AND Checkpoint?

2013-12-27 Thread Andreas Karlsson
On 12/27/2013 04:55 PM, GR Vishwanath wrote: Is fscnc off/on pertain only to writing WAL buffers to disk? Or is that also relevant to writing of dirty buffers to disk (checkpoint/bg)? Curious because in the docs fsync on/off is mentioned under WAL configuration. Further there is a

Re: [PERFORM] query not using index

2013-12-27 Thread Mark Kirkwood
On 23/12/13 21:58, Johann Spies wrote: On 19 December 2013 16:48, Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us wrote: Johann Spies johann.sp...@gmail.com mailto:johann.sp...@gmail.com writes: I would appreciate some help optimising the following query: It's a

[PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system

2013-12-27 Thread ankush upadhyay
Hello All, I am using multi tenant system and doing performance testing of multi tenant application. In case of single tenant it is working fine but once I enable tenants, then some time database servers not responding. Any clue? -- -- Regards @Ankush Upadhyay@