On Tue, Nov 15, 2011 at 11:08 AM, Stuart Bishop <stu...@stuartbishop.net> wrote: > On Fri, Nov 11, 2011 at 10:01 PM, Ruslan Zakirov <r...@bestpractical.com> > wrote: >> Hello,
[snip] >> In application such wrong estimation result in seq scan of this table >> winning leading position in execution plans over other tables and >> index scans. >> >> What can I do to avoid this problem? > > Does a partial index help? CREATE UNIQUE INDEX foo_idx ON mytab(id) > WHERE id = EffectiveId It doesn't help. Probably reason is the same as for partitions. > > > -- > Stuart Bishop <stu...@stuartbishop.net> > http://www.stuartbishop.net/ > -- Best regards, Ruslan. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
