Re: Why we don't want hints Was: Slow count(*) again...

Tobias Brox <tobixen@gmail.com>

From: Tobias Brox <tobixen@gmail.com>

To: Віталій Тимчишин <tivv00@gmail.com>

Cc: Josh Berkus <josh@agliodbs.com>, pgsql-performance@postgresql.org, Mladen Gogala <mladen.gogala@vmsinfo.com>

Date: 2011-02-11T09:29:06Z

Lists: pgsql-hackers, pgsql-performance

2011/2/11 Віталій Тимчишин <tivv00@gmail.com>:
> If the list is hard-coded, you can create partial index  on
> account_transaction(account_id, created desc) where trans_type_id in ( ...
> long, hard-coded list ...)

My idea as well, though it looks ugly and it would be a maintenance
head-ache (upgrading the index as new transaction types are added
would mean "costly" write locks on the table, and we can't rely on
manual processes to get it right ... we might need to set up scripts
to either upgrade the index or alert us if the index needs upgrading).