Re: [GENERAL] how to get accurate values in pg_statistic

2003-08-22 Thread Stephan Szabo
On 22 Aug 2003, Jenny Zhang wrote: > Last week I reported getting different execution plans for the same > query against the same database. I did further investigation. After > building the database, I did: > vacuumdb -z DBT3 > psql DBT3 -c "analyze supplier" > psql DBT3 -c "analyze part" > psq

[GENERAL] how to get accurate values in pg_statistic

2003-08-22 Thread Jenny Zhang
Hi, Last week I reported getting different execution plans for the same query against the same database. I did further investigation. After building the database, I did: vacuumdb -z DBT3 psql DBT3 -c "analyze supplier" psql DBT3 -c "analyze part" psql DBT3 -c "analyze partsupp" psql DBT3 -c "ana