- "Jamie Tufnell" <[EMAIL PROTECTED]> escribió:
> pgpool-II with heartbeat for failover. The pgpool-II configuration
> matrix (http://pgpool.projects.postgresql.org/) isn't terribly clear
> (there's no legend) but it leads me to believe failover and load
> balancing are mutually exclusive op
Hi there,
I need some help or just some hints. I am having problems with vacuum full
in one table only: "clifatura".
That table has today around 7 million rows.
I scheduled on the server a cron job to run VACUUM FULL every day at 23 P.M,
but on the following day, at 8 A.M. vacuum is yet working on
Rafael Domiciano wrote:
Hei
> I need some help or just some hints. I am having problems with vacuum
> full in one table only: "clifatura".
> That table has today around 7 million rows.
>
How big is the database?
> I scheduled on the server a cron job to run VACUUM FULL every day at 23
> P.M, b
The database has around 40 Gb.
If I not use vacuum full everyday the database get very slow.
There is no deadlock on the database.
The vacuum does a clean in the table and in every index of the table
"clifatura". And in the end of the vacuum, seems that vacuum is working hard
on the table (Vacuum
2008/11/26 Rafael Domiciano <[EMAIL PROTECTED]>:
> The database has around 40 Gb.
> If I not use vacuum full everyday the database get very slow.
>
> There is no deadlock on the database.
You didn't mention if you were using autovacuum or not. You also
didn't mention whether or not you'd tried r
I'm not using autovacuum. Regular vacuum goes ok.To see the last 10 lines of
verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the "speed" of doing
vacuum? I found something about it googling.
2008/11/26 Scott Marlowe <[EMAIL PROTECTED]>
> 2008/11/26 R
Try to follow the steps given in following link -
http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc
Date: Tue, 25 Nov 2008 02:32:46 -0800From: [EMAIL PROTECTED]: Re: [ADMIN]
PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]:
[EMAIL PROTECTED]
Service
On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano
<[EMAIL PROTECTED]> wrote:
> I'm not using autovacuum. Regular vacuum goes ok.
> To see the last 10 lines of verbose i will need to run vacuum tonight
> If a run a reindex before the vacuum full, increase the "speed" of doing
> vacuum? I found some
Rafael Domiciano wrote:
> The database has around 40 Gb.
>
> If I not use vacuum full everyday the database get very slow.
>
> There is no deadlock on the database.
> The vacuum does a clean in the table and in every index of the table
> "clifatura". And in the end of the vacuum, seems that vacu
Rafael Domiciano wrote:
I'm not using autovacuum. Regular vacuum goes ok.
To see the last 10 lines of verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the "speed" of
doing vacuum? I found something about it googling.
It might help a bit, but by the
On Wed, Nov 26, 2008 at 12:54 PM, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote:
> Rafael Domiciano wrote:
>>
>> I'm not using autovacuum. Regular vacuum goes ok.
>> To see the last 10 lines of verbose i will need to run vacuum tonight
>>
>> If a run a reindex before the vacuum full, increase the "
Hi...
I have an IBM server with NUMA architecture, two nodes with 4 CPU quad core and
64 GB of RAM each, and PostgrSQL 8.3.5. Is there any way to avoid the
performance degradation when the load goes up and used the two nodes? I
understand this performance degradation is due to the higher la
Thanks Vishal,
I followed the document and now the statistics of the job is appearing and
showing successful but actually backup is not made via this job. In output tab
it gives the following error:
could not open the file "D:\xxx.backup":Permission denied.
I tried to perform the task from bot
13 matches
Mail list logo
