Re: [GENERAL] Problem in converting int to timestamp value - why?

2004-09-19 Thread Soeren Gerlach
Mike, thanks for pointing me to the "Template Pattern Modifier" ,-)) I've just found it in the doc with your help and it works now perfectly. Thanks, Soeren > On Sun, Sep 19, 2004 at 04:17:52PM +0200, Soeren Gerlach wrote: > > > I've an integer column i

[GENERAL] Problem in converting int to timestamp value - why?

2004-09-19 Thread Soeren Gerlach
' 99 99'), ' MM DD') results in a timestamp "2171-11-05 22:00:00" ??? The int-to-char conversion works well ("2004 12 17") but the to_timestamp() doesn't work as expected - why? I&#x

Re: [GENERAL] Enough RAM for entire Database.. cost aside, is this going to be fastest?

2004-07-03 Thread Soeren Gerlach
h Postgres but more with a general approach. If you decide to switch from Linux to Solaris (or other way round) in some time you get likely lots of work to do if you now stay to a specific solution. Best regards, Soeren Gerlach ---(end of broadcast)-

Re: [GENERAL] Slow dump with pg_dump/pg_restore ? How to improve ?

2004-07-01 Thread Soeren Gerlach
> Soeren Gerlach <[EMAIL PROTECTED]> writes: > > * pg_dump takes 2/3 of the [single] CPU, postmaster the other 1/3 for > > both dumps > > Really!? Hmm, that seems fairly backwards ... thinks ... > > In the -Fc case this makes some amount of sense because pg_dump

[GENERAL] Slow dump with pg_dump/pg_restore ? How to improve ?

2004-06-29 Thread Soeren Gerlach
= 3 sort_mem = 1000 vacuum_mem = 16384 What is the best starting point to look at? I'm sure I'm doing something badly wrong but neither the docs nor some older mails from this group seem to offer a hint to me. Thanks a lot, Soeren Gerlach --