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 s
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
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:
