Re: [GENERAL] Sequencial scan over primary keys

2000-11-10 Thread Igor Roboul
y_key_field'. I think. -- Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://www.brainbench.com/transcript.jsp?pid=304744

Re: [GENERAL] Increasing the number of semaphores on FreeBSD 4.1 (clarification)

2000-11-10 Thread Igor Roboul
ern.ipc.shmmni: 96 kern.ipc.shmseg: 64 kern.ipc.shmall: 1024 kern.ipc.shm_use_phys: 0 -- Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://www.brainbench.com/transcript.jsp?pid=304744

Re: [GENERAL] Large objects

2000-11-02 Thread Igor Roboul
On Thu, Nov 02, 2000 at 02:39:54PM +0300, Igor Roboul wrote: > On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote: > > Except on case... When you would like to be sure in transaction safety... > Ok, but not for image galery. I have answered on argument about transaction

Re: [GENERAL] Large objects

2000-11-02 Thread Igor Roboul
On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote: > Except on case... When you would like to be sure in transaction safety... Ok, but not for image galery. -- Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://w

Re: [GENERAL] SQL question - problem with INTERSECT

2000-10-31 Thread Igor Roboul
quot; Try removing first "GROUP BY messages.msgid HAVING count(messages.msgid)=2)" -- Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://www.brainbench.com/transcript.jsp?pid=304744

Re: [GENERAL] A question about PL/pgSQL

2000-10-27 Thread Igor Roboul
ink(cnt,fid,wid) values(1,v_fid,v_wid);" inserts new record, or just adds 1 to counter. -- Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://www.brainbench.com/transcript.jsp?pid=304744

Re: [GENERAL] CPU killer

2000-10-27 Thread Igor Roboul
On Fri, Oct 27, 2000 at 07:12:57PM -0200, Vilson farias wrote: >I start postgres with these params: su -l postgres -c > '/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' &. Try starting postmaster with 'nice': nice /usr/bin/postmaster -B 2048

Re: [GENERAL] timestamp?

2000-10-27 Thread Igor Roboul
On Fri, Oct 27, 2000 at 03:01:31PM -0400, Tom Lane wrote: > This gives you back an integer number of seconds per Unix conventions, > which you just use atoi() on. For example: > > regression=# select date_part('epoch', now()); Thanx -- Igor Roboul, Unix System Admi