Postgres 8.1
Sample test table:
(all queries done on fresh vacuumed analyzed table with statistics on
rub_id and news_dtime set to 1000)
(all table in memory and server do not doing anything other)
media=> \d test_table
Table "public.test_table"
Column |Type
Details:
Postgres version 8.1
Table structure:
media=# \d fast_links
Table "public.fast_links"
Column |Type | Modifiers
+-+--
If short: adding index to table change execution plans on query which dont
use new index.
More detailed info:
tv2=# \d tv_events
Table "public.tv_events"
Column |Type |
Modifiers
+-+-