Re: [HACKERS] what is the smallest working page size for postgresql

2005-12-22 Thread Qingqing Zhou
"Hannu Krosing" <[EMAIL PROTECTED]> wrote > > Could anybody tell me what is the smallest working page size for > postgresql ? > > I have a table where access is highly random over huge table getting > usually only one small tuple from each page. One way to get more > performance could be using sma

[HACKERS] what is the smallest working page size for postgresql

2005-12-22 Thread Hannu Krosing
Hi Could anybody tell me what is the smallest working page size for postgresql ? I have a table where access is highly random over huge table getting usually only one small tuple from each page. One way to get more performance could be using smaller page size, so the per-tuple read overhead would