| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Anastasia Lubennikova <lubennikovaav(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Microvacuum for gist. |
| Date: | 2015-07-30 22:07:53 |
| Message-ID: | 55BAA039.1030107@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 7/30/15 7:33 AM, Alexander Korotkov wrote:
> 2) Generating notices for every dead tuple would be too noisy. I suggest
> to replace notice with one of debug levels.
>
> + elog(NOTICE, "gistkillitems. Mark Item Dead offnum %hd, blkno %d",
> offnum, BufferGetBlockNumber(buffer));
Even that seems like pretty serious overkill. vacuumlazy.c doesn't have
anything like that, and I don't think the BTree code does either. If you
were debugging something and actually needed it I'd say drop in a
temporary printf().
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-07-30 22:18:18 | Re: Proposal: backend "niceness" / session_priority |
| Previous Message | Jim Nasby | 2015-07-30 21:55:57 | Re: Updatable view? |