-- 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
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
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
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 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
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
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
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