Hi Lim,
"Lim Berger" <[EMAIL PROTECTED]> writes:
Wow, you are right! The "su - postgres" showed up with wildly
different values! Most notably, the "max user processes" is only 20!!
Whereas in the regular user stuff it was above 14000. Would you know
how to change this in a CentOS Linux machine?
Hi Lim,
It might also be in /etc/security/limits.conf.
Thanks. I see these two lines in that file:
postgressoftnofile 8192
postgreshardnofile 8192
How should I change these values? I am not sure how this reflects the
"ulimit" options.
Those are limits to the allow
Hi,
> Now if I want a "maintenance_work_mem" of 64M for Postgresql, what
> should the "max user processes" setting be in my ulimit, or the "open
> files" setting etc? Is there a Postgresql help or doc page I can read
> to see how these values map? I'd like to be more educated in how I
> test to t
Hi,
> On the other side of the coin, I have little confidence in DRBD
> providing the storage semantics we need (in particular guaranteeing
> write ordering). So that path doesn't sound exactly risk-free either.
DRBD seems to enforce strict write ordering on both sides of the link
according to
Hi,
> Can I add SHM with merely by managing the entry in sysctl.conf? My
> current values:
>
> kernel.shmmax = 536870912
> kernel.shmall = 536870912
>
> My "shared_buffers" in postgresql.conf is "2". From the website
> http://www.desknow.com/kb/idx/12/061/article/ I notice that shmmax
> shou
Hi,
> Now, I can merrily increase the shared_buffers, but the manual warns
> me against increasing the value too much because it is "per
> transaction" value.
Shared_buffers is not per-transaction. Where did you find this information?
- Sander
---(end of broadcast)
Hi,
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 19, 2007 7:21 PM
Subject: Re: [GENERAL] IP addresses
In article <[EMAIL PROTECTED]>,
"Tom Allison" <[EMAIL PROTECTED]> writes:
I am planning on doing a LOT of work with ip addresses and tho
Hi Tom,
> "Sander Steffann" <[EMAIL PROTECTED]> writes:
> > From: "Harald Fuchs" <[EMAIL PROTECTED]>
> >> Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and be
> happy.
>
> > I would be happy if it would support IPv
Hi,
http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only
apply to single tables, not to their inheritance children. This
is true on both the referencing and re
Hi,
>"A serious limitation of the inheritance feature is that indexes
>(including unique constraints) and foreign key constraints only
>apply to single tables, not to their inheritance children. This
>is true on both the referencing and referenced sides of a foreign
>key constraint."
I would r
Hi,
> I double-checked and realized that we have no servers to
> build 64-bits RPMs for RHEL 4. I've built ones for RHEL 3.0,
> but they may not work for you.
>
> If you can succeed building the RPMs as Joshua guided, please
> let me know and we can upload the binaries to FTP site.
As promised
Hi,
The POSIX timezone notation as understood by the zic code includes
the possibility of
zoneabbrev[+-]hh[:mm[:ss]]
but the meaning is that hh:mm:ss *is* the offset from GMT, and
zoneabbrev is being defined as the abbreviation for that offset.
What the datetime.c code is doing is trying to fi
Hi,
"Sander Steffann" <[EMAIL PROTECTED]> writes:
What the datetime.c code is doing is trying to find the zoneabbrev
in a built-in timezone table, and then adding the two together.
This is simply wacko.
I think that if anyone has ever tried to use this notation they would
ha
Hi,
Sure, but the check digit does not need to be stored, as it can be
regenerated on demand. The user interface just verifies the check
digit, then throws it away.
$ SET GEEZER
$ WRITE SYS$OUTPUT "THAT'S JUST EXTRA CYCLES WASTED BY THE"
$ WRITE SYS$OUTPUT "CLIENT. BETTER TO USE THEM FOR SOME
Hi,
> I want to turn off the default setting in postgres for index
> creation on primary key of a table. Is it possible and how?
That is not possible, because the index is used to guarantee
the uniqueness of the primary key.
What is the reason you want to turn it off?
Sander.
Hi,
I am actually migrating indexes from oracle database to postgres. I wanted
to turn it off so that index on the same columns is not created again
(index created for primary key of a table). I'll probably need to check in
that case and not create the index if it is on the primary key of the
t
Hi,
I would suppliment this with just saying that your controller card is
your performance,
the only cards I've seen score well on linux, and people have
expressed on this list for SCSI are the LSI card, for SATA, LSI, 3ware
(now AMCC) and Areca claim good linux support and seem to work well.
St
Hi,
> How about software RAID?
>
> Linux software RAID appears to perform better than most RAID
> controllers except perhaps those that can do read interleaving
> for RAID1 (I believe some 3ware controllers can do it). Linux
> RAID mirroring doesn't do read interleaving, only read
> balancing, w
Hi,
> Why would you want to do that?
>
> Why not do it an easier way and dump the database and restore it into
> your new database?
>
> There's got to be a lot of stuff to consider when doing something as
> radical as renaming a database.
He is not talking about renaming his database, he is talki
Hi,
> Before anyone can make an rpm for you they will need some more
information.
>
> What type of CPU are you using ? {SPARC, ALPHA, Pentium ...}
>
> What kernel, and libraries are you using?
I will build them for RedHat 6.2 and 7.3 this afternoon. You can find them
in a few hours at http://open
Hi,
> Command Prompt will set up an escrow account online at www.escrow.com.
> When the Escrow account totals 2000.00 and is released, Command Prompt
> will dedicate a programmer for one month to debugging, documenting,
> reviewing, digging, crying, screaming, begging and bleeding with the
> code.
Hi,
> Something is certainly unusual here. Sander, can you rebuild the RH9 set
and
> see why it is so large? For some reason, I missed how many places were in
> there, and missed the fact that there were multiple megabytes difference.
> Debugging symbols or no, this is big.
The difference in si
Hi,
It turns out that preventing RH9 from building the debuginfo package also
prevented it from stripping the binaries. This was what caused the big
difference in filesize. I have rebuilt the RPMs for RH9 and put them on
http://opensource.nederland.net/.
I had to make a small modification to the
Hi Lamar,
> I was afraid you'd say that. :-) As long as I can get questions
> answered here about the gory details, and without laughing too hard at
> my missteps, I'll see if I can tackle this.
I think you would make a lot of people very happy with this!
Sander.
Hi,
> On Sat, Apr 07, 2001 at 01:46:48PM -0400, Doug McNaught wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >
> > > Doug McNaught writes:
> > >
> > > > Doing this would almost certainly result in a corrupted database
once
> > > > you ran up against the limit.
> > >
> > > I think you c
25 matches
Mail list logo
