On Thu, Mar 29, 2012 at 4:57 PM, Tom Lane wrote:
>> It's also probably worth keeping in mind the next time we
>> bump the protocol version: it would be nice to have a way of doing
>> prepare-bind-execute in a single protocol message, which I believe to
>> be not possible at present.
>
> Huh? That
Robert Haas writes:
> Interestingly, Peter Geoghegan's blog post on the pg_stat_statements
> patch you just committed[1] claims that the overhead of fingerprinting
> queries was only 1-2.5%, which is less than I would have thought, so
> if we ever get to the point where we're fairly sure we've got
On Fri, Mar 23, 2012 at 2:54 PM, Tom Lane wrote:
> Robert Haas writes:
>> What I think is more common is the repeated submission of queries that
>> are *nearly* identical, but with either different parameter bindings
>> or different constants. It would be nice to have some kind of cache
>> that
Thanks.. I'll keep those issues in mind.
On Sat, Mar 24, 2012 at 6:18 PM, Tatsuo Ishii wrote:
> >> Well, you'd have to start by demonstrating the benefit of it. The
> >> advantage of query caches in proxies and clients is well-known, because
> you
> >> can offload some of the work of the datab
>> Well, you'd have to start by demonstrating the benefit of it. The
>> advantage of query caches in proxies and clients is well-known, because you
>> can offload some of the work of the database onto other servers, this
>> increasing capacity. Adding a query cache to the database server would
>>
On Sat, Mar 24, 2012 at 3:22 PM, Joshua Berkus wrote:
> Billy,
>
> > I've done a brief search of the postgresql mail archives, and I've
> > noticed a few projects for adding query caches to postgresql, (for
> > example, Masanori Yamazaki's query cache proposal for GSOC 2011),
>
> ... which was co
Joshua Berkus writes:
> If you want to do something radical and new, then come up with a way
> for a client to request and then reuse a complete query plan by
> passing it to the server.
[ raised eyebrow ] That seems like a complete nonstarter on two
different grounds: cache invalidation needs (
Billy,
> I've done a brief search of the postgresql mail archives, and I've
> noticed a few projects for adding query caches to postgresql, (for
> example, Masanori Yamazaki's query cache proposal for GSOC 2011),
... which was completed, btw. Take a look at the current release of pgPool.
Are yo
On Fri, Mar 23, 2012 at 1:51 PM, Greg Stark wrote:
> Well it's not entirely unlikely. If you step back a web application
> looks like a big loop with a switch statement to go to different
> pages. It keeps executing the same loop over and over again and there
> are only a smallish number of web pa
Robert Haas writes:
> What I think is more common is the repeated submission of queries that
> are *nearly* identical, but with either different parameter bindings
> or different constants. It would be nice to have some kind of cache
> that would allow us to avoid the overhead of parsing and plan
On Fri, Mar 23, 2012 at 12:03 PM, Robert Haas wrote:
> On Fri, Mar 23, 2012 at 12:29 PM, Greg Stark wrote:
>> On Fri, Mar 23, 2012 at 3:49 PM, Tom Lane wrote:
>>> The complication, opportunities for bugs, and general slowdown
>>> associated with that would outweigh any possible gain, in the opin
On Fri, Mar 23, 2012 at 5:03 PM, Robert Haas wrote:
> The other thing that makes me skeptical of this proposal is that I am
> not very sure that executing absolutely identical queries is a very
> common use case for a relational database. I suppose there might be a
> few queries that run over and
On Fri, Mar 23, 2012 at 12:29 PM, Greg Stark wrote:
> On Fri, Mar 23, 2012 at 3:49 PM, Tom Lane wrote:
>> The complication, opportunities for bugs, and general slowdown
>> associated with that would outweigh any possible gain, in the opinion
>> of most hackers who have thought about this.
>
> I w
On Fri, Mar 23, 2012 at 11:29 AM, Greg Stark wrote:
> On Fri, Mar 23, 2012 at 3:49 PM, Tom Lane wrote:
> > The complication, opportunities for bugs, and general slowdown
> > associated with that would outweigh any possible gain, in the opinion
> > of most hackers who have thought about this.
>
>
On Fri, Mar 23, 2012 at 3:49 PM, Tom Lane wrote:
> The complication, opportunities for bugs, and general slowdown
> associated with that would outweigh any possible gain, in the opinion
> of most hackers who have thought about this.
I wouldn't be quite so pessimistic. I think the problem is that
Billy Earney writes:
> I'm wondering if anyone would be interested in a query cache as a backend
> to postgresql?
I believe this has been suggested and rejected several times before.
Did you look through the pgsql-hackers archives?
> To invalidate cache entries, look at the transactions being co
Greetings!
I've done a brief search of the postgresql mail archives, and I've noticed
a few projects for adding query caches to postgresql, (for example,
Masanori Yamazaki's query cache proposal for GSOC 2011), as well as the
query cache announced at http://www.postgresql.org/about/news/1296/
(pg
On Tue, 31 Oct 2000, Alfred Perlstein wrote:
> * Karel Zak <[EMAIL PROTECTED]> [001031 16:18] wrote:
> >
> > On Tue, 31 Oct 2000, Alfred Perlstein wrote:
> >
> > All what will doing next time not depend on me, *it's on code developers*.
* Karel Zak <[EMAIL PROTECTED]> [001031 16:18] wrote:
>
> On Tue, 31 Oct 2000, Alfred Perlstein wrote:
>
> > I never saw much traffic regarding Karel's work on making stored
> > proceedures:
> >
> > http://people.freebsd.org/~alfred/karel-pgsql.txt
> >
> > What happened with this? It looked pr
> My query cache is in usable state and it's efficient for all things
> those motivate me to work on this.
Well, you know, us application developers are lazy egoists, we want all of
that without efforts on our side :) In fact, customers do that. They don't
want to pay for both implementin
On Tue, 31 Oct 2000, Alfred Perlstein wrote:
> I never saw much traffic regarding Karel's work on making stored
> proceedures:
>
> http://people.freebsd.org/~alfred/karel-pgsql.txt
>
> What happened with this? It looked pretty interesting. :(
It's probably a little about me :-) ... well,
I never saw much traffic regarding Karel's work on making stored
proceedures:
http://people.freebsd.org/~alfred/karel-pgsql.txt
What happened with this? It looked pretty interesting. :(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a j
22 matches
Mail list logo
