[ADMIN] Memory bloating

2000-10-09 Thread Micah Anderson
Hello, We are using postgresql exclusively for our database backend for a high-traffic site, sustaining 3-4 pages per second, in many cases bursting well over that. At least half of those accesses are pgsql SELECT, we rarely, if at all, use DELETE. It seems worst on tables with more than about 10

[ADMIN] help

2000-10-09 Thread Sonika Malhotra
please help in starting the postmaster and keeping it in the same state always ..ie started , i'm a beginner, i tried pg_ctl,postmaster,postgres... my database is kept in a dir where permission is denied to the user , and if i login as the superuser, it doesn't recognize above commands..

Re: [ADMIN] Memory bloating

2000-10-09 Thread Jean-Marc Pigeon
Bonjour Micah Anderson > > Hello, > > We are using postgresql exclusively for our database backend for a > high-traffic site, sustaining 3-4 pages per second, in many cases > bursting well over that. At least half of those accesses are pgsql > SELECT, we rarely, if at all, use DELETE. It seems w

[GENERAL] PostgreSQL encoding question

2000-10-09 Thread Anton Kalauzky
Dear friends, I have two PC's with exactly the same configurations - one in my office and the other at home. They are running RedHat Linux 6.2 and PostgreSQL included in distribution. The first one I recently installed by upgrading from Linux 6.1 and the for the second one I went through full

[ADMIN] timestamp data type and null value

2000-10-09 Thread William L James
Hello there: I am trying to move one of our databases from MS SQL to PostgreSQL and having trouble. One of our table columns is a timestamp type and the contents in MS SQL is nulls. When defined for PostgreSQL, I specifically did not include the "NOT NULL" attribute to this column, but when we

[ADMIN] postmaster(8760): unaligned trap

2000-10-09 Thread Christian Rossi
Hi, I've posgresSQL on linux RH6.1 apha workstation When I connect to db (even in psql than in PGconnectdb) I fond the kernel message: kernel: postmaster(8484): unaligned trap at 00012013e320: 00011fff9e31 28 1 kernel: postmaster(8484): unaligned trap at 00012013e320: 00011fff9e32

[ADMIN] Re: [GENERAL] PostgreSQL encoding question

2000-10-09 Thread Gunnar R|nning
"Anton Kalauzky" <[EMAIL PROTECTED]> writes: > Dear friends, > > I have two PC's with exactly the same configurations - one in my office and > the other at home. They are running RedHat Linux 6.2 and PostgreSQL included > in distribution. The first one I recently installed by upgrading from Li