Maybe you will find time to benchamark xfs vs ext4 (with and without
journaling enabled on ext4).
Nice comparison also could be rhel 6.5 with its newest kernel 2.6.32-X vs
RHEL 7.0 and kernel 3.10.
I was looking for some guidance what to choose and there is very poor
information about such things
This question was posted originally on
http://dba.stackexchange.com/questions/96444/cant-get-dell-pe-t420-perc-h710-perform-better-than-a-macmini-with-postgresql
and they suggested to post it on this mailing list.
It's months that I'm trying to solve a performance issue with PostgreSQL. I’m
abl
Hi Pietro,
On Wed, Apr 1, 2015 at 3:56 PM, Pietro Pugni wrote:
> T420: went from 311seconds (default postgresql.conf) to 195seconds doing
> tuning adjustments over RAID, kernel and postgresql.conf;
> MacMini: 40seconds.
I'am afraid, the matter is, that PostgreSQL is not configured properly
(and
On Wed, Apr 1, 2015 at 9:56 AM, Pietro Pugni wrote:
> *Now let’s propose some query profiling times.*
>
> B type set are transactions, so it's impossible for me to post EXPLAIN
> ANALYZE results. I've extracted two querys from a single transactions and
> executed the twos on both system. Here ar
Just looking at the 2 B_2 queries, I'm curious as to why is the execution
plan different between the 2 machines. Is the optimiser stats updated on
both databases?
Regards,
Wei Shan
On 1 April 2015 at 22:32, Aidan Van Dyk wrote:
> On Wed, Apr 1, 2015 at 9:56 AM, Pietro Pugni
> wrote:
>
>
>> *No
On Wed, Apr 1, 2015 at 6:56 AM, Pietro Pugni wrote:
> This question was posted originally on
> http://dba.stackexchange.com/questions/96444/cant-get-dell-pe-t420-perc-h710-perform-better-than-a-macmini-with-postgresql
> and they suggested to post it on this mailing list.
>
> It's months that I'm
Ok, a quick view on the system, and some things that may be important to note:
> Our deployment machine is a Dell PowerEdge T420 with a Perc H710 RAID
> controller configured in this way:
>
> * VD0: two 15k SAS disks (ext4, OS partition, WAL partition,
> RAID1)
> * VD1: ten 10k SAS di
-- tables
-- New column "span" added and new index created on both tables.
CREATE TABLE customer(
uid bigserial PRIMARY KEY,
name character varying(50) NOT NULL,
start_time timestamp without time zone,
end_time timestamp without time zone,
span tsrange,
comment text,
cre
