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
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: sub
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 tim
> 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 ignor
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
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 is
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
31/01/2004,D1H01,853,IP,dfrQCSIBL1,Normal
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 in
