| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Call for alpha testing: planner statistics revisions |
| Date: | 2001-06-21 11:38:56 |
| Message-ID: | Pine.LNX.4.33.0106211435590.3949-100000@kissaholmen.cs.Helsinki.FI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Sun, 17 Jun 2001, Tom Lane wrote:
> * On large tables, ANALYZE uses a random sample of rows rather than
> examining every row, so that it should take a reasonably short time
> even on very large tables. Possible downside: inaccurate stats.
> We need to find out if the sample size is large enough.
How about letting the user specify how much of the table should be
examined? So if you know the data is homogenous you can just specify a
smaller sample than normal and if you have time you can have the whole
table scanned.
- Einar Karttunen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zilch | 2001-06-21 11:59:27 | Foreign Keys to Non-primary keys? |
| Previous Message | Gilles DAROLD | 2001-06-21 09:53:09 | Oracle to PostgreSQL Tool |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2001-06-21 12:00:03 | Re: nocreatetable for 7.1.2 |
| Previous Message | Matthew Kirkwood | 2001-06-21 10:01:29 | Re: Backup and Recovery |