Re: FW: [ADMIN] Server Time Setting

2005-09-14 Thread Tom Lane
"Lane Van Ingen" <[EMAIL PROTECTED]> writes: > Is there anyone who knows the answer as to why now() is delivering a > different time answer than Windows? pgsql-hackers-win32 might be the place to ask this. regards, tom lane ---(end of broadcast)---

FW: [ADMIN] Server Time Setting

2005-09-14 Thread Lane Van Ingen
Is there anyone who knows the answer as to why now() is delivering a different time answer than Windows? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, September 12, 2005 6:42 PM To: Lane Van Ingen Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Server Time S

Re: [ADMIN]

2005-09-14 Thread hubert depesz lubaczewski
On 9/13/05, Yossi Kachlon <[EMAIL PROTECTED]> wrote:  – Does PostgeSql support partitions and/or partition views? not yet. but usually using partial indices works as well. usually. not always.   2- I tried to install two installations of PostgreSql on windows-2000 and after the first

Re: [ADMIN] Disabling WAL for bulk data loads

2005-09-14 Thread Tom Lane
William Yu <[EMAIL PROTECTED]> writes: > If you have enough memory, you can always make a ramdisk to store the > WAL temporarily while you bulk load data. I also temporarily alter the > config to set checkpoint_segments = 1 to use as few pg_xlog files as > possible. Really? That seems pretty c

Re: [ADMIN] Disabling WAL for bulk data loads

2005-09-14 Thread William Yu
Tom Lane wrote: William Yu <[EMAIL PROTECTED]> writes: If you have enough memory, you can always make a ramdisk to store the WAL temporarily while you bulk load data. I also temporarily alter the config to set checkpoint_segments = 1 to use as few pg_xlog files as possible. Really? That s

Re: [ADMIN] Disabling WAL for bulk data loads

2005-09-14 Thread William Yu
Kevin Keith wrote: I am coming from an Oracle background - which in the case of bulk data loads there were several options I had where I could disable writing to the redo log to speed up the bulk data load (i.e. direct load, set the user session in no archive logging, set the affected tables to

Re: [ADMIN] plperl again but different problem

2005-09-14 Thread David
On Tue, Sep 13, 2005 at 05:17:55PM +0200, Marcin Giedz wrote: > Dnia wtorek, 13 wrze??nia 2005 17:01, Marcin Giedz napisa??: > > Additional info: I've also checked plperl with postgresql snapshot - problem > still exists ;( - > > didn't anyone have something similar? or maybe I'm only one who u