>Why not create an extra "statistics" table which is updated automatically
>through triggers in your original table? That way, you will always get
>up-to-date INSTANT query results no matter how huge your original table is.
>And, don't forget that the only way MS SQL can achieve the better performance
>here is through mercilessly hogging ressources. In a complex database
>environment with even larger tables, the performance gain in MS SQL would be
>minimal (my guess).
Definitely. This is a design optimization problem not an index problem.
In response to
pgsql-hackers by date
|Next:||From: Thomas Lockhart||Date: 2001-10-31 05:58:46|
|Subject: Re: timetz regression test is showing several DST-related |
|Previous:||From: Horst Herb||Date: 2001-10-31 03:37:29|
|Subject: Re: Serious performance problem|