"Adam Rich" <[EMAIL PROTECTED]> writes:
> I have a table similar to this:
> CREATE TABLE event_resources (
> event_resource_id serial NOT NULL,
> event_id integer NOT NULL,
> resource_id integer NOT NULL,
> start_date timestamptz NOT NULL,
> end_date timestamptz NOT NULL,
>
I have a table similar to this:
CREATE TABLE event_resources (
event_resource_id serial NOT NULL,
event_id integer NOT NULL,
resource_id integer NOT NULL,
start_date timestamptz NOT NULL,
end_date timestamptz NOT NULL,
CONSTRAINT event_resources_pkey PRIMARY KEY (event
tsuraan <[EMAIL PROTECTED]> writes:
> Is the WAL at the same location as the xlog (transaction log?)?
Same thing.
> The checkpoint_segments doc says increasing that value is really only
> useful if the xlog is separate from the data,
Dunno where you read that, but it's utter bilge. If you've go
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html is a good
intro to the various parameters you might set, with some valuable hints on
the effective range you should be considering. I'd suggest you use that
to identify the most likely things to increase, then read the manuals at
htt
On Sun, 17 Dec 2006, tsuraan wrote:
Since my application is constantly adding to the database (far more is
written than is ever read), it would be nice to have a multiple-write,
single reader solution, if such a thing exists.
You seem to be working from the assumption that you have a scaling i
For scaling you should consider slony. Either hangout on #slony on
Freenode.net or ask on the mailing list if you have questions.
For some reason I had thought slony was really immature, but it
actually looks really usable.
Intel chips => define more. There are Intel boxes known to have issues
To quickly find out a subset of slow queries on your production system, you
can use the pgfouine tool:
http://pgfouine.projects.postgresql.org/
If you then want to make some measurements of PostgreSQL performances with
some different settings and compare them, consider using the tsung tool (and
tsuraan <[EMAIL PROTECTED]> wrote:
>
> I'm writing a webmail-type application that is meant to be used in a
> corporate environment. The core of my system is a Postgres database
> that is used as a message header cache. The two (relevant) tables
> being used are pasted into the end of this messag
On Fri, Dec 15, 2006 at 10:44:39 -0600,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
>
> The other feature I would like is to be able to use write barriers with
> encrypted file systems. I haven't found anythign on whether or not there
> are near term plans by any one to support that.
I asked abo