| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Subject: bool / vacuum full bug followup |
| Date: | 2002-05-03 08:41:51 |
| Message-ID: | Pine.LNX.4.44.0205031040250.20585-100000@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2 May 2002, Scott Marlowe wrote:
> And after that, the table started growing after all vacuum fulls. I can't
> reproduce it now. I blew away the table, recreated it, and now it doesn't
> do that. I blew away the database, and installed 7.2.1 and it won't do
> it. I reinstalled 7.2 and blew away the database and it still won't do
> it.
>
> So, I don't know why it WAS doing it, but it isn't now. And of course,
> it's my personal workstation, so no log files. :-( I'll see if I can
> reproduce this though, as I've seen similar problems pop up once in the
> past with a seldom vacuumed database that reached a point where it stopped
> freeing dead tuples. Very bothersome.
Looks like something that happens only if counters or OIDs are big.
Possible integer overflow in the vacuum code?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pilsl | 2002-05-03 10:01:55 | ftp-server that auths against psql-table ? |
| Previous Message | Alejandro Fernandez | 2002-05-03 07:51:34 | Re: making a trigger to a system call to a shell script |