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

Re: Paging & Buffering

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Al-Haddad, Mohammad J" <mjalha(at)essex(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Paging & Buffering
Date: 2002-03-20 04:54:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> I'm doing a research in distributing DB & application.
> I want to measure the size of the intermediate relation (I'm using
>  Linux
> SuSe 7.1 "default installations" in 9 workstations each has a table),
> when I perform a SELECT operation (it gives me intermediate relation,
>  I
> have to send this relation into next workstation to perform the next
> operation) how can I measure the size of this relation.?
> Each workstation has 256 Mb RAM, consider the intermediate relation
>  dos
> not fit in the RAM, then it will goes to SWAP area, then in which
>  form
> and size?

Check TechDocs:

There are three articles about PostgreSQL database optimization there,
 all of which contain useful material related to your question.

You will also want to examine the Administrator's Guide in the online

And this section of the developer's guide:

All in all, your question does not have a simple answer because
 PostgreSQL is configurable, both at compile time and at run time, in
 ways that profoundly affect Postgres' disk, memory, and file usage.

-Josh Berkus

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-03-20 04:56:53
Subject: Re: No postgresql.conf in 7.0.2
Previous:From: Ludwig LimDate: 2002-03-19 23:26:57
Subject: No postgresql.conf in 7.0.2

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