Hello Mike,
what kind of load does the slave get?
what does the recovery process do on the slave during the times when lag is
being observed? Does it use 100% of the CPU?
WAL can be replayed by only one process, so no need to increase the
max_wal_senders.
Cheers,
-- Valentine Gogichashvili
On Sun, Oct 7, 2012 at 3:49 PM, wrote:
> Hello!
>
> I would like to ask following question:
> I have created a table and I updated all records.
> And I executed this update command again and again
> Execution time was growing after each step.
> I cannot understand this behavior.
> First updat
s directly on the bitmap fields. But this is to be implemented by GIN
and GiST index development team. Probably would be not a bad idea to make a
feature request on them.
With best regards,
Valentine Gogichashvili
On 9/13/07, W.Alphonse HAROUNY <[EMAIL PROTECTED]> wrote:
>
> Hello,
On 7/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
valgog <[EMAIL PROTECTED]> wrote ..
> On Jul 23, 7:00 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> > valgog <[EMAIL PROTECTED]> writes:
> > > how to build an multicolumn index with one column order ASCENDING
and
> > > another column order DES
07, Tom Lane <[EMAIL PROTECTED]> wrote:
[cc'ing to pgsql-hackers since this is looking like a contrib/intarray
bug]
"Valentine Gogichashvili" <[EMAIL PROTECTED]> writes:
> here is the DT
That works fine for me in 8.2:
regression=# explain SELECT id, (myintarray_i
-> Bitmap Index Scan on idx_nonnulls_myintarray_int4_text_gin (cost=
0.00..9.87 rows=746 width=0) (actual time=13.982..13.982 rows=28207 loops=1)
Index Cond: ('{8}'::text[] <@ myintarray_int4_text)
Total runtime: 303.348 ms
(5 rows)
I hope this information will make
to the question is: no there in only GIN index on the table.
Thank you in advance,
Valentine
On 5/9/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
Do you have both indexes (GiST, GIN) on the same table ?
On Wed, 9 May 2007, Valentine Gogichashvili wrote:
> Hello all,
>
> I am tryi
et to off in the configuration.
With best regards,
-- Valentine Gogichashvili
