[HACKERS] question about postgres storage management

2013-04-19 Thread Will Childs-Klein
Hello All, I'm writing today to inquire about finding the exact point in the source where postgres writes to disk. I'm trying to implement some compression in postgres. The idea is to compress the data right when its written to disk, to reduce the amount of data written to disk, reducing the

Re: [HACKERS] question about postgres storage management

2013-04-19 Thread Stephen Frost
Will, * Will Childs-Klein (willc...@gmail.com) wrote: I'm writing today to inquire about finding the exact point in the source where postgres writes to disk. I'm trying to implement some compression in postgres. PostgreSQL already does compression in most cases where you'd want it done..

Re: [HACKERS] question about postgres storage management

2013-04-19 Thread Merlin Moncure
On Fri, Apr 19, 2013 at 10:17 AM, Will Childs-Klein willc...@gmail.com wrote: Hello All, I'm writing today to inquire about finding the exact point in the source where postgres writes to disk. I'm trying to implement some compression in postgres. The idea is to compress the data right when its

Re: [HACKERS] question about postgres storage management

2013-04-19 Thread Christopher Browne
I would expect the strategy you have in mind to be more useful to apply at the filesystem level, so that it's not in Postgres altogether. (Ala Stacker, remember DR-DOS?) But, to speak arguable heresy, the demerits of this sort of thing are described nicely in Another Database's Documentation:

Re: [HACKERS] question about postgres storage management

2013-04-19 Thread Merlin Moncure
On Fri, Apr 19, 2013 at 11:17 AM, Christopher Browne cbbro...@gmail.com wrote: I would expect the strategy you have in mind to be more useful to apply at the filesystem level, so that it's not in Postgres altogether. (Ala Stacker, remember DR-DOS?) But, to speak arguable heresy, the