Where is the definitive source for all things autovacuuming? I have
seen http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM.
Ultimately the issue I am having is that the postgresql logs show each
of the databases being 'autovacuumed' (actually quite often), but when
I click aro
Hi all - I am wondering if I can get a consensus on what to do about
this minor issue. I have looked through the archives and can't find a
definitive answer.
So I have a new 8.1 install on Linux (have not yet been able to
upgrade to 8.3). The documentation say that autovacuum is enabled by
defau
this table yet?
On Thu, Jun 5, 2008 at 5:47 PM, Collin Peters <[EMAIL PROTECTED]> wrote:
> Hi all - I am wondering if I can get a consensus on what to do about
> this minor issue. I have looked through the archives and can't find a
> definitive answer.
>
> So I have a new
09:39.245641" - WRONG)
* column 4 - the current time in Melbourne Australia ("2008-06-21
06:09:39.245641" - CORRECT)
Am I missing something obvious? Seems when I specify GMT+10:00 it
returns GMT-10:00 and vice versa. Note that column 2 & 3 are
timestamp withOUT timezone whi
TED]> wrote:
> On Friday 20 June 2008 1:19 pm, Collin Peters wrote:
>> I have a server of which the OS timezone is set to Pacific time
>> (currently -7). I run the following query on it
>>
>> SELECTnow(), now() AT TIME ZONE 'GMT+10:00', now() AT T
The table in question is a simple users table. The details are at the
bottom of this message. The performance on this table was fine during
testing with less than 100 users. Then we inserted about 37,000 records
into the table. Now a 'SELECT * FROM pp_users' takes over 40 seconds!!.
37,000
lease database... overwrite it with the development
database... then copy all your real data back into the release database
(this last step is probably quite difficult)
-Perhaps some combination of the two
Does anybody have any recommendations?
Regards,
Collin Peters
---(e
nnect!! Is it maybe running on a different port or something? Another
strange thing is that TOP reports the running process to be
/usr/local/pgsql/bin instead of /usr/local/pgsql/bin/postmaster which is
the way I remember it running before.
Collin Peters
I am just trying to connect locally. Only one machine involved. Is
there a way to tell what port the postmaster is running on if it is
running at all.
Collin
On Sun, 8 Oct 2000 10:55:32 +0200, Jarmo Paavilainen said:
>
>
> > I'm having problems starting postgres. What happens is
>
