I wrote:
--- snip ---
So - does anybody with enough insight in the planner know if it sounds
likely that it would choose the given plans in these two cases, or if
it's more likely that I have a tuning problem that leads to bad
planning?
Duh. It suddenly dawned on me that I need to look
Hi all,
I have a number of Postgres 9.2.4 databases with the same schema but with
slightly different contents, running on small servers that are basically
alike (8-16 GB ram).
When I run the same query on these databases it results in one of two
different execution plans where one is much faster
On Wed, Sep 11, 2013 at 4:16 AM, Mikkel Lauritsen ren...@tala.dk wrote:
Hi all,
I have a number of Postgres 9.2.4 databases with the same schema but with
slightly different contents, running on small servers that are basically
alike (8-16 GB ram).
When I run the same query on these
Il 11/09/2013 13:16, Mikkel Lauritsen ha scritto:
Hi all,
I have a number of Postgres 9.2.4 databases with the same schema but with
slightly different contents, running on small servers that are basically
alike (8-16 GB ram).
I think that your answer can be found in your statement slightly
Hi all,
On Wed, 11 Sep 2013 18:55:38 +0200, Giuseppe Broccolo
giuseppe.brocc...@2ndquadrant.it wrote:
Il 11/09/2013 13:16, Mikkel Lauritsen ha scritto:
Hi all,
I have a number of Postgres 9.2.4 databases with the same schema but
with slightly different contents, running on small servers
On 12/09/13 04:55, Giuseppe Broccolo wrote:
Il 11/09/2013 13:16, Mikkel Lauritsen ha scritto:
Hi all,
I have a number of Postgres 9.2.4 databases with the same schema but
with
slightly different contents, running on small servers that are basically
alike (8-16 GB ram).
I think that your