222 links
  • Zertrin's links
  • Home
  • Login
  • RSS Feed
  • Tag cloud
  • Picture wall
  • Daily
Links per page: 20 50 100
page 1 / 1
9 results tagged postgres x
  • Clone schema in Postgres | Denish Patel
    A function to clone a shema in PostgreSQL.
    Tue 20 Aug 2019 04:05:28 AM +08 - permalink -
    - http://www.pateldenish.com/2019/08/clone-schema-in-postgres.html
    database postgres sql
  • Cybertec Postgres Configurator
    Tool to help tune postgresql.conf parameters.
    Sat 25 Aug 2018 03:33:13 PM +08 - permalink -
    - http://pgconfigurator.cybertec.at/
    config database postgres sql
  • PostgreSQL Primer for Busy People · zaiste.net
    Tue 08 May 2018 10:33:06 AM +08 - permalink -
    - https://zaiste.net/postgresql_primer_for_busy_people/
    admin cheatsheet database postgres
  • PostgreSQL when it’s not your job.
    Tue 04 Oct 2016 04:10:28 PM +08 - permalink -
    - http://thebuild.com/presentations/not-my-job-djangocon-us.pdf
    admin config database pdf performance postgres sql
  • A beginners guide to thinking in SQL 🐘
    Tue 12 Jul 2016 08:43:33 PM +08 - permalink -
    - http://www.sohamkamani.com/blog/2016/07/07/a-beginners-guide-to-sql/
    beginner database postgres sql
  • Preventing Human Errors in Postgres | Denish Patel
    Preventing DROP DATABASE dirty hack
    and
    Preventing DROP TABLE not so dirty trick
    Mon 12 Oct 2015 01:15:35 PM +08 - permalink -
    - http://www.pateldenish.com/2014/02/preventing-human-errors-in-postgres.html
    database drop postgres
  • \timing on: Comparing two tables - Postgres
    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.

    This is great, but turns out to be quite tricky.   You need to take care of the cases that,

         Either table may not have a primary key
         Rows in the two tables may be physically stored in different orders.
        Columns could contain nulls.
        The two tables could be huge, so performance must be good.

    Here are something you could do.
    Wed 17 Jun 2015 06:02:16 PM +08 - permalink -
    - http://vitesse-timing-on.blogspot.de/2015/05/comparing-two-tables.html
    compare postgres table
  • The precision — or lack thereof — of time
    Fri 12 Jun 2015 11:22:50 PM +08 - permalink -
    - http://bluetreble.com/2015/06/time/
    database postgres time
  • Postgres full-text search is Good Enough!
    In this post we are going to progressively illustrate some of the full-text search features in Postgres.
    Tue 30 Sep 2014 08:46:04 PM +08 - permalink -
    - http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/
    database postgres search sql text
Links per page: 20 50 100
page 1 / 1
Shaarli - The personal, minimalist, super-fast, no-database delicious clone by the Shaarli community - Help/documentation