[BUGS] count(*) bag ?

2002-10-26 Thread Konstantin Tokar
Hi I use PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3 . count(*) very slowly. CREATE TABLE r2 ( r2_id int4 NOT NULL, a int4 DEFAULT 1, label varchar(255), CONSTRAINT r2_pkey PRIMARY KEY (r2_id) ) WITH OIDS; insert into r2 select * from r; # The table with the same str

Re: [BUGS] count(*) bag ?

2002-10-26 Thread Stephan Szabo
On Sat, 26 Oct 2002, Konstantin Tokar wrote: > I use PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC > 2.95.3 . count(*) very slowly. > > CREATE TABLE r2 ( > r2_id int4 NOT NULL, > a int4 DEFAULT 1, > label varchar(255), > CONSTRAINT r2_pkey PRIMARY KEY (r2_id) > ) WITH OIDS; > > i