Re: Are there performance advantages in storing bulky field in separate table?
Grzegorz Jaśkiewicz <gryzman@gmail.com>
From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ian Mayo <ianmayo@tesco.net>, pgsql-general@postgresql.org
Date: 2009-04-09T11:54:52Z
Lists: pgsql-general
If I may, I got an instance once, where table with bytea field was pretty slow. Turned out, that queries modified everything apart from bytea bit. moving it to separate table actually helped performance. But that only will happen providing that you have the bytea/text/whatever that won't change, once inserted.