Hello.
I have a question about perfomance.
I'm running PostgreSQL 7.1.2 at FreeBSD 4.3.
For the first 1-2 days of running perfomance is excellent. But
after that, speed began to decrease. And after a week of
operation, perfomance falls 8-10 times, th
On Tue, Aug 14, 2001 at 02:06:40PM +0600, Alexander Loginov wrote:
> Hello.
>
>I have a question about perfomance.
>I'm running PostgreSQL 7.1.2 at FreeBSD 4.3.
>
>For the first 1-2 days of running perfomance is excellent. But
>after that, speed began to dec
>> For the first 1-2 days of running perfomance is excellent. But
>> after that, speed began to decrease. And after a week of
>> operation, perfomance falls 8-10 times, than at first day of
>> using.
>>
>> I'm doing vacuum periodically (once a hour), but perfomance
>> still falls d
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> One backend would be blocked by another one because reindex_relation
> calls reindex_index and reindex_index grabs an ExclusiveLock on the
> relation.
> Am I missing anything ?
It'd be okay if you *held* the lock throughout. Grabbing and releasing
it i
Tom Lane wrote:
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > One backend would be blocked by another one because reindex_relation
> > calls reindex_index and reindex_index grabs an ExclusiveLock on the
> > relation.
> > Am I missing anything ?
>
> It'd be okay if you *held* the lock througho
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Where do I release the lock ?
I'd say you shouldn't release it at all. Let it be held until end of
transaction.
rel = heap_open(relid, AccessExclusiveLock);
...
heap_close(rel, NoLock); /* close rel, keep lock till end of xact
Tom Lane wrote:
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Where do I release the lock ?
>
> I'd say you shouldn't release it at all.
As far as I see I'm not releasing it.
regards,
Hiroshi Inoue
---(end of broadcast)---
TIP 4: Don't 'kill
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
>> I'd say you shouldn't release it at all.
> As far as I see I'm not releasing it.
Oh, I hadn't looked closely at reindex_index. Hmm... okay, you are
holding the lock acquired there. But you're still acquiring it way too
late for my taste. All of the
Tom Lane wrote:
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> >> I'd say you shouldn't release it at all.
>
> > As far as I see I'm not releasing it.
>
> Oh, I hadn't looked closely at reindex_index. Hmm... okay, you are
> holding the lock acquired there.
Yes reindex_index is guarding itself
PROTECTED]
> cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
> Subject: Re: [GENERAL] Perfomance decreasing
>
>
> On Tue, Aug 14, 2001 at 02:06:40PM +0600, Alexander Loginov wrote:
> > Hello.
> >
> >I have a question about perfomance.
> >I
rk)
Subject: Re: [GENERAL] Perfomance decreasing
On Tue, Aug 14, 2001 at 02:06:40PM +0600, Alexander Loginov wrote:
> Hello.
>
>I have a question about perfomance.
>I'm running PostgreSQL 7.1.2 at FreeBSD 4.3.
>
>For the first 1-2 days of ru
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
>
> Alexander Loginov <[EMAIL PROTECTED]> writes:
> > I have only one small question. Can I do REINDEX during inserting
> > of information into tables. Or I must block somehow updating of
> > tables.
>
> Hmmm
12 matches
Mail list logo