Postgres Pro
Downloads
Home   >   mailing lists

how to handle larger databases? - Mailing list pgsql-admin

From matthias@cmklein.de
Subject how to handle larger databases?
Date
Msg-id E1CTsxu-0005et-00@www.strato-webmail.de
Whole thread Raw
List pgsql-admin
Tree view 
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:

Previous
From:
Date:
Subject: Please help!!!!!!!!!
Next
From: "Jeoffrey L. Palacio"
Date:
Subject: psql: FATAL: user "root" does not exist createdb: database creation failed