So the in-place update is a vital part of the program, because a range of
values
of column col should be stored together on the disk. Is there any way to
do such
a in-place update without generating much extra overhead?
Although in-place update is not possible, can he not use partitioning to
I thought that when I first read about WAL archiving but the documentation
explains quite well. Basically it is to stop a successful result being
returned in the event that the file already exists in the archive
destination (to cause an error in the event it tries to overwrite a file).
On Thu,
Deepak,
Does your backup script exclude the pg_xlog directory? There is no point
backing up the WAL files but you will want to make sure the archived WAL
files are added to the backup set afterwards.
How many files are in pg_xlog at the point where you stop the backup? It
may actually be that
Jen,
Regarding the first point, is postgres actually running? You can check this
by typing the following at a terminal -
ps -ef|grep postgres
Reload configuration is used to tell PostgreSQL to read in the configuration
file for any chances since the database started. If you want to start the
Vangelis,
I don't believe you can do file level copying of single databases
(especially as they are different versions).
Take a look at pg_dump in the documentation. This will do what you need I
think but at a logical level rather than physical.
On Fri, Nov 19, 2010 at 11:52 AM, Vangelis
:
On 11/19/2010 03:12 PM, Matthew Walden wrote:
Vangelis,
I don't believe you can do file level copying of single databases
(especially as they are different versions).
Hi Matthew, thanks for your answer.
If the different versions is a problem, I can downgrade one server and then
upgrade
You can create a trigger on the table to store the old/new values in an
audit table if that is what you mean?
On Wed, Nov 17, 2010 at 2:45 PM, Gauthier, Dave dave.gauth...@intel.comwrote:
How does one set pager off in interactive sql ?
I tried \set pager off, doesn't seem to work.
Thanks in Advance !
\pset pager off
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it
Dan,
It depends on your application. There is no point in creating an index with
the same 3 columns in the primary key (in the same order).
If you have an index on COL1, COL2 and COL3 (in that order) then if you have
a query such as SELECT COL1, COL2, COL3 from T1 then the index will be
Apparently (after reading the documentation link provided by Tom) there can
be value to indexes when accessed with leading columns missing.
That is a new one on me too - interesting.
I suppose it comes down to testing at the end of the day - if you set
enable_seqscan to false and EXPLAIN ANALYSE
Dave,
Does your application use temporary tables? This may explain high
autovacuum activity in the catalog tables.
With regards to your tables, I wrote this very script to give me an
indication of the amount of required activity on the user tables. I
deliberately keep this one simple and it
12 matches
Mail list logo
