Re: [SQL]

2010-07-06 Thread silly sad
On 07/06/10 21:52, Justin Graf wrote: > I wrote an article covering this on the wiki > > http://wiki.postgresql.org/wiki/BinaryFilesInDB there are some "red flags" in communication (particularly reading papers) one of them is "binary data" which ITSELF IS NONSENCE. -- Sent via pgsql-sql mailing

[SQL] How To Calculate Table Size Minus Deleted Rows

2010-07-06 Thread Brian Helm
I'm in the need of a way to determine the disk size of a table that excludes dead tuples. Here is my situation. Our company would like to provide a "rolling storage" solution on a per schema basis. So basically we set a "quota" of the amount of disk space that a schema can occupy. Every night a

Re: [SQL]

2010-07-06 Thread Justin Graf
I wrote an article covering this on the wiki http://wiki.postgresql.org/wiki/BinaryFilesInDB I need to update to for 9.0 as bytea now allows HEX format strings http://developer.postgresql.org/pgdocs/postgres/datatype-binary.html All legitimate Magwerks Corporation quotations are sent in