> -----Original Message----- > From: Anne Rosset > Subject: Re: Unexpected query plan results > > >> > >>SELECT SUM(1) FROM item WHERE is_deleted = 'f'; sum > --------- 1824592 > >>(1 > >>row) > >>SELECT SUM(1) FROM item WHERE folder_id = 'tracker3641 > >></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>'; sum > >>-------- > >>122412 (1 row) > >>SELECT SUM(1) FROM item WHERE folder_id = 'tracker3641 > >></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>' AND > >>is_deleted = 'f'; sum ----- 71 (1 row) SELECT SUM(1) FROM > item WHERE > >>folder_id = 'tracker3641 > >></sf/sfmain/do/go/tracker3641?returnUrlKey=1243878161701>' AND > >>is_deleted = 't'; sum -------- 122341 (1 row) > >> > >> > > > >Something's not right here. If the whole table has only > 468173 rows, > >you can't have 1.8 million deleted rows where is_deleted = false. > > > >...Robert > > > > > The item table has 2324829 rows > The artifact table has 468173 rows. > Thanks, > Anne I'd been thinking about the sort, but I hadn't thought yet if that index scan on item could be made faster. Could you post the table definition of item including the indexes on it? Dave -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
