| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] [PERFORM] 7.3.1 index use / performance |
| Date: | 2003-01-07 16:29:48 |
| Message-ID: | 13843.1041956988@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance pgsql-sql |
Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> About the stats on these 3 columns i get:
Does 7.2 generate the same stats? (minus the schemaname of course)
Also, I would like to see the results of these queries on both versions,
so that we can see what the planner thinks the index selectivity is:
EXPLAIN ANALYZE select * from noon where
v_code='4500';
EXPLAIN ANALYZE select * from noon where
report_date between '2002-01-07' and '2003-01-07';
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-01-07 16:55:30 | Re: PostgreSQL and memory usage |
| Previous Message | Achilleus Mantzios | 2003-01-07 16:21:19 | Re: [SQL] 7.3.1 index use / performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-01-07 16:55:30 | Re: PostgreSQL and memory usage |
| Previous Message | Achilleus Mantzios | 2003-01-07 16:21:19 | Re: [SQL] 7.3.1 index use / performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-07 16:34:11 | Re: weighting (the results of) a query ? |
| Previous Message | Peter Galbavy | 2003-01-07 16:25:43 | Re: weighting (the results of) a query ? |