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

how to handle larger databases?

From: matthias(at)cmklein(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: how to handle larger databases?
Date: 2004-11-16 02:21:06
Message-ID: E1CTsxu-0005et-00@www.strato-webmail.de (view raw or flat)
Thread:
Lists: pgsql-admin
I am currently creating a database which will have less than 20 quite
simple tables.
Unfortunately, some of those tables will have more than 1 million
entries.
In order to maintain fairly good query times I would like to ask for some
tips on how I should organize that database, what I should do or what I
should avoid.

Thanks

Matt

pgsql-admin by date

Next:From: Jeoffrey L. PalacioDate: 2004-11-16 05:55:30
Subject: psql: FATAL: user "root" does not exist createdb: database creation failed
Previous:From: Tom LaneDate: 2004-11-16 01:34:51
Subject: Re: evil characters #bfef cause dump failure

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