Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Multicolumn Primary Key
- From: "Matthew T. O'Connor" <matthew@zeut.net>
- To: "Thomas F.O'Connell" <tfo@sitening.com>
- Cc: Martijn van Oosterhout <kleptog@svana.org>, pgsql-general@postgresql.org
- Subject: Re: Multicolumn Primary Key
- Date: Tue, 31 Aug 2004 18:49:52 -0400
- Message-id: <41350090.8020609@zeut.net>
Thomas F.O'Connell wrote:
On Aug 31, 2004, at 4:34 PM, Martijn van Oosterhout wrote:Otherwise, have you VACUUM ANALYZEd recently?Argh! That seems to have been it. I have pg_autovacuum running, so it didn't occur to me.
pg_autovacuum only knows about table activity that has taken place while it's running. Example: Table A has an analyze threshold of 1000, if you perform 999 updates on table A, then kill and restart pg_autovacuum, you will have to perform another 1000 updates before pg_autovacuum performs an ANALYZE. This is a large limitation of the current implementation.
I tried to fix this for 8.0, but my autovacuum improvements didn't make the cut.
Matthew
- Follow-Ups:
- Re: Multicolumn Primary Key
- From: Steve Crawford
- Re: Multicolumn Primary Key
- References:
- Multicolumn Primary Key
- From: Thomas F . O'Connell
- Re: Multicolumn Primary Key
- From: Martijn van Oosterhout
- Re: Multicolumn Primary Key
- From: Thomas F . O'Connell
- Multicolumn Primary Key
- Prev by Date: Re: [OT?] Problems with majordomo :-)
- Next by Date: Re: expected both swapped tables to have TOAST tables
- Previous by thread: Re: Multicolumn Primary Key
- Next by thread: Re: Multicolumn Primary Key
- Indexes: