From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | pg_autovacuum fixes |
Date: | 2004-05-22 07:47:56 |
Message-ID: | 1085212076.4205.44.camel@zedora2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
This weekend I am trying to fix up all known the pg_autovacuum issues
that should be resolved for 7.4.3. I am aware of only two issues: temp
table issues, and unchecked send_query() calls, if I am forgetting
something, please let me know.
1) temp table issue:
I was not able to reproduce the crash associated with temp tables. I
spent a while creating tables doing updates and dropping them trying
without success to get pg_autovacuum to crash. Since I couldn't trigger
the problem, I will need someone else to test to see if I have fixed the
problem. Anyway, I have modified the query to exclude temp tables from
the list of tables to work with. So we should no longer be dealing with
temp tables at all which should side step any temp table related problem
we might have been having.
2) Unchecked send_query() function calls:
As best as I can tell, this is mostly a non-issue, but I went ahead
added a check to any section that did anything with the result of
send_query, so if this was an issue, it should be fixed now. BTW, this
might have been the cause of the temp table related crash, but that is
just a guess.
Matthew O'Connor
Attachment | Content-Type | Size |
---|---|---|
pg_autovacuum_temp_table_fix_20040521.patch | text/x-patch | 17.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-05-22 07:52:44 | Re: Database variables when copying a database |
Previous Message | Greg Stark | 2004-05-22 06:04:29 | Re: Delaying the planning of unnamed statements until Bind |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2004-05-22 07:59:50 | Re: Cancel/Kill backend functions |
Previous Message | Neil Conway | 2004-05-22 02:31:15 | Re: tuning for AIX 5L with large memory |