On Tue, Nov 15, 2011 at 11:08 AM, Stuart Bishop <[email protected]> wrote: > On Fri, Nov 11, 2011 at 10:01 PM, Ruslan Zakirov <[email protected]> > 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 <[email protected]> > http://www.stuartbishop.net/ > -- Best regards, Ruslan. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
