Re: [HACKERS] [PATCHES] TODO Item - Add system view to show free space map

2005-10-28 Thread Simon Riggs
On Fri, 2005-10-28 at 08:31 -0300, Alvaro Herrera wrote: Simon Riggs wrote: On Fri, 2005-10-28 at 13:21 +1300, Mark Kirkwood wrote: regression=# SELECT c.relname, m.relblocknumber, m.blockfreebytes FROM pg_freespacemap m INNER JOIN pg_class c

Re: [HACKERS] [PATCHES] TODO Item - Add system view to show free space map

2005-10-28 Thread Martijn van Oosterhout
On Fri, Oct 28, 2005 at 05:05:25PM +0100, Simon Riggs wrote: 3. Helping Readahead efficiency: Currently blocks are allocated one at a time. If many tables are extending at the same time, the blocks from multiple tables will be intermixed together on the disk. Reading the data back takes more

Re: [HACKERS] [PATCHES] TODO Item - Add system view to show free space map

2005-10-28 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: There are a few issues with current FSM implementation, IMHO, discussing as usual the very highest end of performance: Do you have any evidence that the FSM is actually a source of performance issues, or is this all hypothetical?