Обсуждение: 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.

Thanks, regards,


--
Mikhail Routchiev ----- Credit Suisse First Boston Securities (Japan) Ltd.
Shiroyama Hills 4-3-1 Toranomon Minato-ku, Tokyo 105 ---------------------
Voice:81-3-5404-9514  Fax:81-3-5404-9822  Email:mikhail.routchiev@csfb.com

>
> 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)