On Mon, Sep 10, 2012 at 9:04 PM, David Morton wrote:
> Is there any way of making the table 'read only' so its nice and tidy /
> immutable ?
Once a table actually *is* read-only, you can VACUUM FREEZE it.
rls
--
:wq
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make c
What are the implications of doing this ?
Some times we experience the vacuum being started to prevent wraparound, i
understand this will always take place if required regardless of autovacuum
settings ?
Is there any way of making the table 'read only' so its nice and tidy
/ immutable ?
Dave
On
On Mon, Sep 10, 2012 at 5:30 PM, David Morton wrote:
> We have many large tables which contain static historical data, they are
> auto vacuumed on a regular basis (sometimes to prevent wraparound) which i
> suspect causes a few annoying side effects:
> - Additional WAL file generation
> - Increase
turn auto vacuum off for those tables.
于 2012/9/11 4:30, David Morton 写道:
We have many large tables which contain static historical data, they
are auto vacuumed on a regular basis (sometimes to prevent wraparound)
which i suspect causes a few annoying side effects:
- Additional WAL file genera
We have many large tables which contain static historical data, they are
auto vacuumed on a regular basis (sometimes to prevent wraparound) which i
suspect causes a few annoying side effects:
- Additional WAL file generation
- Increased 'changed' data as far as our online rsync based backups are
co
On Mon, Sep 10, 2012 at 12:06:10PM -0500, Kevin Grittner wrote:
> Craig James wrote:
> > Sergey Konoplev wrote:
> >> Bruce Momjian wrote:
> >>> On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
> Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just
> using pg_upgrade
Another question, when I get a reply from the list, to which email
should I then reply?
To all? the User posting, or pgsql-admin@?
thanks
On Mon, Sep 10, 2012 at 12:06 PM, Kevin Grittner
wrote:
> Craig James wrote:
>> Sergey Konoplev wrote:
>>> Bruce Momjian wrote:
On Thu, Sep 6, 2012 at
Thank you Craig
On Mon, Sep 10, 2012 at 12:30 PM, Craig James wrote:
>
>
> On Mon, Sep 10, 2012 at 10:17 AM, Antoine Guidi
> wrote:
>>
>> Another question, when I get a reply from the list, to which email
>> should I then reply?
>> To all? the User posting, or pgsql-admin@?
>
>
> Either reply-to
On Mon, Sep 10, 2012 at 10:17 AM, Antoine Guidi wrote:
> Another question, when I get a reply from the list, to which email
> should I then reply?
> To all? the User posting, or pgsql-admin@?
>
Either reply-to-all or reply to the pgsql-admin address. Either way,
everyone gets it who participated
On Mon, Sep 10, 2012 at 12:06 PM, Kevin Grittner
wrote:
> Craig James wrote:
>> Sergey Konoplev wrote:
>>> Bruce Momjian wrote:
On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
> Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just
> using pg_upgrade? For what
Craig James wrote:
> Sergey Konoplev wrote:
>> Bruce Momjian wrote:
>>> On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just
using pg_upgrade? For what I could read, the only exception
would be if I was using a
Thanks!
于 2012/9/7 20:20, Sergey Konoplev 写道:
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter wrote:
base_20120902.tar.gz
27781958.tar.gz
27781959.tar.gz
Now I want to restore it on another server with only one disk. I'm confused
how to handle those tablespace files. Is there a guideline or doc
12 matches
Mail list logo
