ate groupthanks
---- Original Message ----
Subject: Re: [BUGS] Very slow inner join query unacceptable latency
From: Jaime Casanova <ja...@2ndquadrant.com>
Date: Tue, May 21, 2013 2:34 pm
To: Freddie Burgess <fburg...@radiantblue.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
On Tue, May 21, 2013 at 3:54 PM, wrote:
> The SARS_ACTS table currently has 37,115,515 rows
>
> we have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree
> (sars_run_id)
> we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY
> KEY (id )
>
> serverdb=# explain sel
The SARS_ACTS table currently has 37,115,515 rowswe have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree (sars_run_id)we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY KEY (id )serverdb=# explain select count(*) as y0_ from SARS_ACTS this_ inner join SARS_ACTS
