Re: [GENERAL] Some issues with planner and query optimization

2007-02-05 Thread Richard Huxton
Boguk Maxim wrote: 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 |

[GENERAL] Some issues with planner and query optimization

2007-02-02 Thread Boguk Maxim
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