[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 was termina

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, 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. That is only 2

Re: [GENERAL] Database Bloat

2012-08-20 Thread elliott
10 PM, John R Pierce wrote: 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 o

[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 f

Re: [GENERAL] setting local variable

2011-04-24 Thread Elliott Prechter
syntax error on the line 'set _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 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.

[GENERAL] The efficiency of the WAL log writer

2011-02-17 Thread Steven Elliott
QL processes as closely, but some of them appear to behave in a similar manner. -- ---- | Steven Elliott | http://selliott.org | sellio...@austin.rr.com | -- Sent via pgs