| From: | Jeff Amiel <jamiel(at)istreamimaging(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce McAlister <bruce(dot)mcalister(at)blueface(dot)ie>, General <pgsql-general(at)postgresql(dot)org>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: AutoVacuum Behaviour Question |
| Date: | 2007-11-01 14:01:55 |
| Message-ID: | 4729DC53.50107@istreamimaging.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Bruce Momjian wrote:
>>
>> No, it isn't. Please add a TODO item about it:
>> * Prevent long-lived temp tables from causing frozen-Xid advancement
>> starvation
>>
>
>
>
Can somebody explain this one to me? because of our auditing technique,
we have many LONG lived temp tables.....(one per pooled connection)...so
as long as the pool isn't disturbed, these temp tables can exist for a
long time (weeks....months?)
(previous thread about our use of temp tables and autovacuum/xid issues)
http://archives.postgresql.org/pgsql-general/2007-01/msg00690.php
http://archives.postgresql.org/pgsql-general/2007-01/msg00691.php
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mayuresh Nirhali | 2007-11-01 14:50:50 | anybody attending FOSS.in 2007 ?? |
| Previous Message | novice | 2007-11-01 13:28:16 | posgresql-8.2 startup problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2007-11-01 14:41:51 | krb_match_realm patch |
| Previous Message | Gregory Stark | 2007-11-01 13:02:58 | Re: Postgresql 8.3 beta crash |