Hi Atri, But TOAST only occur if the tuple size exceed 2KB, doesn't it?
Lior -----Original Message----- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: Monday, May 27, 2013 15:39 To: Ben Zeev, Lior Cc: Stephen Frost; Pg Hackers Subject: Re: [HACKERS] PostgreSQL Process memory architecture 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
