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
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