Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing tables for known queries? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Optimizing tables for known queries?
Date
Msg-id 3375FF0E-A1B4-468B-9444-E2C9050CA6FF@silentmedia.com
Whole thread Raw
In response to Optimizing tables for known queries?  (John Anderson <sontek@gmail.com>)
List pgsql-general
Tree view

On Feb 9, 2014, at 2:48 PM, John Anderson <sontek@gmail.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? 

pgsql-general by date:

Previous
From: peterlen
Date:
Subject: Re: How to turn off DEBUG statements from psql commends
Next
From: Marti Raudsepp
Date:
Subject: pg_test_fsync: "Invalid argument" in the middle of a test