Hi Thomas,
I am aware of of tht above 9.0 thr is default
auto-vacuuming.but I just want to tune according to my
needs..
On Mon, Jul 29, 2013 at 10:01 PM, Thomas Kellerer wrote:
> Manish Kediyal wrote on 29.07.2013 09:17:
>
> I have various DB in my DB cluster, i want to vacuum
On Mon, Jul 29, 2013 at 1:28 PM, German Becker wrote:
> checkpoint_segments = 256 # in logfile segments, min 1, 16MB
> each
>
I'm curious about checkpoint_segments. 256 seems pretty high -- did testing
show that that helps?
> checkpoint_completion_target = 0.7 # checkpoint
Here are the values:
# - Checkpoints -
checkpoint_segments = 256 # in logfile segments, min 1, 16MB
each
#checkpoint_timeout = 5min # range 30s-1h
checkpoint_completion_target = 0.7 # checkpoint target duration, 0.0 -
1.0
#checkpoint_warning = 30s # 0
On Mon, Jul 29, 2013 at 12:41 PM, German Becker wrote:
> Luis, The disk only has the WAL (pg_xlog ) directory. Brett, Here are the
> mount options:
>
> /dev/sdb1 on /storage/sdb1 type ext3
> (rw,noatime,data=writeback,errors=remount-ro)
>
> BTW The original fs was ext4, now I am trying with ext3,
BTW I have all this data ploted using munin, let me know if you are
intrested in looking at the graphs, I send them
On Mon, Jul 29, 2013 at 4:41 PM, German Becker wrote:
> Luis, The disk only has the WAL (pg_xlog ) directory. Brett, Here are the
> mount options:
>
> /dev/sdb1 on /storage/sdb1 ty
Luis, The disk only has the WAL (pg_xlog ) directory. Brett, Here are the
mount options:
/dev/sdb1 on /storage/sdb1 type ext3
(rw,noatime,data=writeback,errors=remount-ro)
BTW The original fs was ext4, now I am trying with ext3, with the exact
same results. No noticeable changes using diferent jo
Is your temp stats dir in the same disk?
On Jul 29, 2013 7:59 PM, "German Becker" wrote:
>
> Brett,
>
> Yes I'm not impying it is postgres related, perhaps is even a normal thing
> of ext3 /ext4 filesystem, but, this behavioiur is only notable when using
> postgres and in particular the wal files
Okay, so it's not happening at the same time of day or anything. What are
your mount options for the WAL disk?
On Mon, Jul 29, 2013 at 12:58 PM, German Becker wrote:
>
> Brett,
>
> Yes I'm not impying it is postgres related, perhaps is even a normal thing
> of ext3 /ext4 filesystem, but, this b
Brett,
Yes I'm not impying it is postgres related, perhaps is even a normal thing
of ext3 /ext4 filesystem, but, this behavioiur is only notable when using
postgres and in particular the wal files, as it is very hard disk
intensive, soy maybe somenone has seen this befores. The server only task
is
Manish Kediyal wrote on 29.07.2013 09:17:
I have various DB in my DB cluster, i want to vacuum all DB's using a shell
script.. scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum
all DB's
Is there a specific reason you don't want to use auto-
"...like if the disk/filesystem gets slower during one hour or so"
What about a different scheduled task on the system, not necessarily
Postgres related?
On Mon, Jul 29, 2013 at 9:17 AM, German Becker wrote:
> Alvaro,
>
> Thanks for your reply. I believe that the only possibility is autovacum
>
Alvaro,
Thanks for your reply. I believe that the only possibility is autovacum
activity I will check that. Anyway what puzzles me is that
the throughput does not increase like i might expect if there where high
VACUUM activity, only the WAIT TIME and thus the UTILIZATION. Is like if
the disk/file
On Mon, Jul 29, 2013 at 6:49 PM, Asmus Reinhard <
reinhard.as...@spdfraktion.de> wrote:
> Hallo,
>
> ** **
>
> between
>
> ** **
>
> pg_dumpall > alldb.sql (store)
>
> ** **
>
>
According above command,you are taking all databases dump in plain text
format which are available in Pos
Hallo,
between
pg_dumpall > alldb.sql (store)
and
psql -f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, ...) ?
Any help is appreciated.
Thanks Raghu,
On Mon, Jul 29, 2013 at 1:34 PM, raghu ram wrote:
>
> On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal
> wrote:
>
>> Thanks Raghu,
>>
>> Is there a shell script for it, i wanna scheduled that through cron.
>>
>>
> You can create below Script for scheduling purpose:
>
> #!/bin/bash
On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal wrote:
> Thanks Raghu,
>
> Is there a shell script for it, i wanna scheduled that through cron.
>
>
You can create below Script for scheduling purpose:
#!/bin/bash
PGHOME=/opt/PostgreSQL/9.2/bin
LOG=/Backup/cron-script-logs
LOGFILE=vacuum_analyze_`d
Thanks Raghu,
Is there a shell script for it, i wanna scheduled that through cron.
Thanks
Manish
On Mon, Jul 29, 2013 at 12:56 PM, raghu ram wrote:
> On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal > wrote:
>
>> Hi,
>>
>> I have various DB in my DB cluster, i want to vacuum all DB's using
On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal
wrote:
> Hi,
>
> I have various DB in my DB cluster, i want to vacuum all DB's using a
> shell script.. scheduling via cron.
> It would be a great help if anyone could provide me a Shell Script to
> vacuum all DB's
>
>
>
>
> You can perform vacu
Hi,
I have various DB in my DB cluster, i want to vacuum all DB's using a shell
script.. scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to
vacuum all DB's
Thanks and Regards
Manish Kediyal
Hello,
yesterday, in the process of bloat control, our maintenance script decided
to do a vacuum full on a table, because there was more than 50% free space
/ dead records due to a massive update.
The table normally takes about 20minutes to do a vacuum full (int he last
couple of months we alread
20 matches
Mail list logo
