-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 3:42 PM To: Peter Bierman Cc: Dann Corbit; [EMAIL PROTECTED] Subject: Re: [HACKERS] Suggestion for optimization
Peter Bierman <[EMAIL PROTECTED]> writes: > ... Your comment: "An > accurate cardinality figure can greatly enhance the optimizer's > ability to perform joins in the correct order" was intriguing, and I'd > be interested in Tom's thoughts on just that bit. Approximate figures are quite sufficient for the planner's purposes. AFAICS, making them exact would not improve the planning estimates at all, because there are too many other sources of error. We have approximate stats already via vacuum/analyze statistics gathering. >> What happens if someone deletes 75% of a table? What happens if someone imports 30 times more rows than are already in the table? What happens if one table is remarkably small or even empty and you are unaware? In extreme cases, it can mean orders of magnitude performance difference. << ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
