Re: [HACKERS] Make tuples_per_page pr. table configureable.

2010-09-22 Thread Robert Haas
On Tue, Sep 21, 2010 at 10:33 PM, Itagaki Takahiro wrote: > I didn't read previous discussions, but did we have consensus that "number > of tuples" is better than other units for the parameter? For example, > "threshold bytes" or "percentage in a page" also seems to be reasonable for > me. I thi

Re: [HACKERS] Make tuples_per_page pr. table configureable.

2010-09-21 Thread Jesper Krogh
On 2010-09-22 04:33, Itagaki Takahiro wrote: On Wed, Sep 22, 2010 at 3:44 AM, Jesper Krogh wrote: Command to set "tuples_per_page" is: ALTER TABLE set (tuples_per_page = X) where 1<= X<= 32. The tuples_per_page means *minimal* number of tuples in a page, right? A page may contain mo

Re: [HACKERS] Make tuples_per_page pr. table configureable.

2010-09-21 Thread Itagaki Takahiro
On Wed, Sep 22, 2010 at 3:44 AM, Jesper Krogh wrote: > Command to set "tuples_per_page" is: > ALTER TABLE set (tuples_per_page = X) > where 1 <= X <= 32. The tuples_per_page means *minimal* number of tuples in a page, right? A page may contain more tuples when the size of tuples are small enough

[HACKERS] Make tuples_per_page pr. table configureable.

2010-09-21 Thread Jesper Krogh
Hi. This is a follow up and updated patch on several old discussions: http://archives.postgresql.org/pgsql-hackers/2009-07/msg01065.php http://archives.postgresql.org/pgsql-admin/2010-04/msg00164.php http://archives.postgresql.org/pgsql-hackers/2009-06/msg00831.php First patch: http://archives.po