Search Postgresql Archives

Re: PostgreSQL 8.4.8 bringing my website down every evening

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dne 25.6.2011 02:15, John R Pierce napsal(a):
> indeed, this can really bite you on partitioned tables.    My lead
> Oracle programmer would like to see support for prepared statements that
> are parsed but not preplanned...  our standard coding model has all the
> queries prepared up front as part of process initialization, and queries
> executed against these prepared statements.

AFAIK Oracle does a plan recheck, i.e. verifies that the prepared plan
is reasonable.

The most serious issue with inheritance and plans (prepared statement
did not reflect partitions created afterwards) has already been fixed.

Tomas

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux