Zdenek Kotala <[EMAIL PROTECTED]> writes:
> It does not solve problems for example with TOAST tables. If chunks does not
> fit
> on a new page layout one of the chunk tuple have to be moved to free page. It
> means you get a lot of pages with ~2kB of free unused space. And if max chunk
> size i
Bruce Momjian napsal(a):
Heikki Linnakangas wrote:
Zdenek Kotala wrote:
4) Implementation
The main point of implementation is to have several version of
PageHeader structure (e.g. PageHeader_04, PageHeader_03 ...) and correct
structure will be handled in special branch (see examples).
(this
Ron Mayer napsal(a):
Tom Lane wrote:
Another issue is that it might not be possible to update a page for
lack of space. Are we prepared to assume that there will never be a
transformation we need to apply that makes the data bigger? In such a
situation an in-place update might be impossible,
Tom Lane wrote:
Another issue is that it might not be possible to update a page for
lack of space. Are we prepared to assume that there will never be a
transformation we need to apply that makes the data bigger? In such a
situation an in-place update might be impossible, and that certainly
tak
On Jun 11, 2008, at 10:42 AM, Heikki Linnakangas wrote:
Another issue is that it might not be possible to update a page for
lack of space. Are we prepared to assume that there will never be a
transformation we need to apply that makes the data bigger?
We do need some solution to that. One ide
Heikki Linnakangas wrote:
> Zdenek Kotala wrote:
> > 4) Implementation
> >
> > The main point of implementation is to have several version of
> > PageHeader structure (e.g. PageHeader_04, PageHeader_03 ...) and correct
> > structure will be handled in special branch (see examples).
>
> (this wo
Gregory Stark wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > (Likely counterexample: adding collation info to text values.)
>
> I don't think the argument really needs an example, but I
> would be pretty
> upset if we proposed tagging every text datum with a
> collation. Encoding
> perha
"Tom Lane" <[EMAIL PROTECTED]> writes:
> (Likely counterexample: adding collation info to text values.)
I don't think the argument really needs an example, but I would be pretty
upset if we proposed tagging every text datum with a collation. Encoding
perhaps, though that seems like a bad idea to
Heikki Linnakangas napsal(a):
Tom Lane wrote:
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
(this won't come as a surprise as we talked about this in PGCon, but)
I think we should rather convert the page structure to new format in
ReadBuffer the first time a page is read in. That would keep
Heikki Linnakangas napsal(a):
Zdenek Kotala wrote:
4) Implementation
The main point of implementation is to have several version of
PageHeader structure (e.g. PageHeader_04, PageHeader_03 ...) and
correct structure will be handled in special branch (see examples).
(this won't come as a surp
Tom Lane wrote:
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
(this won't come as a surprise as we talked about this in PGCon, but) I
think we should rather convert the page structure to new format in
ReadBuffer the first time a page is read in. That would keep the changes
a lot more isolat
Tom Lane napsal(a):
Zdenek Kotala <[EMAIL PROTECTED]> writes:
There are examples:
void PageSetFull(Page page)
{
switch ( PageGetPageLayoutVersion(page) )
{
case 4 : ((PageHeader_04) (page))->pd_flags |= PD_PAGE_FULL;
break;
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> (this won't come as a surprise as we talked about this in PGCon, but) I
> think we should rather convert the page structure to new format in
> ReadBuffer the first time a page is read in. That would keep the changes
> a lot more isolated.
The p
Zdenek Kotala wrote:
4) Implementation
The main point of implementation is to have several version of
PageHeader structure (e.g. PageHeader_04, PageHeader_03 ...) and correct
structure will be handled in special branch (see examples).
(this won't come as a surprise as we talked about this in
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> There are examples:
> void PageSetFull(Page page)
> {
> switch ( PageGetPageLayoutVersion(page) )
> {
> case 4 : ((PageHeader_04) (page))->pd_flags |= PD_PAGE_FULL;
> break;
> defaul
1) Overview
This proposal is part of inplace upgrade project. PostgreSQL should be able to
read any page in old version. This is basic for all possible upgrade method.
2) Background
We have several macros for manipulating of the page structures but this list is
not complete and many parts o
16 matches
Mail list logo
