On Oct 16, 2007, at 10:22 AM, Richard Huxton wrote:
Add some lines to /etc/security/limits.conf to increase them.
Sorry for being somewhat of a linux novice -- but what is the best
way to do this? It doesn't seem to provide matching options from
ulimit to the limits.conf file.
Thanks,
Ja
) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 100
virtual memory (kbytes, -v) 20
file locks (-x) unlimited
--
Jason Lustig
Israel: 054-231-8476
U.S.: 716-228-8729
Skype: jasonlustig
On Oct 16, 2007, at 10:01 AM, Richard Huxton
would be doing something without a username or database? Or is that
just how autovacuum works?
Thanks,
Jason
--
Jason Lustig
Israel: 054-231-8476
U.S.: 716-228-8729
Skype: jasonlustig
On Oct 16, 2007, at 8:23 AM, Richard Huxton wrote:
Jason Lustig wrote:
There isn't any more error mes
5.
Jason
--
Jason Lustig
CTO, MavenHaven Inc.
www.mavenhaven.com
Where the Community Finds Wisdom
Israel: 054-231-8476
U.S.: 716-228-8729
Skype: jasonlustig
On Oct 16, 2007, at 7:45 AM, Richard Huxton wrote:
Not really a performance question, but...
Jason Lustig wrote:
Whenever I turn
Whenever I turn on Autovacuum on my database, I get a ton of error
messages like this in my Postgres log:
Oct 16 06:43:47 [2897]: [1-1] user=,db= ERROR: out of memory
Oct 16 06:43:47 [2897]: [1-2] user=,db= DETAIL: Failed on request
of size 524287998.
It always fails on the same request
I have some questions about the performance of certain types of SQL
statements.
What sort of speed increase is there usually with binding parameters
(and thus preparing statements) v. straight sql with interpolated
variables? Will Postgresql realize that the following queries are
effectiv
ly fantastic to see the
community here! I've got a lot of database experience (mostly with ms
sql and mysql) but this is my first time doing serious work with
postgres and it's really a great system with great people too.
Jason
On Apr 12, 2007, at 11:35 AM, Jeff Frost wrote:
On Th
Hello all,
My website has been having issues with our new Linux/PostgreSQL
server being somewhat slow. I have done tests using Apache Benchmark
and for pages that do not connect to Postgres, the speeds are much
faster (334 requests/second v. 1-2 requests/second), so it seems that
Postgres
