"Benjamin Krajmalnik" wrote:
> I had a very strange occurrence 2 days ago where autovacuum
> appears to have stopped running.
What did you see which led you to that conclusion? Did ps show the
'autovacuum launcher process'?
> I did not see any error messages in pg_log. The problem caused a
>
I think you can do something like that as a postgresql user
su - postgres
psql -c "\! uname -n"
or actually you can do that inside of any sql statement
psql
\!uname -n
> Date: Fri, 30 Apr 2010 09:14:04 -0500
> From: reeds...@rice.edu
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN
TO be truthful, I did not check that.
I arrived at the conclusion because although I have 10 autovacuum
threads, none of the tables had been autoanalyzed or autovacuumed in
hours (and due to the nature of the activity they do so every minute).
If I ever see this behavior now I know what to check fo
* Ramiro Barreca wrote:
> As Virtualiaztion is almost discarded after reading many articles that
> locate this option in the "don'ts-list", we want to know your experience (if
> any) about installing a PostgreSQL and a Firebird server in the same Linux
> server.
Depends on the kind of virtualiza
Gavin Kistner writes:
> On Apr 30, 2010, at 3:35 PM, Tom Lane wrote:
>> Does the theory of a pre-existing smaller shmem segment make sense from
>> your end? In particular, had you previously had another Postgres server
>> running on that machine, and perhaps killed it ungracefully?
> It seems pr
"Benjamin Krajmalnik" writes:
> TO be truthful, I did not check that.
> I arrived at the conclusion because although I have 10 autovacuum
> threads, none of the tables had been autoanalyzed or autovacuumed in
> hours (and due to the nature of the activity they do so every minute).
> If I ever see
# - Cost-Based Vacuum Delay -
#vacuum_cost_delay = 0ms# 0-100 milliseconds
#vacuum_cost_page_hit = 1 # 0-1 credits
#vacuum_cost_page_miss = 10 # 0-1 credits
#vacuum_cost_page_dirty = 20# 0-1 credits
vacuum_cost_limit = 1
On Thu, Apr 29, 2010 at 11:42 PM, Tom Lane wrote:
> Gavin Kistner writes:
>> Mac OS X 10.6.3
>> Built and installed PG 8.4.3 from source
>> Trying to start the server, I get "could not create shared memory segment:
>> Invalid argument".
>
> OSX is *notoriously* unfriendly about configuring shm p
Scott Marlowe writes:
> On Thu, Apr 29, 2010 at 11:42 PM, Tom Lane wrote:
>> OSX is *notoriously* unfriendly about configuring shm parameters.
>> You look at it sidewise, it doesn't work, and generally won't tell
>> you why it's refusing to talk to you. We document a few of the known
>> constrai
* Ben Kim wrote:
Hi,
> I don't like the VMWare environment, but it's not my choice, and assuming
> the cpu load is ok, will there be any benefits if I put each database on
> separate partitions, vs. simply using the one data directory?
Depending on your underlying storage, it might be advisab
* Rodger Donaldson wrote:
> Agreed. This is particularly the case once one starts thinking about
> security updates and so on - my experience is that hand-rolling from
> source tends to result in patching lagging far behind after a while.
Depends on whether you have an proper QM and build mac
11 matches
Mail list logo
