Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> Probably I found the problem. After running my test, whiich became
> very slow I looked at /usr/local/pgsql/data/base/discovery
> -rw------- 1 postgres users 5070848 Jul 27 16:14 hits
> -rw------- 1 postgres users 1409024 Jul 27 16:14 hits_pkey
> This is for table with one row after a lot of updates.
> Too much. vacuum analyze this table was a good medicine !
If the table contains only one row, why are you bothering with an
index on it?
> Is this a design problem ?
Only that space in tables and indexes can't be re-used until vacuum.
I'm not sure if there's any good way around that or not...
regards, tom lane
pgsql-hackers by date
|Next:||From: Thomas Lockhart||Date: 1999-07-27 14:47:34|
|Subject: i386 RPMs available for v6.5.1|
|Previous:||From: Thomas Lockhart||Date: 1999-07-27 14:39:31|
|Subject: Re: [PORTS] RedHat6.0 & Alpha|