Re: [HACKERS] Page layout footprint

2008-09-05 Thread Heikki Linnakangas
Zdenek Kotala wrote: OK. You convinced me that information could be collected from other sources. Great, I'm glad we're in agreement. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to y

Re: [HACKERS] Page layout footprint

2008-09-05 Thread Zdenek Kotala
Heikki Linnakangas napsal(a): Zdenek Kotala wrote: Heikki Linnakangas napsal(a): AFAICS you can get all the same information from pg_controldata. We have a pretty good idea of the alignments of all the usual platforms anyway. If someone says in a bug report that they're running on x86_64 o

Re: [HACKERS] Page layout footprint

2008-09-05 Thread Heikki Linnakangas
Zdenek Kotala wrote: Heikki Linnakangas napsal(a): I'm afraid I still fail to see the usefulness of this. gdb knows how to deal with structs, If I correct that GDB knows structure only if you have debug version. But usually you don't have debug version on production system. Using gdb witho

Re: [HACKERS] Page layout footprint

2008-09-05 Thread Zdenek Kotala
Gregory Stark napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: Hmm, good question. For example ZFS is platform independent, you can take disk from SPARC machine and plug it into x86 and ZFS works perfectly. FWIW as far as I know *all* filesystems are platform independent. (Of course now

Re: [HACKERS] Page layout footprint

2008-09-05 Thread Gregory Stark
Zdenek Kotala <[EMAIL PROTECTED]> writes: > Hmm, good question. For example ZFS is platform independent, you can take > disk > from SPARC machine and plug it into x86 and ZFS works perfectly. FWIW as far as I know *all* filesystems are platform independent. (Of course now someone is surely go

Re: [HACKERS] Page layout footprint

2008-09-05 Thread Zdenek Kotala
Heikki Linnakangas napsal(a): Zdenek Kotala wrote: The original proposal (http://archives.postgresql.org/message-id/[EMAIL PROTECTED]) contains two parts. First part is implementation of --footprint cmd line switch which shows you page layout structures footprint. It is useful for development

Re: [HACKERS] Page layout footprint

2008-09-04 Thread Heikki Linnakangas
Zdenek Kotala wrote: The original proposal (http://archives.postgresql.org/message-id/[EMAIL PROTECTED]) contains two parts. First part is implementation of --footprint cmd line switch which shows you page layout structures footprint. It is useful for development (mostly for in-place upgrade)

Re: [HACKERS] Page layout footprint

2008-09-02 Thread Zdenek Kotala
Zdenek Kotala napsal(a): 32/64 bit issue is little bit different story and it is general (not only SPARC but on SPARC has bigger impact). Problem is that CRC32 gives probably different result when it is compiled 32bit or 64bit. I'm going to examine it more. I'm sorry about noise. Everythin

Re: [HACKERS] Page layout footprint

2008-09-02 Thread Heikki Linnakangas
Zdenek Kotala wrote: Hi Heikki, I'm sorry for lack of explanation. It is my fault. Heikki says (on commit fest wiki): I believe I debunked this patch enough already. Apparently there's some compatibility issue between 32-bit and 64-bit Sparcs, but this patch didn't catch that. It

[HACKERS] Page layout footprint

2008-09-02 Thread Zdenek Kotala
Hi Heikki, I'm sorry for lack of explanation. It is my fault. Heikki says (on commit fest wiki): I believe I debunked this patch enough already. Apparently there's some compatibility issue between 32-bit and 64-bit Sparcs, but this patch didn't catch that. It doesn't seem like thi