Are the plans cached per connection? Why not globally?
Thanks
Peter
On 1/18/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Scott Ribe <[EMAIL PROTECTED]> writes:
> Is there a way to force a flush of all cached plans?
Start a fresh connection.
regards, tom lane
--
About three years ago I did a test to compare the performance of an
Apache-PHP-PostgreSQL web application on Linux vs. FreeBSD. I used the
same machine with the then current versions of the said software. The
results were better by 30-35% on FreeBSD. Since then I have been having
the sneaking f
I use the QuantumDB plugin.(http://quantum.sourceforge.net/) Provides a
basic access to DBs with JDBC. It did not work with older PostgreSQL
versions, but seems to work well with 8.1.
P.
Keith Hutchison wrote:
Any views on the best way to access postgresql within java?
--
Sorry for the naive question, but: is there a problem with analyze doing
full table scans? Analyze will not lock anything, will it?
Peter
Greg Stark wrote:
Tom Lane <[EMAIL PROTECTED]> writes:
"Ed L." <[EMAIL PROTECTED]> writes:
So, does this sound like we just happened to get repeat
Tom Lane wrote:
Aside from the suggestion already made that the inserting transaction
got rolled back instead of committed, I'd wonder about indirect
deletions due to ON DELETE CASCADE foreign keys, or deletions executed
by PL-language functions. Neither of those would produce obvious log
entrie
