On Wed, 13 Dec 2006 11:29:44 +0000, "Simon Riggs" <[EMAIL PROTECTED]> wrote:
> Is there a big reason why TOAST tables are called such cryptic names?
>
> e.g. pg_toast.pg_toast_16399
>
> Wouldn't it be more pleasant to have them called the same thing as their
> parent
>
> e.g. pg_toast.<name>_toast
>
Wouldn't you have to include the schema name as well? Considering DBAs
using long identifiers you are likely to hit the maximum identifier
length....
Bernd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
