Re: [PERFORM] encourging bitmap AND

2011-01-02 Thread Jim Nasby
On Dec 26, 2010, at 11:24 AM, Tom Lane wrote: If you're doing interval queries enough to worry about having an index for them, you really want an indexing structure that is designed to do interval queries efficiently. BTW, one way to accomplish that is to transform your data into geometric

Re: [PERFORM] CPU bound

2011-01-02 Thread Jim Nasby
On Dec 20, 2010, at 12:47 AM, Mladen Gogala wrote: Good time accounting is the most compelling reason for having a wait event interface, like Oracle. Without the wait event interface, one cannot really tell where the time is spent, at least not without profiling the database code, which is

Re: [PERFORM] How to turn autovacuum prevent wrap around run faster?

2011-01-02 Thread marc.hsiao
Hi Scot Marlowe: Set an autovacuum max cost much higher than the vacuum max cost (10 or so) and drop autovac cost delay to 0, then restart autovacuum. I had set autovacuum_vacuum_cost_delay=0. BTW, how to set autovacuum max cost ? Regards Marc -Original Message- From: