RE: Having query cache in core - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Having query cache in core
Date
Msg-id 0A3221C70F24FB45833433255569204D1F96E08F@G01JPEXMBYT05
Whole thread Raw
In response to Re: Having query cache in core  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
From: Robert Haas [mailto:robertmhaas@gmail.com]
> That's not my experience.  I agree that plan caching isn't important
> for long-running queries, but I think it *is* potentially important
> for fast queries with fast planning time.  Even when the planning time
> is fast, it can be a significant percentage of the execution time.
> Not long ago, we had a case at EDB where a customer was getting custom
> plans instead of generic plans and that resulted in a significant
> reduction in TPS.

I have the same experience with our customers.  Their batch applications suffered from performance compared to Oracle
andSQL Server.  Those apps repeatedly issued simple SELECT statements that retrieve a single row.
 

Regards
Takayuki Tsunakawa



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [HACKERS] path toward faster partition pruning
Next
From: David Rowley
Date:
Subject: Re: Should we add GUCs to allow partition pruning to be disabled?