[GENERAL] Perfomance decreasing

2001-08-14 Thread Alexander Loginov
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

Re: [GENERAL] Perfomance decreasing

2001-08-14 Thread Erwin Lansing
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

Re: [GENERAL] Perfomance decreasing

2001-08-14 Thread Tom Lane
>> 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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Tom Lane
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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Hiroshi Inoue
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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Tom Lane
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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Hiroshi Inoue
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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Tom Lane
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

Re: [GENERAL] Perfomance decreasing

2001-08-16 Thread Hiroshi Inoue
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

Re: [GENERAL] Perfomance decreasing

2001-08-20 Thread Erwin Lansing
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

Re: [GENERAL] Perfomance decreasing

2001-08-20 Thread wsheldah
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

RE: Re[2]: [GENERAL] Perfomance decreasing

2001-08-16 Thread Hiroshi Inoue
> -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