| From: | Stuart Brooks <stuartb(at)cat(dot)co(dot)za> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong |
| Date: | 2008-04-01 13:00:31 |
| Message-ID: | 47F231EF.6040006@cat.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
>> Please do --- I have a lot of other stuff on my plate.
>>
>>
>
> Please see the attached patch. One change I made is to hold the SHARE lock
> on the page while ANALYZE is reading tuples from it. I thought it would
> be a right thing to do instead of repeatedly acquiring/releasing the lock.
>
I have applied the patch and have started my test again, it takes a
little while to fill up so I should have the results sometime tomorrow.
Thanks for the quick response.
Stuart
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-04-01 13:00:41 | Re: HOWTO caching data across function calls: temporary tables, cursor? |
| Previous Message | mark | 2008-04-01 12:59:41 | Re: simple update queries take a long time - postgres 8.3.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toru SHIMOGAKI | 2008-04-01 13:17:11 | Re: build multiple indexes in single table pass? |
| Previous Message | Aidan Van Dyk | 2008-04-01 12:49:54 | Re: build multiple indexes in single table pass? |