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: web-833864@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
Mohammad,
  
> 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:  http://techdocs.postgresql.org

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
 documentation:
http://www.postgresql.org/idocs/index.php?admin.html

And this section of the developer's guide:
http://www.postgresql.org/idocs/index.php?page.html

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-2014 The PostgreSQL Global Development Group