Re: Optimizing tables for known queries?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: John Anderson <sontek(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing tables for known queries?
Date: 2014-02-10 22:13:00
Message-ID: 3375FF0E-A1B4-468B-9444-E2C9050CA6FF@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Feb 9, 2014, at 2:48 PM, John Anderson <sontek(at)gmail(dot)com> wrote:

> What I'm wondering is if there is a more denormalized view of this type of data that would make those of types of queries quicker?

That sounds like a materialized view?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marti Raudsepp 2014-02-10 22:20:47 pg_test_fsync: "Invalid argument" in the middle of a test
Previous Message peterlen 2014-02-10 17:49:54 Re: How to turn off DEBUG statements from psql commends