Hi,
I use a script like the example below to generate a list of the WAL files
that have to be saved by the backup job. I take the the names of the first
and last WAL files from the backup HISTORYFILE generated by
pg_start_backup() and pg_stop_backup(). The names of the WAL files between
the fi
Hi,
How can I speed up updates?
i try an
update tablename set datecol=null
~ 2.3 mio rows
After 6 hours, this was still not finished. selects and inserts are ok.
System is a dual xeon, 8gb ram, debian 64bit, pg 8.1.4
thanks
thomas
--
Thomas Markus
Tel:+49 30 29 36 399 - 22
Fax:+
2008/1/15 Thomas Markus <[EMAIL PROTECTED]>:
> Hi,
>
> How can I speed up updates?
> i try an
> update tablename set datecol=null
> ~ 2.3 mio rows
Got any foreign keys against that table? If so, they need to be
indexed on the other end.
What's the schema of that table and any related tables?
On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <[EMAIL PROTECTED]> wrote:
> I have installed postgres 8.2.4 in my development environment. I have
> the stats_command_string, stats_start_collector, stats_block_level,
> stats_row_level options turned on in postgresql.conf file but still the
> pg_st
Bonjour a Tous,
There is an AUTOVACUUM capability embedded within
PostgreSQL 8.2 (fedora core 7, postgresql-8.2.5-1.fc7)
How/where can I see in the log if indeed Autovacuum
started itself??
How can I trigger Autovacuum execution (as it
will do by its
"Sebastian Reitenbach" <[EMAIL PROTECTED]> writes:
> The WAL files have names like this:
> 00010001003C
> I am wonder what the meaning of the two 1 in the filename is?
The first one (the first 8 hex digits actually) are the current
"timeline" number. The second one isn't very interes
Hi,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Sebastian Reitenbach" <[EMAIL PROTECTED]> writes:
> > The WAL files have names like this:
> > 00010001003C
>
> > I am wonder what the meaning of the two 1 in the filename is?
>
> The first one (the first 8 hex digits actually) are the curren
Does dropping a database clean all of the system files that contain the data
from the database? If not, how can I cautiously identify which files need to
be purged? Are there pg admin tables that also need to cleaned like
pg_catalog.*?
Thanks,
Steve
"Sebastian Reitenbach" <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote:
>> You definitely should not expect to convert the names to integers.
> Then I do not understand why only the names of the first and the last WAL
> file are stored in the backup history file.
You can compar
When running WAL backups and warm-standby restores (we're currently on
PG 8.2), do the vacuumlo changes, vacuum, analyze and reindex type
commands get pushed through WAL files to the backup? Or will the backup
database not have these maintenance items done?
Thanks,
David
Yes I did restart the database after making these changes but still
there is no data in pg_statio_user_tables view.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 7:20 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@postgresql.org
Subject:
On Tue, 2008-01-15 at 09:19 -0800, David Wall wrote:
> When running WAL backups and warm-standby restores (we're currently on
> PG 8.2), do the vacuumlo changes, vacuum, analyze and reindex type
> commands get pushed through WAL files to the backup? Or will the backup
> database not have these
"Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes:
> Yes I did restart the database after making these changes but still
> there is no data in pg_statio_user_tables view.
Is data appearing in *any* of the pg_stat views?
regards, tom lane
---(en
Simon Riggs <[EMAIL PROTECTED]> writes:
> All of those commands produce WAL for critical changes to data blocks,
> so those are passed through correctly.
> Hint bits are not set following recovery, so a full database VACUUM may
> help later performance, depends upon your access patterns.
That's o
There is data in pg_stat_activity and pg_stat_database view. There is
also data in the pg_stat views related to system but not in pg_stat
views related to user .
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 10:04 AM
To: Bhella Paramjeet-PFCW
I just downloaded and installed latest available version of PG through
postgresql-8.3-dev1.msi.
While running initdb, I am getting an error on "Creating Conversions
... ". The file ascii_and_mic.dll is reported to be invalid.
Any clues?
--Imad
---(end of broadcast)--
"Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes:
> There is data in pg_stat_activity and pg_stat_database view. There is
> also data in the pg_stat views related to system but not in pg_stat
> views related to user .
[ squint.. ] That's pretty hard to believe --- those views use the same
un
On 16/01/2008, at 2:41 AM, Tom Lane wrote:
You definitely should not expect to convert the names to integers.
Presumably you can convert them to 96 bit integers? i.e. they are
always strings of hex characters?
Tom
---(end of broadcast)---
T
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I didn't understand how to insert a password into pg_dump command line.
So I write this steps for insert password on pg_dump.
1) Connect to postgres user
[EMAIL PROTECTED] su - postgres
2) Create a .pgpass file
Bash$ vi .pgpass
( it co
Tom Davies <[EMAIL PROTECTED]> writes:
> On 16/01/2008, at 2:41 AM, Tom Lane wrote:
>> You definitely should not expect to convert the names to integers.
> Presumably you can convert them to 96 bit integers? i.e. they are
> always strings of hex characters?
You could, but in most scripting lang
Hi,
If tar reports that a file was modified while it was being archived, does
that mean that the file was archived correctly, or is it corrupted in the
archive?
Does tar take a snapshot of the file so that even if it is modified, at
least the archive is safe?
Thanks
--
Brian Modra Land line: +2
Brian Modra wrote:
Hi,
If tar reports that a file was modified while it was being archived,
does that mean that the file was archived correctly, or is it corrupted
in the archive?
Does tar take a snapshot of the file so that even if it is modified, at
least the archive is safe?
You can not u
The documentation about WAL says that you can start a live backup, as long
as you use WAL backup also.
I'm concerned about the integrity of the tar file. Can someone help me with
that?
On 16/01/2008, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>
> Brian Modra wrote:
> > Hi,
> > If tar reports that
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Brian Modra wrote:
>> If tar reports that a file was modified while it was being archived,
>> does that mean that the file was archived correctly, or is it corrupted
>> in the archive?
> You can not use tar to backup postgresql if it is running.
Y
Tom Lane <[EMAIL PROTECTED]> wrote:
> Tom Davies <[EMAIL PROTECTED]> writes:
> > On 16/01/2008, at 2:41 AM, Tom Lane wrote:
> >> You definitely should not expect to convert the names to integers.
>
> > Presumably you can convert them to 96 bit integers? i.e. they are
> > always strings of hex c
25 matches
Mail list logo
