On 10/12/14 21:30, Strahinja Kustudić wrote:
On Wed, Dec 10, 2014 at 4:55 AM, Mark Kirkwood <
mark.kirkw...@catalyst.net.nz> wrote:
That is interesting: I've done some testing on this type of card with 16
(slightly faster Hitachi) SSD attached. Setting WT and NORA should enable
the so-called 'f
On Wed, Dec 10, 2014 at 2:44 AM, Maila Fatticcioni
wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello.
> I need to tune a postgres installation I've just made to get a better
> performance. I use two identical servers with a hot replication
> configuration. The two servers have the
On Tue, Dec 9, 2014 at 12:43 PM, Bruce Momjian wrote:
> On Mon, Dec 8, 2014 at 03:40:43PM -0600, Merlin Moncure wrote:
> > >> Did not see consistent measurable gains > 256
> > >> effective_io_concurrency. Interesting that at setting of '2' (the
> > >> lowest possible setting with the feature ac
"Sven R. Kunze" writes:
> Perfect Plan ###
> We assume all our queries to be equivalent and therefore want PostgreSQL
> to re-plan the others to this one.
> explain analyze verbose select * from a where a.id in (select a.id from
> a inner join text_b b1 on (a.id=b1.
Hi everybody,
Denis from SO (see his latest comment) advised me to post my question
here:
http://stackoverflow.com/questions/27363263/when-does-postgresql-collapse-subqueries-to-joins-and-when-not
Please also read all the comments as they contain valuable data as well.
What we actually have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello.
I need to tune a postgres installation I've just made to get a better
performance. I use two identical servers with a hot replication
configuration. The two servers have the following hardware:
Dual Processor Intel Xeon E5-2640V2 20Mb cache 2.0
On Wed, Dec 10, 2014 at 4:55 AM, Mark Kirkwood <
mark.kirkw...@catalyst.net.nz> wrote:
> That is interesting: I've done some testing on this type of card with 16
> (slightly faster Hitachi) SSD attached. Setting WT and NORA should enable
> the so-called 'fastpath' mode for the card [1]. We saw per
