[GENERAL] Autovacuum Launcher Process Exception

2012-10-30 Thread elliott
Hello, I have been running PostgreSQL for many months and just recently started getting this exception upon start up. Does anyone know what the issue might be? LOG: database system is ready to accept connections LOG: autovacuum launcher started LOG: autovacuum launcher process PID 7060

Re: [GENERAL] Database Bloat

2012-08-22 Thread elliott
Yes, it is a tif file. Uncompressed it is around 85M. On 8/22/2012 1:20 PM, Jeff Janes wrote: On Mon, Aug 20, 2012 at 10:53 AM, elliottelli...@cpi.com wrote: Hi, I am using PostgreSQL 9.1 and loading very large tables ( 13 million rows each ). The flat file size is only 25M.

[GENERAL] Database Bloat

2012-08-20 Thread elliott
Hi, I am using PostgreSQL 9.1 and loading very large tables ( 13 million rows each ). The flat file size is only 25M. However, the equivalent database table is 548MB. This is without any indexes applied and auto vacuum turned on. I have read that the bloat can be around 5 times greater

Re: [GENERAL] Database Bloat

2012-08-20 Thread elliott
: On 08/20/12 10:53 AM, elliott wrote: Hi, I am using PostgreSQL 9.1 and loading very large tables ( 13 million rows each ). The flat file size is only 25M. However, the equivalent database table is 548MB. This is without any indexes applied and auto vacuum turned on. I have read

Re: [GENERAL] setting local variable

2011-04-24 Thread Elliott Prechter
_object = insert ' I searched through the docs but don't know what I'm doing wrong. Thanks! Elliott -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] The efficiency of the WAL log writer

2011-02-18 Thread Steven Elliott
On Thu, 2011-02-17 at 10:26 -0500, Tom Lane wrote: Steven Elliott sellio...@austin.rr.com writes: I don't think the current behavior is particularly harmful, but maybe PostgreSQL could be made to idle more quietly. Yeah, this is something that's on my personal to-do list. It's not really

[GENERAL] The efficiency of the WAL log writer

2011-02-17 Thread Steven Elliott
. -- | Steven Elliott | http://selliott.org | sellio...@austin.rr.com | -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http