Skip site navigation (1) Skip section navigation (2)

Re: [Bizgres-general] Re: faster INSERT with possible

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>,"Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org,"John A Meinel" <john(at)arbash-meinel(dot)com>,bizgres-general <bizgres-general(at)pgfoundry(dot)org>,"Dan Harris" <fbsd(at)drivefaster(dot)net>
Subject: Re: [Bizgres-general] Re: faster INSERT with possible
Date: 2005-07-27 21:53:02
Message-ID: op.suldqocith1vuj@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> I had in mind the extra tables that an application sometimes needs to
> operate faster. Denormalisations, pre-joined tables, pre-calculated
> results, aggregated data. These are not temporary tables, just part of
> the application - multi-user tables that stay across shutdown/restart.

	You could also add caching search results for easy pagination without  
redoing always entirely on each page the Big Slow Search Query that every  
website has...

In response to

pgsql-performance by date

Next:From: Simon RiggsDate: 2005-07-27 22:00:55
Subject: Re: wal_buffer tests in
Previous:From: Mark WongDate: 2005-07-27 21:42:01
Subject: Re: wal_buffer tests in

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group