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