Mark W the SQL Geek

Opinions, experiences and information about SQL and the databases that process the language, from a guy who's been at it for over 20 years.

Thursday, March 19, 2015

Parallel Sequential Scan for PostgreSQL 9.5

Parallel Sequential Scan for PostgreSQL 9.5

Yes please!

on March 19, 2015
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: parallel, postgresql

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Playing SQL Mythbuster - or - I really ought to lay off the SQL on social media
    Often, when I visit SQL-related forums and social media, I encounter posts that are half-truths, overgeneralizations, and sometimes, outrigh...
  • Pgpool-II Load Balancing
    NOTE: this post is surely hopelessly out of date. It is from 2011! I say this because the post is still getting views well over a decade lat...
  • What have Oracle Materialized Views got that PostgreSQL ones don't?
    This comes up once in a while. Just because DBMS x has a Feature ABC, doesn't mean it's the same as Feature ABC on DBMS y. Below is ...
  • Common Table Expressions: Postgres vs. Oracle vs. MySQL
    NOTE: I see this post still gets views, but it is very old and out of date. MySQL has now had CTEs since 8.x and they work pretty well. ...
  • "In Which We Are Not Having Fun"
    Speaking of Postgres materialized views... The guys at sparkfun (makers of Arduino as well other fine products) migrated from MySQL to Postg...
  • Evil MySQL Feature: INSERT IGNORE
    👿👿👿 WARNING: EVIL LIES AHEAD. ABANDON ALL HOPE--ETC., ETC. 👿👿👿 The non-standard MySQL IGNORE keyword, when used in conjunction with I...
  • Standard SQL, Shmandard SQL
    I find the concept of "Standard SQL" - referring to these magical ANSI/ISO/IEC/whatever documents that spec out how SQL is suppose...
  • Arrays vs. IN-lists in SQL Using JDBC: Techniques and a Glance Under the Hood
    Intro: Alright, so say you want to run a query that has the WHERE clause WHERE id IN (...) from your Java program, using JDBC, where the co...
  • Postgres query using window functions, recursive query
    As Tom Kyte says, " Analytics rock. Analytics roll. " Among other things, Oracle's analytic queries allow a row in the results...

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

Labels

postgresql (46) postgres (45) oracle (36) MySQL (28) reference (16) MS SQL (10) SQL Server (7) performance (7) materialized views (5) AskTom (4) CTEs (4) ddl (4) window functions (4) Java (3) SQL injection (3) Tom Kyte (3) common table expressions (3) pl/sql (3) recursive query (3) BoobyTrap (2) Evil MySQL Feature (2) JDBC (2) SQL here != SQL There (2) db2 (2) diff (2) foreign keys (2) generate series (2) indexes (2) locking (2) rant (2) series (2) sqlplus (2) with recursive (2) ANSI (1) Books (1) INSERT IGNORE (1) ISO (1) JOOQ (1) JSON (1) MATCH_RECOGNIZE (1) REPLACE INTO (1) Sybase (1) bind variables (1) bonkers (1) bug (1) caching (1) cartoon (1) character sets (1) clustering (1) collations (1) column store (1) constructing rows (1) db-engines (1) distinct on (1) dynamic columns (1) incremental refresh (1) inheritance (1) installation (1) joins (1) just bind (1) key-value (1) length (1) linux (1) locks (1) mariadb (1) merge (1) microsoft (1) optimizations (1) parallel (1) parameterization (1) pivot (1) preparedstatement (1) query rewrite (1) quiz (1) random (1) row constructor (1) row pattern matching (1) sequences (1) shared memory (1) standard SQL (1) sucks (1) trick (1) unpivot (1) versioning (1) whygod (1) wonky (1)

About Me

My photo
MWrynn
Self-proclaimed SQL geek whose career has largely focused on SQL, and the database software that processes the language, in one form or another since 2003. Motto: "When in doubt, test it out."
View my complete profile

Blog Archive

  • ►  2025 (8)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  May (4)
  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (3)
    • ►  November (3)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ▼  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ▼  March (5)
      • Parallel Sequential Scan for PostgreSQL 9.5
      • Goodbye MongoDB, hello PostgreSQL
      • The mwrynn PL/SQL Table API
      • The Oracle section of my bookshelf...
      • Database Independence comment on Reddit, or, "What...
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Report Abuse

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Search This Blog

MySQL automatically indexes materialized CTEs

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Playing SQL Mythbuster - or - I really ought to lay off the SQL on social media
    Often, when I visit SQL-related forums and social media, I encounter posts that are half-truths, overgeneralizations, and sometimes, outrigh...
  • Pgpool-II Load Balancing
    NOTE: this post is surely hopelessly out of date. It is from 2011! I say this because the post is still getting views well over a decade lat...
Watermark theme. Powered by Blogger.