Mark Lubratt wrote:
Obivously, I have a lot of sequential scans going on, at about what
cost does it start to make sense to make an index? Or, should I just
put in a bunch of indexes and let the optimizer decide whether or not
to use them?
Read the chapters on Indexes and Performance Tips in
Hello people!
I have a question, I am going to begin a project for the University in
the area of Data Warehousing and I want to use postgres.
Do you have some recommendation to me?
Thanks!!
Greetings, Pablo
---(end of broadcast)---
TIP 1:
Hi all,
I've got a situation on certain machines where approximately
70 postmasters are running. Each with one database, and one
data directory.
This is fine most of the time, except for a certain time of the month,
when a very large consolidation process has to run on each database.
At this
I have a table that will recieve about 2000 inserts per day, Although
it will technically never be dead data, about 99.999% of it will be
uninteresing after 30-40 days, My problem is that I dont know if I
should create a new table that is a history table or add a indexed field
and ignore
Stef [EMAIL PROTECTED] writes:
I've managed to make such a database cluster on a separate postmaster,
and re-linked all the database directories to point to the data directories
of all the other postmasters.
Although this workaround seems to be working rather well, I know for one
thing that
Hi All,
Do anyone of you aware of any good PG import tool same as SQL*LOADER in
ORACLE
We are doing some DataWarehouse work and need to import a large set of data
from csv files.
We are trying a import tool from ems-hitech.com, but I have troubles when
loading time and date columns.
Any help
Louie Kwan wrote:
We are trying a import tool from ems-hitech.com, but I have troubles when
loading time and date columns.
...
data.csv
31/01/2004,D1H01,845,IP,dfrQCQCRD1,Normal,142.130.35.1
31/01/2004,D1H01,849,IP,dfrQCIMCP1,Normal,142.130.130.33
Tom Lane mentioned :
= Get out your backup tapes, because what you have on disk now is just a
= pile of inconsistent bits.
I haven't actually done anything but SELECT's from the shared postmaster,
and it was a test machine. Phew!! Glad I asked first...
I think the way I'll do it, is by using