Re: [ADMIN] Removing OIDs

2004-02-03 Thread Marek Lewczuk
Sam Barnett-Cormack wrote: Is there any way to remove OIDs from an existing table, or even a whole database? I never use the damn things and my database is big, so I'd like to do anything I can to shrink it. Also, are there any performance implications to this? I'm currently using 7.3.4, but will

[ADMIN] plperl loading

2004-12-13 Thread Marek Lewczuk
Hi, I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build plperl into postgresql source ? Thanks i

Re: [ADMIN] plperl loading

2004-12-13 Thread Marek Lewczuk
Joe Conway napisaÅ(a): Marek Lewczuk wrote: I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or ma

Re: [ADMIN] too slow

2005-02-09 Thread Marek Lewczuk
Shashi Gireddy napisaÅ(a): I recently migrated from MySql, The database size in mysql was 1.4GB (It is a static database). It generated a dump file (.sql) of size 8GB), It took 2days to import the whole thing into postgres. After all the response from postgres is a disaster. It took 40sec's to run