VITESSEDATA.COM

vitesse-timing-on.blogspot.com

\timing on: Running TPCH on PostgreSQL (Part 1)

http://vitesse-timing-on.blogspot.com/2014/10/running-tpch-on-postgresql-part-1.html

Friday, October 17, 2014. Running TPCH on PostgreSQL (Part 1). We have just release our 9.3.5.S for public beta test. Together with the product, we released a benchmark based on TPCH. The modification to data types is easy to understand - money and double types are faster than Numeric (and no one on this planet has a bank account that overflows the money type, not any time soon). The modifications to queries are more interesting. Now let's look at them,. Q2: The skeleton of Q2 look like. Simple template&...

vitesse-timing-on.blogspot.com

\timing on: TPCH on PostgreSQL (part 3)

http://vitesse-timing-on.blogspot.com/2014/11/tpch-on-postgresql-part-3.html

Monday, November 10, 2014. TPCH on PostgreSQL (part 3). Today is the biggest internet shopping day. If you read Chinese, you may find that Alibaba posts job openings for PostgreSQL dba from time to time. It would be interesting to find out how many transactions and/or analytic workloads inside Alibaba is handled by PostgreSQL. Back to TPCH. Q16 is particularly tough for us to optimize. Again, it is better to look at a simpler example,. Time: 784.034 ms. Time: 7991.994 ms. Time: 99.029 ms. Sort Key: s, j.

vitesse-timing-on.blogspot.com

\timing on: Julia, Postgres on Mac

http://vitesse-timing-on.blogspot.com/2015/02/julia-postgres-on-mac.html

Tuesday, February 3, 2015. Julia, Postgres on Mac. PostgreSQL to a test drive on my macbook. It worked like charm. First, the Juno IDE is quite nice. Download, drag, drop, open, runs! Connection to Postgres via libpq is not very usable at this moment, so I went the odbc route. I used port, to install psqlODBC and unixODBC. Configure DNS at /.odbc.ini. Fengs-MBP:pg ftian$ cat /.odbc.ini. Driver = /opt/local/lib/psqlodbcw.so. Tested with isql, DNS works. Nice. Set search path=csvfdw;. L SHIPDATE DATE NOT N...

vitesse-timing-on.blogspot.com

\timing on: TPCH on PostgreSQL (Part 2)

http://vitesse-timing-on.blogspot.com/2014/11/tpch-on-postgresql-part-2.html

Tuesday, November 4, 2014. TPCH on PostgreSQL (Part 2). CTE is a great feature. Let's look at the following simple example,. Create table t as select i, i 1 as j from generate series(1, 10000000) i;. Create index ti on t(i);. Ftian=# explain select * from t where i = 10 and j = 100;. Bitmap Heap Scan on t (cost=927.50.48029.26 rows=250 width=8). Recheck Cond: (i = 10). Filter: (j = 100). Bitmap Index Scan on ti (cost=0.00.927.43 rows=50000 width=0). Index Cond: (i = 10). Filter: (i = 10). TPCH on Postgre...

vitesse-timing-on.blogspot.com

\timing on: May 2015

http://vitesse-timing-on.blogspot.com/2015_05_01_archive.html

Thursday, May 21, 2015. Say you have carefully tuned your database and wow! It is ten times faster - but, before you push it to the production cluster, how do you know the answer of the query is correct? Or at least, same as before? You may have same question if you want to upgrade or migrate your database, or, for us, we want to make sure the new great join algorithm actually produce correct answer. Well, let's just put the result before, and after, in two tables, and compare the two tables. From tb gro...

vitesse-timing-on.blogspot.com

\timing on: November 2014

http://vitesse-timing-on.blogspot.com/2014_11_01_archive.html

Monday, November 10, 2014. TPCH on PostgreSQL (part 3). Today is the biggest internet shopping day. If you read Chinese, you may find that Alibaba posts job openings for PostgreSQL dba from time to time. It would be interesting to find out how many transactions and/or analytic workloads inside Alibaba is handled by PostgreSQL. Back to TPCH. Q16 is particularly tough for us to optimize. Again, it is better to look at a simpler example,. Time: 784.034 ms. Time: 7991.994 ms. Time: 99.029 ms. Sort Key: s, j.

vitesse-timing-on.blogspot.com

\timing on: February 2015

http://vitesse-timing-on.blogspot.com/2015_02_01_archive.html

Tuesday, February 3, 2015. Julia, Postgres on Mac. PostgreSQL to a test drive on my macbook. It worked like charm. First, the Juno IDE is quite nice. Download, drag, drop, open, runs! Connection to Postgres via libpq is not very usable at this moment, so I went the odbc route. I used port, to install psqlODBC and unixODBC. Configure DNS at /.odbc.ini. Fengs-MBP:pg ftian$ cat /.odbc.ini. Driver = /opt/local/lib/psqlodbcw.so. Tested with isql, DNS works. Nice. Set search path=csvfdw;. L SHIPDATE DATE NOT N...

vitesse-timing-on.blogspot.com

\timing on: October 2014

http://vitesse-timing-on.blogspot.com/2014_10_01_archive.html

Friday, October 17, 2014. Running TPCH on PostgreSQL (Part 1). We have just release our 9.3.5.S for public beta test. Together with the product, we released a benchmark based on TPCH. The modification to data types is easy to understand - money and double types are faster than Numeric (and no one on this planet has a bank account that overflows the money type, not any time soon). The modifications to queries are more interesting. Now let's look at them,. Q2: The skeleton of Q2 look like. Simple template&...

pgconf.us

PostgreSQL Conference United States | PGConf US 2015 | New York | Sponsor

http://www.pgconf.us/2015/sponsor

PGConf US 2015 is a past conference. For the latest conference, please click here. Click Here to View Our Full Sponsorship Prospectus. New Yorkers like to think that NYC is the center of the world - with direct flights from almost every major hub in the world, it is not far from the truth. But what makes New York special, other than being an airline hub, is its unique blend of enterprise, culture, growth, and adaptability, with people who want to get together and build big things. PGConf US 2015 is hoste...