Hey,
There is only one autovacuum process when it starts up. Below is the
correct output from one of the logs
Good.
Do you have entries in the pg_autovacuum table in this database?
No. Its empty.
TIA
Dushyanth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
dushy escribió:
> My bad - I messed up the above. I grepped for autovacuum in my process
> logs and included all matches.
Ah, ok -- that makes more sense.
> There is only one autovacuum process when it starts up. Below is the
> correct output from one of the logs
Good.
Do you have entries in t
Hey,
>> # autovacuum processes
>>
>> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
>> autovacuum process db1
>> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
>> autovacuum process db1
>> postgres 20861 7.8 0.0 2298844 31028 ?
Hey,
On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
>
> Am forwarding back to list.
> One question? Did you do pg_ctl reload after changing the config file?
I did not change any config yet - autovacuum was always disabled since
the day PG was set up.
Thanks
Dushyanth
Dushyanth escribió:
> # autovacuum processes
>
> postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres:
> autovacuum process db1
> postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres:
> autovacuum process db1
> postgres 20861 7.8 0.0 2298844 310
-- Forwarded Message --
Subject: Re: [GENERAL] [Postgresql 8.2.3] autovacuum starting up even after
disabling ?
Date: Friday 04 July 2008 9:51 am
From: dushy <[EMAIL PROTECTED]>
To: "Adrian Klaver" <[EMAIL PROTECTED]>
Hey,
Thanks for the quick reply.
> From the docs:
> http
On Fri, Jul 04, 2008 at 12:37:48PM -0400, Tom Lane wrote:
> Yeah, estimate_num_groups doesn't have any special knowledge about IS
> NULL -- it just sees this as "an expression involving col". The
> general assumption about that is that the expression doesn't reduce
> the number of groups (think "c
Sam Mason <[EMAIL PROTECTED]> writes:
> I've just noticed that the planner in 8.3.3 doesn't seem to realize the
> difference in the result of the following:
> GROUP BY col;
> GROUP BY col IS NULL;
Yeah, estimate_num_groups doesn't have any special knowledge about IS
NULL -- it just sees this a
On Friday 04 July 2008 7:51 am, Dushyanth wrote:
> Hey all,
>
> Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64
> x86_64 x86_64 GNU/Linux).
>
> I have autovacuum tunrned off in the config, but it still seems to start up
> once everyday. What could be the cause of this ?
>
>
Hey all,
Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64 x86_64
x86_64 GNU/Linux).
I have autovacuum tunrned off in the config, but it still seems to start up once
everyday. What could be the cause of this ?
TIA
Dushyanth
$ psql -U postgres
postgres=# show autovacuum;
On Fri, Jul 4, 2008 at 11:01 AM, Gwyneth Morrison <[EMAIL PROTECTED]>
wrote:
> aravind chandu wrote:
>
> Hi folks,
>
> I need to load xml data in to database can you tell me they
> way how do I import xml data into postgresql database.
>
> lets dat this is the xml file
>
>
>
>
>
On 04/07/2008 15:36, Raymond O'Donnell wrote:
Having said that, what you need to do is use the -U option to specify
the Postgres user to use for the connection; if you don't, Postgres will
try to authenticate you as the Windows account under which you're logged
in. Look it up in the docs.
..
Hi,
I've just noticed that the planner in 8.3.3 doesn't seem to realize the
difference in the result of the following:
SELECT col, COUNT(*)
FROM tbl
GROUP BY col;
and
SELECT col IS NULL, COUNT(*)
FROM tbl
GROUP BY col IS NULL;
For a table with several million distinct values in "co
On 04/07/2008 15:03, Long Cui wrote:
Now I enter c:\Program Files\PostgreSQL\8.3\bin\createdb mydb;
PG asks me password
Is the password as superadmin's password or postgre's password what I
set when postgresql installed in windows
I try both, but does not work" user administrator password fail
aravind chandu wrote:
Hi folks,
I need to load xml data in to database can you tell me they way how do
I import xml data into postgresql database.
lets dat this is the xml file
Harry Potter
J K. Rowling
2005
29
Tom Lane wrote:
Gwyneth Morrison <[EMAIL PROTECTED]> writes:
What I am actually trying to get past is:
DELETE FROM data_table1
using data_table2 INNER JOIN
data_table1 ON data_table1.fkey =
data_table2.pkey;
Many thanks
Now I enter c:\Program Files\PostgreSQL\8.3\bin\createdb mydb;
PG asks me password
Is the password as superadmin's password or postgre's password what I set
when postgresql installed in windows
I try both, but does not work" user administrator password fail"
so How to log on as superadm
Bernd Helmle wrote:
--On Freitag, Juli 04, 2008 11:26:31 +0100 Richard Huxton
<[EMAIL PROTECTED]> wrote:
You ask for a particular index, it creates the index. Why complicate the
code checking for possible duplicate indexes if it's not a problem
people
tend to encounter?
And what would ch
--On Freitag, Juli 04, 2008 11:26:31 +0100 Richard Huxton
<[EMAIL PROTECTED]> wrote:
You ask for a particular index, it creates the index. Why complicate the
code checking for possible duplicate indexes if it's not a problem people
tend to encounter?
And what would characterize a "duplicate"
Cyril SCETBON wrote:
Richard Huxton wrote:
Cyril SCETBON wrote:
Hi guys,
Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?
Why should it stop you?
Do you have an application that randomly generates indexes?
I'm just wondering why postg
Richard Huxton wrote:
Cyril SCETBON wrote:
Hi guys,
Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?
Why should it stop you?
Do you have an application that randomly generates indexes?
I'm just wondering why postgresql/mysql work lik
hubert depesz lubaczewski wrote:
On Fri, Jul 04, 2008 at 11:54:37AM +0200, Cyril SCETBON wrote:
Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?
Why should it? Redundant indexes are not "bugs". And can be very useful
sometimes
Cyril SCETBON wrote:
Hi guys,
Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?
Why should it stop you?
Do you have an application that randomly generates indexes?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing lis
On Fri, Jul 04, 2008 at 11:54:37AM +0200, Cyril SCETBON wrote:
> Why postgres does not disallow creating redundants indexes ? Is it the
> same behaviour in postgresql 8.3 ?
Why should it? Redundant indexes are not "bugs". And can be very useful
sometimes (thing concurrent reindexing).
depesz
--
Hi guys,
Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?
postgres=# \d t1
Table "public.t1"
Column | Type | Modifiers
+---+---
id | integer | not null
name
http://www.skype.com/
On Tue, Jul 1, 2008 at 12:18 PM, Clemens Schwaighofer <[EMAIL PROTECTED]>
wrote:
>
>
> --On Monday, June 30, 2008 08:06:25 PM +0800 paragasu <[EMAIL PROTECTED]>
> wrote:
>
> i can name a lot of website written in mysql and php.
>> currently, i am planning to use postgresql
26 matches
Mail list logo
