Bill wrote:
Ok, so maybe someone on this group will have a better idea. We have a
database of financial information, and this has literally millions of
entries. I have installed indicies, but for the rather computationally
demanding processes we like to use, like a select query to find the
commod
Richard Huxton <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> This could be repaired by doing
>> pg_resetxlog with a more appropriate initial transaction ID, but
>> figuring out what that value should be is not easy :-(
> Tom - would there be any value in adding this to a pg_dump?
Possibly. CV
Tom Lane wrote:
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
The pg_resetxlog was run as root. It caused ownership problems of
pg_control and xlog files.
Now we have no access to the data now through psql. The data is still
there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But
ther
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> The pg_resetxlog was run as root. It caused ownership problems of
> pg_control and xlog files.
> Now we have no access to the data now through psql. The data is still
> there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But
> there is n
Hi Bill, I am more often in the "needing help" category than the "giving
help" when it comes to advise about using postgresql. I have found it to be
an extremely powerful tool and by far the best performance/price for my
work.
I think you will get some excellent answers and help to your performan
The pg_resetxlog was run as root. It caused ownership problems of
pg_control and xlog files.
Now we have no access to the data now through psql. The data is still
there under /var/lib/pgsql/data/base/17347 (PWFPM_DEV DB name). But
there is no reference to 36 of our tables in pg_class. Also the
On Tue, 22 Jun 2004 12:31:15 -0500 Bill <[EMAIL PROTECTED]> wrote:
> I have installed indicies,
but are there any statistics? vacuum analyze is your friend
> but for the rather computationally
> demanding processes we like to use, like a select query to find the
> commodity with the highest month
Sounds like an issue I have experienced in Oracle as well. If you can
you might want consider breaking out your database into oltp (on line
transaction processing) and data warehouse db. You run you any reports
you can nightly into a set of warehouse tables and save your daytime
cpus for incoming i
On Tue, Jun 22, 2004 at 12:31:15 -0500,
Bill <[EMAIL PROTECTED]> wrote:
> Ok, so maybe someone on this group will have a better idea. We have a
> database of financial information, and this has literally millions of
> entries. I have installed indicies, but for the rather computationally
> dema
Ok, so maybe someone on this group will have a better idea. We have a
database of financial information, and this has literally millions of
entries. I have installed indicies, but for the rather computationally
demanding processes we like to use, like a select query to find the
commodity with the
Litao Wu <[EMAIL PROTECTED]> writes:
> I have changed "reindex table my_table" to:
> psql ...
> -c "drop index my_index; create index my_index;"
> I do not know what caused this happen, and I
> am also confused. If create index my_index is killed
> by "-9", then my_index should not present in t
Bill,
> Any ideas of how I can cluster my database (around 800 GB
> in size so even partial replication is not really practical)?
Um, raise $150,000 to pay for a clustering implementation?
Various techniques of "shared memory clustering" have been tried with
PostgreSQL, and none work.Neit
Janio,
> I am trying install the postgresql-7.4.3 simple installation. I did
> ./configure command at the postgresql directory source. While the
> configuring proccess I receiving the follow message:
This is the wrong list for this question. Please try PGSQL-ADMIN. You're
much more likely to g
Hi,
I have changed "reindex table my_table" to:
psql ...
-c "drop index my_index; create index my_index;"
We still experience the same "hang" problem.
I was told that this time, the process is
"create index my_index;" before the PG server is
bounced.
When I login the database, I found the
my
Hi, I am trying to make a cluster out of any
database, postgresql or mysql or any other free database. I have looked at
openmosix patched with the migshm patch for shared memory support and it seems
that neither work fully. Postgresql in particular uses "shared memory but
not the system se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
|> What exactly are you trying to gain, avoid, or do?
Gain: seperate database storage from processing. This lets me move
clusters from one server to another easily. Just stop the postgres
instance on server A and unmount it's filesystem. Then mount it o
As you suggets I've tried to upgrade to the kernel 2.4.28, but it seems that
nothing change!
I built a new machine with Red Hat 8 (kernel 2.4.28) a 1GB RAM using the
same parameters i've been used before.
After the boot, i've got 800Mb of free memory, if a launch a pg_dump then
the system swap (on
How about iSCSI? This is exactly what it's for - presenting a bunch of
remote SCSI hardware as if it were local.
There are several reference implementations on SourceForge from Intel, Cisco
& others.
I've never tried it myself, but I would if I had the need. And let's face
it there are some v
There are some less expensive baby-SAN options coming out now - Dell
has an
rebranded EMC baby SAN (which of course doesn't work with any other EMC
system...) that starts at about $6000 or so. Just read the announcement
- don't know
anything else. While there have been some reports of undewhelmin
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Andrew
Rawnsley) transmitted:
> On Jun 21, 2004, at 2:02 PM, Andrew Hammond wrote:
>> We're looking for an alternative to fiber-channel disk arrays for mass
>> storage. One of the ideas that we're exploring would involve havi
20 matches
Mail list logo