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(at)candle(dot)pha(dot)pa(dot)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)