[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@

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 mailto:t...@sss.pgh.pa.us>> wrote: Johann Spies mailto:johann.sp...@gmail.com>> writes: > I would appreciate some help optimising the following query: It's a mistake to imagine that indexes are going to h

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 wal_sync_met

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

2013-12-27 Thread GR Vishwanath
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 wal_sync_method but not a "checkpoint_sync_method". Shiv