Dear psql-performance,
I'm having issues with a certain query, and I was hoping you could help me
out.
The schema:
(start with new database cluster, with either SQL_ASCII or en.us-UTF8
encoding, using the default server configuration available in the pgdg
Jessie packages).
CREATE TABLE a (id bi
On Sun, Feb 28, 2016 at 2:06 AM, David Rowley
wrote:
> On 27 February 2016 at 11:07, James Parks wrote:
> >
> > CREATE TABLE a (id bigint primary key, nonce bigint);
> > CREATE TABLE b (id bigint primary key, a_id bigint not null);
> > CREATE INDEX a_idx ON
Hi pgsql-performance!
So I have a Postgresql database -- version "PostgreSQL 9.4.8 on
x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit",
specifically.
In it, I have essentially two categories of tables:
- small tables that are updated frequently, and tend to be often queri
