On Wed, Jul 02, 2003 at 07:22:51AM +0430, Behdad Esfahbod wrote: > Another silly question, isn't any way to get rid of seqscan, when > doing 'SELECT count(*) FROM tab;'?
No :-( If you want to do that frequently, you should try to find another way to keep the count. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Crear es tan dificil como ser libre" (Elsa Triolet) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend