Re: parsed queries (cursors) cashing issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sergey Moroz" <smo(at)mgcp(dot)com>
Cc: "Sibte Abbas" <sibtay(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: parsed queries (cursors) cashing issues
Date: 2007-08-06 04:50:50
Message-ID: 10506.1186375850@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Sergey Moroz" <smo(at)mgcp(dot)com> writes:
> So I wonder why doesn't postgres store hashes for all queries and
> misses parsing step if not needed like Oracle does?

Because we think it's a waste of cycles, not to mention storage.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2007-08-06 05:09:40 Dealing with tsvector in fuctions for data split
Previous Message snacktime 2007-08-06 04:43:06 Modeling bill/ship addresses