From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Chris Faulkner <chrisf(at)oramap(dot)com>, Pgsql-Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: sql performance and cache |
Date: | 2003-10-11 10:16:35 |
Message-ID: | 3F87D883.2000206@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance pgsql-sql |
> PostgreSQL does not have, and has never had a query cache - so nothing
> you do is going to make that second query faster.
Let me clarify that. PostgreSQL will of course cache the disk pages
used in getting the data for your query, which is why the second time
you run it, it is 3 seconds faster.
However, it does not cache the _results_ of the query. Each time you
run it, it will be fully re-evaluated.
The btree error you give is bad and I'm sure the more experienced list
members will want you to dig into it for them.
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2003-10-11 10:22:42 | Re: go for a script! / ex: PostgreSQL vs. MySQL |
Previous Message | Christopher Kings-Lynne | 2003-10-11 10:11:48 | Re: sql performance and cache |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-10-11 10:39:10 | Re: [SQL] sql performance and cache |
Previous Message | Christopher Kings-Lynne | 2003-10-11 10:11:48 | Re: sql performance and cache |