Hi Jeff,
Thanks for your reply.
Yes, it took a while to complete the autovacuum.
I checked it again this morning:
last_autovacuum: 2013-04-14 06:17:02.9464+08
last_autoanalyze: 2013-04-13 20:27:12.396048+08
n_dead_tup: nill (or blank)
n_live_tup: 334453396
relpages: 2654868
reltuples: 3.3
PostgreSQL version:
PostgreSQL 9.2.2 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
OS:
Ubuntu 12.10
Linux machine0 3.5.0-26-generic #42-Ubuntu SMP Fri Mar 8 23:18:20 UTC
2013 x86_64 x86_64 x86_64 GNU/Linux
As for my case, I use this function as fun
Thanks! It works and my PostgreSQL is now 9.1.9.
On Fri, Apr 12, 2013 at 3:46 AM, François Beausoleil
wrote:
>
> Le 2013-04-08 à 22:45, Ascot Moss a écrit :
> > I am new to Postgresql.
> >
> > I have the Postgresql 9.1.8 installed in my Ubuntu 12.04 machine, I
> found 9.1.9 was released last wee
Hi,
I am new to PostgreSQL.
I have a PostgreSQL table named "test" with 300,000,000 records inserted,
it has only two fields (id, and int i). For testing purposes, after
inserts, all records have been updated once in order to make n_dead_tup =
300,000,000
Current PostgreSQL settings:
autovacuum
Hi, Magnus!
How you doing?
Today I have a "mirror" at github which I'm using to test and learn git and
it seems to be very good. Git is very powerful and it is easy to understand
why many are working on it.
Thanks for your help and advice on this subject.
On Sat, Apr 13, 2013 at 4:12 PM, Mag
On Sat, Apr 13, 2013 at 9:55 AM, Ascot Moss wrote:
>
> Current stat of "test" table:
> pg_class.reltuples: 3.8415e+08
> pg_class.relpages: 1703069
> last_autovacuum: null (or blank)
> last_autoanalyze: 2013-04-13 20:27:12.396048+08
> pg_stat_user_tables.n_dead_tup: 3
>
> The autovacuum th
On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr.
wrote:
>
> Hi all!
>
>
> I was thinking about moving Npgsql from cvs to another SCM. Possibly git.
>
> I'd like to know if there is any postgresql project host which supports git
> which you could recommend.
>
> I know there is git.postgres
Hi all!
I was thinking about moving Npgsql from cvs to another SCM. Possibly git.
I'd like to know if there is any postgresql project host which supports git
which you could recommend.
I know there is git.postgresql.org and github.
>From the new repository page of git.postgresql.org it says: "
(please ignore if duplicated)
Hi,
I am new to PostgreSQL.
I have a PostgreSQL table named "test" with 300,000,000 records inserted,
it has only two fields (id, and int i). For testing purposes, after
inserts, all records have been updated once in order to make n_dead_tup =
300,000,000
Current
