On 17 November 2014 22:27, Tom Lane wrote:
> Another idea that occurred to me is to run a planning cycle in which the
> actual parameter values are made available to the planner, but as
> estimates not hard constants (this facility already exists, it's just not
> being used by plancache.c). This
7;d probably require a list of accessible remote
>databases per server (so that people cannot just query any database of their
>choice). That could also serve the load-balancing scenario.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see
database on a filesystem that has
reliable integrity verification mechanisms.
In the worst case (all the above mechanisms fail), you have backups.
IMHO the problem is covered quite adequately. The operating system and
the hardware cover for the database, as they should; it's _their_ job.
--
eue finishes before the still
running one? This would achieve some kind of auto-tuning, but that is
usually tricky.
For example, what if one of the queues got stuck on a lock?
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
---(end of broadcast)---
TIP 6: explain analyze is your friend
Tom Lane wrote:
Alban Hertroys <[EMAIL PROTECTED]> writes:
I'm confused too. Would it be possible for you to send me a dump of
your database?
Attached is a cleaned out database, the full schema is included, but
only the relevant tables contain any data.
Thanks. After digging t
