Re: [GENERAL] Joins and links - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Joins and links
Date
Msg-id 199907051636.MAA05541@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Joins and links  (David Warnock <david@sundayta.co.uk>)
List pgsql-general
> Bruce,
>
> Thanks for your informative messages.
>
> > Well, sometimes it is better to have control over when this happens.
> > What is why cluster is nice, and we don't have time to add dynamic
> > cluster right now.
>
> I personally would not see it as a high priority.
>
> My only reason for suggesting it was as a possible way to help provide
> more performance for Leon without adding the full record number support
> that he was asking for.
>

In fact, you were mentioning that inserting into the middle is slow, but
that sequential adding to the end is good, but in fact, heap already
does this, doesn't it?  I guess if you only add occasionally, it is OK.
Also, our no-over-write table structure had a tendency to mess up that
ordering because updated rows do not go into the same place as the
original row.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: David Warnock
Date:
Subject: Re: [GENERAL] Joins and links
Next
From: David Warnock
Date:
Subject: Re: [GENERAL] Joins and links