Search Postgresql Archives

Re: Optimizing tables for known queries?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: John Anderson <sontek@xxxxxxxxx>
Subject: Re: Optimizing tables for known queries?
From: Ben Chobot <bench@xxxxxxxxxxxxxxx>
Date: Mon, 10 Feb 2014 14:13:00 -0800
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <CAOdFaDUYMuxyh02tSywDwSL-izt5qTEs9Nnb8q5zW4XX0gYLKA@mail.gmail.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Optimizing tables for known queries?
  - From: John Anderson

Prev by Date: Re: How to turn off DEBUG statements from psql commends
Next by Date: pg_test_fsync: "Invalid argument" in the middle of a test
Previous by thread: Optimizing tables for known queries?
Next by thread: Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux