On Mon, May 27, 2013 at 6:02 PM, Ben Zeev, Lior <lior.ben-z...@hp.com> wrote: > Hi Stephen, > > The case which I'm seeing is that I have an empty table without any rows, > Create table test ( > Num Integer, > C1 character varying(512), > C2 character varying(512), > C3 character varying(512)); > > I create several partial indexes on this table: > > Create index(index_1_c1) on test(c1) where Num=1; > Create index(index_2_c1) on test(c1) where Num=2; > Create index(index_1_c2) on test(c1) where Num=1; > Create index(index_2_c2) on test(c1) where Num=2;
It is just a hunch, but all of your attributes are character varying. Could TOAST be an issue here? Regards, Atri -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
