On Sep 22, 2006, at 3:20 AM, Alain Roger wrote:When i migrate my DB to another computer, should i recreate all roles manually ?either that or use this command to dump the roles as an SQL file you can feed into the new server. it will complain about trying to recreate the superuser, but that's
On Sep 21, 2006, at 10:27 PM, Christopher Browne wrote:
In contrast, if a similar infringement were found with one of the
products of, say, IBM, you might discover that you got some value for
money out of those licensing fees in that the only folks sued are
likely to be IBM...
That assumes
On Sep 22, 2006, at 1:03 PM, Jim C. Nasby wrote:
Berkus doesn't count??! He's got long hair! What more do you want?!
Well, then based on volume he should count as two :-)
No offense intended, Josh... *I'd* count as two, too.
smime.p7s
Description: S/MIME cryptographic signature
On Sep 7, 2006, at 3:31 PM, andy rost wrote:
a) The system load is 20
b) WCPU values for the 14 active pgpool processes exceed 20%
c) Context switching on the server jumps as high as 250,000
The application now takes 4 (with pgpool) rather than less than two
hours (without pgpool) to
On Sep 8, 2006, at 4:29 PM, Francisco Reyes wrote:
I have a database that I started with 1,000,000 max_fsm_pages and I
was doing vacuum analyze verboze daily. Checked every couple of
days to make sure we had the right amount of fsm pages.
A few days ago I noticed that we got the notice
On Sep 3, 2006, at 8:46 PM, Tom Lane wrote:
(b) I believe there's a null cipher mode for SSL if you truly don't
need encryption.
Nothing such is obviously documented for SSHv2, which is unfortunate
for some uses.
smime.p7s
Description: S/MIME cryptographic signature
On Aug 17, 2006, at 12:43 PM, Matthew T. O'Connor wrote:
Do you have row level stats enabled?
is block level stats not sufficient for autovacuum?
i'm seeing the same: show all tells me autovacuum is off, but it is
for sure turned on in the postgresql.conf file and block level stats
are
On Aug 2, 2006, at 8:05 PM, Thomas Burns wrote:
I have 5 shared buffers and 1 temp buffers (the machine has
16G ram). The disks are new/fast SCSI drives
what's their configuration? RAID? if so, what controller and setup?
if not, what controller and setup?
without all the
On Aug 2, 2006, at 2:07 AM, Tom Lane wrote:
that the OP's complaint is valid. I would still expect any
reimplementation of notify messaging to honor the principle that a
LISTEN doesn't take effect till you commit. Otherwise, what of
Well, it would break our usage of LISTEN/NOTIFY if they
On Jul 31, 2006, at 3:45 PM, Thomas Burns wrote:
our database literally takes 8 times longer on the x4200 as it does on
OS X (the x4200 hardware should be considerably faster -- it has
better
for a restore like this, bump up the value of checkpoint_segments to
some large value (I use 256
On Jul 10, 2006, at 1:33 PM, Karen Hill wrote:
Is the difficulty of creating a telephone type the reason it is not in
postgresql already?
Should the telephone type be able to do something such as:
SELECT * from tableFOO where telephone.areacode = 555;
Or would regex be better?
makes more
?
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
On Jul 2, 2006, at 9:55 AM, Joe wrote:
I'm now migrating to FreeBSD and was surprised to find that the
port used 'pgsql' as the user. The maintainer said that was done
to ensure backward compatibility because that *was* the original
name. Since I didn't need to be backward compatible
On May 14, 2006, at 12:27 AM, Ed L. wrote:
While watching a 9-hour 60GB network load from 7.4.6 pg_dump into
8.1.2, I noticed the order in which indices and constraints are
created appears to be their creation order.
If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 DB,
what is
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity
On May 3, 2006, at 12:00 AM, David Fetter wrote:
Would be glad to hear if there are examples of existing
commercial/OSS products to serve the purpose.
If you're not using PostgreSQL for the smaller systems, you might be
able to rig something up with pg_dump using the --inserts option. The
On Apr 28, 2006, at 9:32 AM, Csaba Nagy wrote:
I'm not sure how this operation can work in the presence of other long
running transactions which did not touch the queue table yet, but it
actually does work, I can confirm that. Is it violating MVCC maybe ?
It sounds like it does potentially
On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:I am developing a temporal database and I have the necessity to control the integrity constraints befor the commit of the transiction.I cannot use the deferrable checking because the integrity constraints is a select and i cannot use the trigger
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote:
We knows installation of tsearch2 working with 4 millions docs.
What are the design goals for the size of the source tables? My
engineers are telling me of things their friends have tried and have
hit limits of tsearch2. One was
On Apr 27, 2006, at 11:06 AM, Kenneth Downs wrote:I've got a test database that is going live. During development I have not vacuum'd much, so to get started I did "Vacuum verbose analyze". you probably really do have a lot of spare space in the files. i'd recommend vacuum full if you can, to
On Apr 20, 2006, at 9:02 PM, [EMAIL PROTECTED] wrote:
1) How anal should I be about my hardware setup? I have about 15
300GB
10K RPM SCSI drives, 4 of which I can directly attach to the server
and
the rest one the FC array. Should I just put the OS and transaction
logs on the direct
On Mar 31, 2006, at 1:51 PM, Ed L. wrote:
This indeed appears to be locking problem from within
Apache::Session where it deletes a row from the DB but fails to
commit the change for an extended period while another
And you should read well the notes in the Pg driver for
Apache::Session
On Mar 29, 2006, at 11:03 AM, Kenneth Downs wrote:
I am fascinated by your post. I have never heard a bad thing said
about RoR.
Most of what you read about RoR is written from a very superficial
view of what it promises, as tainted by the simplistic uses of mysql
people are familiar
On Mar 29, 2006, at 12:33 PM, Steve Atkins wrote:
For the original poster - a web interface might well be the
simplest to put together,
but if a client turns out to be a better solution I'd strongly
suggest looking at Qt.
It has nice SQL support and it's very quick to turn around a simple
On Mar 29, 2006, at 12:35 PM, Nico Callewaert wrote:
Because from what I understand, for every foreign key, there is an
index defined. So, all these indexes has to be maintained. Is
that killing performance ? What's the best practise : defining
foreign keys or not ?
If your
On Mar 29, 2006, at 11:50 AM, Scott Marlowe wrote:
There's much in the reservation industry that is basically a computer
implementation of a 3x5 note card system. And none of those systems
were originally built to talk to each other, so it's often impossible
We at one time built a nice
On Mar 28, 2006, at 4:47 AM, surabhi.ahuja wrote:However those application will be running with the 64-bit installed postgres server.They speak to each other via TCP/IP protocol which is CPU independent. so yes, it will work (and does work).
On Mar 27, 2006, at 4:46 AM, JP Glutting wrote:
Can anyone reproduce this on Linux or another platform? Is this a
known bug?
I took your dump and loaded it into a Pg 8.1.3 database on FreeBSD 6
with UTF-8 encoding. Then I did pg_dump on that database and it had
no complaints.
The
On Mar 21, 2006, at 4:39 PM, Rushabh Doshi wrote:
This is my problem. I have a connection to the database using DB-
connect.
Apparently, this connection sits idle for around an hour or so
because of my
application, and after that it has to do something. So I check that
if the
handle is
On Mar 22, 2006, at 6:06 AM, Jimbo1 wrote:
lab (who uses MySQL to manage their terabyte data warehouse) said, We
chose MySQL over PostgreSQL primarily because it scales better and has
embedded replication...
The one size fits all style replication. What if it doesn't suit
your needs?
On Mar 22, 2006, at 1:37 PM, Tass Chapman wrote:
Checkpoints appear to be up to date (via pg_controldata), but the
pg_xlog directory has 95 files, of which 90 are dated before
midnight yesterday or earlier.
Can I just delete them safely? Or is there some recovery method I
can do?
On Mar 21, 2006, at 6:50 AM, Martijn van Oosterhout wrote:
But I'm ademantly against building and maintaining a special UTF-8
collation library just for PostgreSQL. That's just reinventing the
wheel. There already exist cross-platform libraries to handle
collation
and we should work towards
On Mar 16, 2006, at 3:36 AM, Martijn van Oosterhout wrote:
Umm, you should choose an encoding supported by your platform and the
locales you use. For example, UTF-8 is a bad choice on *BSD because
there is no collation support for UTF-8 on those platforms. On
Linux/Glibc UTF-8 is well
On Mar 20, 2006, at 6:04 PM, Peter Eisentraut wrote:
Vivek Khera wrote:
Shouldn't postgres be providing the collating routines for UTF8
anyhow?
Start typing ...
So, if I use a UTF8 encoded DB on FreeBSD, all hell will break loose
or what? Will things not compare correctly? Where from
We're developing a DB that will be storing email messages. The clear
winner for the DB encoding is UTF8. However, I will need to set the
proper client encoding based on the encoding as defined in the email
message.
Looking at the docs (http://www.postgresql.org/docs/8.1/static/
On Mar 14, 2006, at 9:54 AM, Bryan White wrote:
How can I clean this up. Would dropping the user have any effect?
This is on 7.4 if that makes a difference.
dropping the user will leave dangling permissions (ie, Pg will report
them as being granted to user 103 or whatever Id that user
On Feb 23, 2006, at 8:47 AM, Ragnar wrote:
select * from pg_stat_user_indexes ;
which level of stats do I need to enable this? block level or row
level or both?
thanks.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Feb 23, 2006, at 9:21 AM, [EMAIL PROTECTED] wrote:
Could anybody point to an on-line resource about the steps involved
with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with
minimum downtime (i.e. 1 - stop db so that no changes happen 2 -
dump 3 - upgrade (ports) 4 - import
On Feb 16, 2006, at 6:27 AM, Alban Hertroys wrote:
Vivek Khera wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth do people
live with this software?
That's the part where they allow only one NULL value in a unique
On Feb 7, 2006, at 1:34 PM, Brad Nicholson wrote:
Slony's log shipping is another option.
But that requires at least one regular replica to exist as well.
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Jan 31, 2006, at 4:57 PM, Jim C. Nasby wrote:
There's also darwinports, which has 8.1.2.
but does some idiotic bizarre weird strange install of the binaries
into /opt/local/lib/pgsql8/bin/ and symlinks the psql program as
psql8 into your normal bin directory. it is just painful to
On Jan 30, 2006, at 8:32 PM, Devrim GUNDUZ wrote:
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
You need to take a sniff over at the FreeBSD ports. Lets you
On Jan 24, 2006, at 7:47 AM, Vittorio wrote:
Yesterday, I upgraded freebsd from 5.4 to 6 via
the CD (the iso was downloaded from ftp.freebsd.org).
I've done this many times with no problems.
However.
You serve yourself very well by recompiling all your ports or
reinstalling the
On Jan 21, 2006, at 8:09 AM, Sander Steffann wrote:
Dell has used (and rebranded) Adaptec and LSI controllers for their
PERC series, and I agree that the Adaptec controllers perform
badly. As far as I know the LSI based controllers are quite good
(and some come with 256MB battery backed
On Dec 28, 2005, at 9:46 AM, Frank van Vugt wrote:
I may be overlooking some option here, but somewhere between the v7
series and
the current v8.1.1 that I'm using, failed queries stopped being
logged, only
the error message appears in the log (config option log_statement =
all).
I.e.
On Dec 28, 2005, at 8:28 AM, Christopher Browne wrote:
Some separate process (perhaps polling, perhaps using NOTIFY/LISTEN)
would then grab messages from the table and submit them to [whatever
is the communications layer].
That is a clean sort of design for that sort of thing.
This is
On Dec 13, 2005, at 2:49 AM, [EMAIL PROTECTED] wrote:
What is the performance difference between U320 15kRPM and U320
10kRPM ?
Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
and something like memory backup write cache (like HP DL 380 server) ?
Do you use Intel or Opteron
On Dec 13, 2005, at 3:50 AM, Benjamin Arai wrote:
What kind of performance boost do you get from using raid 10? I am
trying
to do a little cost analysis.
For small amounts of data you probably wont notice anything. Once
you get into the 10's of GB you'll notice improvement when you
On Dec 10, 2005, at 6:37 PM, Benjamin Arai wrote:
For the most part the updates are simple one liners. I currently
commit in large batch to increase performance but it still takes a
while as stated above. From evaluating the computers performance
during an update, the system is
On Nov 17, 2005, at 4:44 PM, Robby Russell wrote:
Sort of a meta-approach for Rails-based scaffolding generator. Not
required, but it'll speed up the process and limit the number of chars
that you can stick into a text field opposed to a text area.
Yet again you see RoR compensating for lack
On Nov 16, 2005, at 1:09 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
There are a few obstinate anti-open source customers though, that
prevent my plan from moving forward. They've bought into whatever
hype they've read and just simply say no. Now, that said, they're
fairly non-technical
On Nov 16, 2005, at 4:17 PM, Bruno Wolff III wrote:
On Wed, Nov 16, 2005 at 14:19:28 -0500,
Vivek Khera [EMAIL PROTECTED] wrote:
if they're poking around the process table, just change the name of
the postmaster executable and the socket it creates to johnsdb or
some such.
I think you
On Nov 10, 2005, at 3:43 PM, Matthew T. O'Connor wrote:
Yes exactly, and if you find that pg_autovacuum is never or not
often enough firing off vacuum comands, then you will need to play
with the threshold settings. The default thresholds for
pg_autovacuum are too conservative for most
On Nov 10, 2005, at 1:03 PM, Andrus wrote:
How I can select Slony-I installation option ?
I havent seen such thing during 8.1 installation.
also, as it stands today, slony-I doesn't support 8.1 at all due to
some internal changes. it is obviously a high priority to remedy
this
On Nov 8, 2005, at 8:16 AM, Greg Sabino Mullane wrote:
This is correct. Though generally not recommeded, you can switch it
off
with the pg_server_prepare attribute like so:
$dbh-{pg_server_prepare} = 0;
This will force DBD::Pg to do the quoting itself, with the subsequent
penalty of speed
On Nov 1, 2005, at 5:12 PM, Jim C. Nasby wrote:
My understanding is that there is no 32 bit version of FBSD on
Opterons;
as soon as buildworld sees it's on an Opteron everything goes 64 bit.
you would understand incorrectly, then. freebsd will never flip you
up to 64 bit world like
On Oct 18, 2005, at 12:52 AM, Scott Marlowe wrote:What problems have you run into lately? And could pg_restore fix them, or were they too hairy?the only issues I have are when not doing a full dump/restore of a DB -- ie only pulling in data into an existing table structure. the ordering is not
On Oct 17, 2005, at 9:34 AM, Dan Armbrust wrote:
Jim C. Nasby wrote:
pg_dump handles table ordering properly.
Maybe I missed something then, because it didn't last time I tried
to move some data. I had to drop my foreign keys before I could
reload it.
This is my experience as well.
seems to have heavily
influenced the above mentioned trac, which obviously works with CVS.
I personally use the SVN trac to great benefit. It has helped our
organization get so much better organized and keeps everyone informed
of what is going on.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
On Oct 11, 2005, at 3:07 PM, Florian G. Pflug wrote:
On the whole, the update as quite easy ride, but I'd still
recommend you to test all aspects
of your software after the migration, since 8.0 isn't bug-for-bug
compatible with 7.4
I'll second this. One thing we found out too, was we
On Oct 4, 2005, at 4:38 PM, Aaron Smith wrote:
I never imagined that I would get so many responses. Thanks for all
the great information!
depending on the nature of your DB you may wish to investigate SQLite
as well. it is designed to be embedded into apps, not run as a
separate
On Sep 29, 2005, at 8:38 AM, Bob Parkinson wrote:
Upgraded PG to 8.0.3, DBI to 1.48 and DBD::Pg to 1.43 this morning,
but made no difference. FreeBSD 5.4 (they'll get it right
RSN :- )), perl 5.8.2
I've had bad mem leaks on FreeBSD with perl 5.8.6. Try upgrading
that as well.
On Sep 29, 2005, at 1:23 PM, Keary Suska wrote:
You should always finish() every select statement handle, or both
DBI and
libpq will leak:
$sth-finish;
after the closing bracket of the while() loop.
No, you don't need to call finish() if you fall off the end of a
while
On Sep 26, 2005, at 12:43 PM, Raj Gupta wrote:
While migrating a table, we got the following error:
ERROR: could not write block 2830 of relation
1663/2276041/4965853: Operation not permitted
This came when pg was trying to create an index on the relation.
Has anyone seen this
could also investigate making a copy using a replication system
like slony (http://slony.info) then once the copy is made turning off
the replication.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 5: don't forget to increase
on Opteron
systems.
Perhaps it is a bug in the power5 gcc compiler? Turn off machine
specific tuning and see what happens.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 6: explain analyze is your friend
tire .info (and now .org) domain registries are stored on postgres. Vivek Khera, Ph.D. +1-301-869-4449 x806
results in 10k related rows being deleted, I pause for a
smaller amount of time.
This keeps everything moving along, and *nobody* notices. So what if
it takes 3 days to finish...
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast
the one
I want, I check that. If the row is not updated (ie, count 0
returned) then I do a standard update based just on the user_id which
is the PK.
When you add this up over millions of rows, it makes a difference to
bypass the PK index lookup every time.
Vivek Khera, Ph.D.
+1-301-869
pool
connections over mod_perl and Apache::DBI. I haven't satisfied
myself yet that the timeout will be unset when the next connection
uses the DB...
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 3: Have you checked
post your investigations to
the list - I for one would be interested.
But don't put important data on it since it doesn't do ECC RAM
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
On Jul 27, 2005, at 12:09 PM, Scott Marlowe wrote:
On Wed, 2005-07-27 at 10:56, Vivek Khera wrote:
But don't put important data on it since it doesn't do ECC RAM
Considering the small incremental cost of ECC ram, it's hard to
believe
someone would build one of those without
not be windows...)
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
...
It does work. I just installed Pg 8.0.3 on my workstation using
darwin ports (which really only just sets some funky installation
location paths and does a standard build).
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 5
to go about this? Am I about to write my first
server side function for postgresql?
create your unique index using the lower() function.
and don't steal threads to start a new one (ie, replying then just
changing the subject)
Vivek Khera, Ph.D.
+1-301-869-4449 x806
to correspond with your software release numbers... or not. They can
be separate, especially once you get more stable and have more
software updaes than schema updates.
Or you could do something like Pg and require changes only for major
version number releases. :-)
Vivek Khera, Ph.D.
+1-301
to Oracle, you are probably expecting an ACID
database, which rules out MySQL too).
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
performance list).
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
On Jun 30, 2005, at 10:39 AM, Ajay Dalvi wrote:
But while installing , during configuration step i am getting an error
error: Your version of libpq doesn't have PQunescapeBytea
this means that your version of PostgreSQL is lower than 7.3
and thus not supported by Slony-I.
Though i
On Jun 29, 2005, at 9:01 AM, Sven Willenberger wrote:
Unix user root (and any psql superuser) the vacuum runs fine. It is
when
the unix user is non-root (e.g. su -l pgsql -c vacuumdb -a -z) that
this memory error occurs. All users use the default class for
login.conf purposes which has not
On Jun 27, 2005, at 8:42 PM, Bruno Wolff III wrote:
Google is your friend. There are places that sell very well kept
zipcode databases for under $50.
The US government gives it away for free. Look for tiger.
That is stale data.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
urge you to derive the formulas yourself from basic
research so you *know* you're getting what you think you're getting.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
box inside which you run your
distance computation.
Putting it together is left as an exercise for the reader (hint: just
AND your pieces together...)
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
, or check
record integrity somehow). Same advice as you get for verifying your
system tape backups...
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
well kept
zipcode databases for under $50.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
and burn those to the DVD. To restore, you
cat my.dump.split.?? | pg_restore with appropriate options to
pg_restore.
My ultimate fix was to start burning and reading the DVD's on my
MacOS desktop instead, which can read/write these large files just
fine :-)
Vivek Khera, Ph.D.
+1-301
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
on if the second query does an update or
just a select. it should be clarified.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
s the stty command. Don't do that. Why do you need stuff from your .profile anyhow?And why would you drop the output to /dev/null -- you'll never know if your dump fails! Why bother making one then? Vivek Khera, Ph.D. +1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
On May 26, 2005, at 11:55 AM, Manuel Garca wrote:Hello, Somebody knows If is possible to catch all the sentences applies to one table using triggers and function in C maybe, thats because, I need to create one log table with all the sentences. Once that I have that I going to use all the sentences
On May 26, 2005, at 2:41 PM, David Parker wrote:
But I'm wondering - shouldn't that be part of normal server startup,
cleaning out the pg_listener table? Or has this been addressed in
8.X.?
Or is there a reason this isn't a good idea?
Try slony 1.0.5, which fixed *many* issues and bugs.
needed for that will be applicable to gcc4 on
any other platform too. But that's just a SWAG.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
smime.p7s
Description: S/MIME cryptographic signature
On Apr 1, 2005, at 3:00 PM, Peter Childs wrote:
Either this message is a joke, Or you have all gone mad?
I see a postpostgres on the horizon.
no, dave broke tradition and posted an entirely factual newsletter on
april 1. I think he should lose his job for that. :-)
On Mar 30, 2005, at 4:47 PM, Alvaro Herrera wrote:
Now this can't be applied right away because it's easy to run out of
memory (shared memory for the lock table). Say, a delete or update
that touches 1 tuples does not work. I'm currently working on a
proposal to allow the lock table to spill
, so the log
information is either conflicting or incomplete.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
optmizations, and it seems much more stable so far (24 hours)
and somewhat faster. My daily reports went faster too (as fast as
with the Pg 7.4 box).
So I'm chalking this one up to bad compiler.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D
and 5.3+ on i386 and amd64
platforms with good results under heavy use. I'm evaluating Postgres
8.0 still.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869
the definition.
there are some tricky bits. check the archives for either this list or
the performance list for what I did to mark my reference checks
deferrable. it was within the last few months (no more than 6).
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end
with identically (translated to 8.0
style) configs.
Any ideas on where to poke around for the pipe problems?
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
: watchdog timeout -- resetting
Mar 22 10:28:24 d01 kernel: bge0: watchdog timeout -- resetting
now, the question is it OS or is it hardware :-(
Vivek Khera, Ph.D.
+1-301-869-4449 x806
---(end of broadcast)---
TIP 6: Have you searched our list
101 - 200 of 271 matches
Mail list logo