Hi,
Yes, you are right.
But -d option not suitable for me. Because our flatform use -C option and -d
template1 option to create the database described in the dump file to restore
the dump file.
The whole command like this:
# /opt/nokiasiemens/SS_Postgres/bin/pg_restore -C -h CFPU-0 -p 5433 -U
On Tue, Jun 4, 2013 at 5:06 PM, ascot.m...@gmail.com
wrote:
> if I change the value of "vacuum_cost_delay", what is the impact of it on
> autovacuum side?
If autovacuum_vacuum_cost_delay is not -1 then autovacuum will use
this value, and there will be no effect of changing vacuum_cost_delay
on
Hi,
if I change the value of "vacuum_cost_delay", what is the impact of it on
autovacuum side?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a VIEW that does not appear to take advantage of the WHERE when
given the opportunity:
db=# explain select * from best_for_sale_layouts;
QUERY PLAN
A
On Tue, Jun 4, 2013 at 6:25 AM, wrote:
>
> Hi all
>
> I have a question about sync streaming replication.
>
> I have 2 postgresql 9.1 servers set up with streaming replication. On the
> master node the slave is configured as a synchronous standby. I've verified
> that pg_stat_replication shows sy
Apologies for not replying sooner. After a few days, we actually found out
the cause was a user turning off all triggers on the table, forcing some
data into it to try and solve an RMA issue manually, then turning the
triggers back on. This hadn't showed up on any logs, and after finding zero
signs
On 04/06/2013 09:44, 任洪彩 wrote:
> Hi, guys
>
> I have met a problem that do confused me.
>
> I created a dump file by pg_dump from database named "DBRNWHSB" with
> parameters -b -o -Fc -Z 0.
> As you know, at the beginning of the dump file contains some SQL
> statements for create the database "
Hi, guys
I have met a problem that do confused me.
I created a dump file by pg_dump from database named "DBRNWHSB" with parameters
-b -o -Fc -Z 0.
As you know, at the beginning of the dump file contains some SQL statements for
create the database "DBRNWHSB".
So here comes the question, I w
On Tue, Jun 4, 2013 at 10:04 PM, Andres Freund wrote:
> On 2013-06-04 11:29:44 +0900, Amit Langote wrote:
>> In what cases can a relation use more buffers (in shared memory) than
>> its pg_class.relpages?
>
> relpages is primarily updated by (auto-)vacuum, (auto-)analyze, so it
> frequently lags b
Hi all
I have a question about sync streaming replication.
I have 2 postgresql 9.1 servers set up with streaming replication. On the
master node the slave is configured as a synchronous standby. I've verified
that pg_stat_replication shows sync_state = sync for the slave node.
It all seems to w
Ah, just create user-defined functions that take the ID as a parameter and
have the user call them, instead of a trigger function, eh? I think I like
that better because I can then have separate update and delete functions,
with descriptive names. I can do that, and I guess I was looking at this
th
On 2013-06-04 11:29:44 +0900, Amit Langote wrote:
> In what cases can a relation use more buffers (in shared memory) than
> its pg_class.relpages?
relpages is primarily updated by (auto-)vacuum, (auto-)analyze, so it
frequently lags behind reality in a growing relation. Why do you need an
exact va
Melvin Call wrote
> But I still have a question in that I'd like to know if I can pass the
> WHERE clause to the function so it can examine the query? Or will I have
> to
> test for the potential of acting on more than one row?
You can write a function that takes a text/varchar and builds a dynami
Hi David, and thanks for the response!
Like you, I think I have already come to the conclusion that to do what I
want (to limit view modifications to a single row) will require a more
detailed function. And my choice of invalid was definitely incorrect.
Thanks for pointing that out. A better term
14 matches
Mail list logo
