Re: Setting a table to be ignored by autovacuum

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: <schmiddy(at)gmail(dot)com>, <dev(at)archonet(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Setting a table to be ignored by autovacuum
Date: 2010-02-19 14:03:01
Message-ID: BLU149-W15F1F98AE15EE5F6423AEBD4460@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


It is...

Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# SELECT version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9)
(1 row)

postgres=#

> Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
> From: dalroi(at)solfertje(dot)student(dot)utwente(dot)nl
> Date: Fri, 19 Feb 2010 12:24:24 +0100
> CC: schmiddy(at)gmail(dot)com; dev(at)archonet(dot)com; pgsql-general(at)postgresql(dot)org
> To: compuguruchrisbarnes(at)hotmail(dot)com
>
> On 18 Feb 2010, at 18:47, Chris Barnes wrote:
>
> > Right you are, I'm due to upgrade end of month on this system.
> > Here I was thinking 8.4. Sorry for the spam.
> >
> > Chris
> >
> >
> > [postgres(at)pgprd01:~/pgcheck]$ psql
> > Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
> > Type: \copyright for distribution terms
> > \h for help with SQL commands
> > \? for help with psql commands
> > \g or terminate with semicolon to execute query
> > \q to quit
> > postgres=#
>
> Actually that just tells that you're using an 8.3 _client_. It doesn't tell what server-version you're using.
> For the server version do:
>
> deploy=# SELECT version();
> version
> ----------------------------------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.4.1 on i386-apple-darwin10.0.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5646), 64-bit
> (1 row)
>
>
> Alban Hertroys
>
> --
> Screwing up is the best way to attach something to the ceiling.
>
>
> !DSPAM:1029,4b7e74ee10441497119330!
>
>

_________________________________________________________________
Check your Hotmail from your phone.
http://go.microsoft.com/?linkid=9708121

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-02-19 17:55:22 Re: PostgreSQL fails to start
Previous Message Alvaro Herrera 2010-02-19 13:47:55 Re: Doubts about oid