Re: [PERFORM] bgwriter tunables vs pg_stat_bgwriter

On Feb 17, 2010, at 6:23 PM, Greg Smith wrote: JWith bgwriter_lru_maxpages=500 and bgwriter_delay=100ms, you can get up to 5000 pages/second which makes for 300,000 pages/minute. So none of your numbers look funny just via their scale. This is why the defaults are so low--the maximum out

Re: [PERFORM] index usage in not like

In response to Kenneth Marshall : > > > How many rows do you have in your table? If there are relatively few, > > > it probably guesses it to be cheaper to do a sequential scan and > > > calculate lower values on-the-fly rather than bother with the index. > > > > That's one reason, an other reaso

Re: [PERFORM] index usage in not like

On 18 February 2010 12:18, A. Kretschmer wrote: > In response to Thom Brown : >> On 18 February 2010 11:55, AI Rumman wrote: >> > "Not like" operation does not use index. >> > >> > select * from vtiger_contactscf where lower(cf_1253) not like >> > lower('Former%') >> > >> > I created index on low

Re: [PERFORM] index usage in not like

On Thu, Feb 18, 2010 at 01:18:10PM +0100, A. Kretschmer wrote: > In response to Thom Brown : > > On 18 February 2010 11:55, AI Rumman wrote: > > > "Not like" operation does not use index. > > > > > > select * from vtiger_contactscf where lower(cf_1253) not like > > > lower('Former%') > > > > > > I

Re: [PERFORM] index usage in not like

In response to Thom Brown : > On 18 February 2010 11:55, AI Rumman wrote: > > "Not like" operation does not use index. > > > > select * from vtiger_contactscf where lower(cf_1253) not like > > lower('Former%') > > > > I created index on lower(cf_1253). > > > > How can I ensure index usage in not l

Re: [PERFORM] index usage in not like

> On Thu, Feb 18, 2010 at 6:00 PM, Thom Brown wrote: >> >> On 18 February 2010 11:55, AI Rumman wrote: >> > "Not like" operation does not use index. >> > >> > select * from vtiger_contactscf where lower(cf_1253) not like >> > lower('Former%') >> > >> > I created index on lower(cf_1253). >> > >> >

Re: [PERFORM] index usage in not like

On 18 February 2010 11:55, AI Rumman wrote: > "Not like" operation does not use index. > > select * from vtiger_contactscf where lower(cf_1253) not like > lower('Former%') > > I created index on lower(cf_1253). > > How can I ensure index usage in not like operation? > Anyone please help. > How ma

[PERFORM] index usage in not like

"Not like" operation does not use index. select * from vtiger_contactscf where lower(cf_1253) not like lower('Former%') I created index on lower(cf_1253). How can I ensure index usage in not like operation? Anyone please help.