Re: [PERFORM] Is There Any Way ....

2005-10-04 Thread Stefan Weiss
On 2005-09-30 01:21, Lane Van Ingen wrote: > (3) Assure that a disk-based table is always in memory (outside of keeping > it in > memory buffers as a result of frequent activity which would prevent > LRU > operations from taking it out) ? I was wondering about this too. IMO it would

Re: [PERFORM] Querying 19million records very slowly

2005-06-22 Thread Stefan Weiss
On 2005-06-22 10:55, Michael Glaesemann wrote: > There has been discussion in the past on storing the time zone name > with the timestamptz as well, though no one has implemented this yet. The reason for this may be that time zone names (abbreviations) are not unique. For example, "ECT" can mean

Re: [PERFORM] plperl vs plpgsql

2005-04-17 Thread Stefan Weiss
On 2005-04-17 14:56, Alex wrote: > Is there a performance difference between the two? As Christopher already pointed out, it depends on what you want to do. If you're doing some complex string processing, it will be easier (and in some cases) faster to do in plperl, if you're mainly dealing with s

Re: [PERFORM] Reading recommendations

2005-03-31 Thread Stefan Weiss
On 2005-03-31 15:19, [EMAIL PROTECTED] wrote: >> >>Now *that* I want to see. Aught to be at least as interesting >> >>as the "TCP/IP over carrier pigeon" experiment - and more >> >>challenging to boot! .. > Interestingly, we had a follow on contract to investigate routing > optimization using floo

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread Stefan Weiss
sarlav kumar wrote, On 2004-12-20 15:40: > I would like to do a pg_dump on the test database, and restore it in > the new database on Postgres 7.4.6. I would like to know if there > would be any problem due to the postgres version/OS change. If so, > could someone tell me what precautions I can tak