Re: [HACKERS] One problem with Postgres...\

>
> Hi,
>
>     Is there any plan to deal with the problem of Postgres server going
> through inefficiencies of the filesystem (because the separate tables are
> placed into separate files)?
>
>     If on Solaris, or Sun, there is a big enough table (say 300MB), it
> takes 600MB of the disk space, and grows proportionally (2 times!). So we could
> observe: 1) loss of disk space, and 2) loss of performance as well, because of
> going through file system block search (for big files) may not be very
> efficient, compare to Sybase&Co. (they use partitions, and deal with their own
> 'file system'...)
>
>     Well, one recommendation could be to go with the efficient
> filesystem... But I believe it may not be appropriate for most of users.
>
>     If anybody knows how to overcome this problem, please let me know.
>

We have discussed this, and it is not as big a win as you may think.  An
Informix guy feels this is true, so it is not an idle thought.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)