[ADMIN] Big UPDATE breaking replication

2013-06-04 Thread Kouber Saparev
[28201]: [13-8] ^IWHERE from_profile_sid=870 ... May 30 12:39:47 DB1 postgres[9053]: [2-1] user=postgres,db=[unknown] FATAL: requested WAL segment 000102DE00BD has already been removed Regards, -- Kouber Saparev -- Sent via pgsql-admin mailing list (pgsql-admin

Re: [ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-28 Thread Kouber Saparev
On 08/24/2012 05:47 AM, Bruce Momjian wrote: On Thu, Aug 23, 2012 at 10:59:56AM +0300, Kouber Saparev wrote: Hello, Does resetting of stats through pg_reset_stats() influence the way autovacuum determines whether autovacuum_vacuum_scale_factor and autovacuum_analyze_scale_factor settings

[ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-23 Thread Kouber Saparev
pg_stat_all_tables? -- Kouber Saparev -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Updatable view and default sequence values

2006-05-23 Thread Kouber Saparev
not yet defined error - that's why I used 'others'. Anyway, I'll write here when I find other interesting solutions. Regards, -- Kouber Saparev http://kouber.saparev.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [ADMIN] Updatable view and default sequence values

2006-05-22 Thread Kouber Saparev
Jim C. Nasby wrote: On Tue, May 16, 2006 at 04:16:55PM +0300, Kouber Saparev wrote: The tricky part comes when I try to make my view insertable. Normally I'd insert without specifying the sequence values, but in some cases I'd want also to have full control of what's going into the underlying

[ADMIN] Updatable view and default sequence values

2006-05-17 Thread Kouber Saparev
to suppress multiple invocations of nextval() or how to do it anyway? :) -- Kouber Saparev http://kouber.saparev.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq