On Wed, Jun 1, 2011 at 3:14 PM, CS DBA <cs_dba@xxxxxxxxxxxxxxxxxxx> wrote: > Hi All; > > We have a table with approx 200 columns. about a dozen columns are text data > types and the rest are a mix of integers , bigint's and double precision > types. > > The table has about 25million rows. > > > The app wants to run a query like this: > > select count(pri_num) from max_xtrv_st_t > where pri_num in (select max(pri_num) from max_xtrv_st_t where 1=1 > group by tds_cx_ind, cxs_ind_2 ) > > I've tried to split the query up but made little progress, pri_num and > tds_cx_ind are bigint's and cxs_ind_2 is an integer > > The table has an index on all 3 columns (3 separate indexes) > > Anyone have any thoughts on tuning this query? need postgres version# and the current explain analyze (or explain, if you can't wait for it) merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
