| 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 18:39:57 |
| Message-ID: | 19585.1041964797@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:
> My case persists:
> After clean install of the database, and after vacuum analyze,
> i get
Um ... is it persisting? That looks like it's correctly picked the
vcode index this time. Strange behavior though. By "clean install"
do you mean you rebuilt Postgres, or just did dropdb/createdb/reload
data?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-01-07 18:45:14 | Re: [SQL] 7.3.1 index use / performance |
| Previous Message | Joe Conway | 2003-01-07 18:39:19 | Re: 7.3.1 function problem: ERROR: cache lookup failed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-01-07 18:45:14 | Re: [SQL] 7.3.1 index use / performance |
| Previous Message | Joe Conway | 2003-01-07 18:39:19 | Re: 7.3.1 function problem: ERROR: cache lookup failed |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2003-01-07 18:41:49 | Re: A problem about alter table |
| Previous Message | Joe Conway | 2003-01-07 18:39:19 | Re: 7.3.1 function problem: ERROR: cache lookup failed |