Re: why SSD is slower than HDD SAS 15K ?

Dear Merlin 2018-01-15 11:16 GMT-08:00 Merlin Moncure : > On Mon, Jan 15, 2018 at 7:38 AM, Neto pr wrote: > > Hello all, > > Someone help me analyze the two execution plans below (Explain ANALYZE > > used), is the query 9 of TPC-H benchmark [1]. > > I'm

Re: why SSD is slower than HDD SAS 15K ?

I bet this is a ssd partition alignment problem there are erase block size of 3mb and this should be taken in account, when You partition ssd drive, creating a raid and filesystem etc... -- Původní e-mail -- Od: Merlin Moncure Komu: Neto pr

Insert results in 0 1

Computer HP Compaq 6710b Development Platform: Ubuntu 17.10 mainly command line work Tools: perl 5.26 and postgresql 9.6 Why do I get a 0 1 when using insert? Thanks; Sherman classical=# INSERT INTO string_groups VALUES('et_b_02', 'Sonata in B minor', 'Eroica Trio', 'Jean Baptiste Loeillet',

Re: why SSD is slower than HDD SAS 15K ?

On Mon, Jan 15, 2018 at 7:38 AM, Neto pr wrote: > Hello all, > Someone help me analyze the two execution plans below (Explain ANALYZE > used), is the query 9 of TPC-H benchmark [1]. > I'm using two servers HP Intel Xeon 2.8GHz/4-core - Memory 8GB. O.S. > Debian8, using EXT4

Sv: Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?

På mandag 15. januar 2018 kl. 19:04:51, skrev David G. Johnston < david.g.johns...@gmail.com >: On Sun, Jan 14, 2018 at 5:40 AM, Andreas Joseph Krogh > wrote: På søndag 14. januar 2018 kl. 13:30:29, skrev Francisco

Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?

hi, maybe selecting the relevant fields to order-by alongside (next to) the row()'ed part, they will be selected "twice", but you'll be able to reference them. regards Haroldo 2018-01-14 9:40 GMT-03:00 Andreas Joseph Krogh : > På søndag 14. januar 2018 kl. 13:30:29, skrev

Re: why SSD is slower than HDD SAS 15K ?

2018-01-15 9:13 GMT-08:00 Vick Khera : > Try random page cost 1.1. Way back when I started using SSD we had a > discussion here and came to the conclusion that it should be ever so > slightly higher than sequential page cost. > > Very good tip, I'm running the query with

Re: why SSD is slower than HDD SAS 15K ?

Try random page cost 1.1. Way back when I started using SSD we had a discussion here and came to the conclusion that it should be ever so slightly higher than sequential page cost. It is very hard to read your query plans (maybe gmail is wrapping them funny or you need to use a fixed font on them

Re: pg_basebackup is taking more time than expected

I am looking for the help to minimise the time taken by the pg_basebackup utility. As informed Earlier we are taking the backup of the database using pg_basbackup utility using below command. $PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar --gzip --compress=6 --pgdata=- -D

why SSD is slower than HDD SAS 15K ?

Hello all, Someone help me analyze the two execution plans below (Explain ANALYZE used), is the query 9 of TPC-H benchmark [1]. I'm using two servers HP Intel Xeon 2.8GHz/4-core - Memory 8GB. O.S. Debian8, using EXT4 filesystem. Server 1 - HDD SAS 15 Krpm - 320 GB (Location where O.S. Debian and

Re: String comparison problem in select - too many results

Dear Peter and Francisco! Firstly: sorry for name change. I might read too many about Totti or I was listening too many "Vamos a la playa" spanitaliano disco... :-) :-) :-) To better understand my problem I write about the background. We used different database engine "before" PG, and more