Re: Are there performance advantages in storing bulky field in separate table? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Are there performance advantages in storing bulky field in separate table?
Date
Msg-id 2f4958ff0904090454v4ab93a06k46fdb2aada4cf16f@mail.gmail.com
Whole thread Raw
In response to Re: Are there performance advantages in storing bulky field in separate table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Are there performance advantages in storing bulky field in separate table?
Next
From: Sam Mason
Date:
Subject: Re: Postgres: Starting Server in background mode