Re: [GENERAL] Tuning Postgres for single user manipulating large amounts of data

2010-12-09 Thread Paul Taylor
On 09/12/2010 15:51, t...@fuzzy.cz wrote: Hi, Im using Postgres 8.3 on a Macbook Pro Labtop. I using the database with just one db connection to build a lucene search index from some of the data, and Im trying to improve performance. The key thing is that I'm only a single user but manipulating l

Re: [GENERAL] Tuning Postgres for single user manipulating large amounts of data

2010-12-09 Thread Paul Taylor
On 09/12/2010 15:12, Reid Thompson wrote: On 12/09/2010 09:59 AM, Andy Colson wrote: On 12/9/2010 8:50 AM, Andy Colson wrote: On 12/9/2010 6:25 AM, Paul Taylor wrote: You need to bump up your SHMMAX is your OS. sorry: SHMMAX _in_ your OS. its an OS setting not a PG one. -Andy scroll down

[GENERAL] Tuning Postgres for single user manipulating large amounts of data

2010-12-09 Thread Paul Taylor
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop. I using the database with just one db connection to build a lucene search index from some of the data, and Im trying to improve performance. The key thing is that I'm only a single user but manipulating large amounts of data , i.e processing ta

[GENERAL] Tuning Postgres for single user manipulating large amounts of data

2010-12-09 Thread Paul Taylor
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop. I using the database with just one db connection to build a lucene search index from some of the data, and Im trying to improve performance. The key thing is that I'm only a single user but manipulating large amounts of data , i.e processing ta

[GENERAL] Can you check in SQL if a fields can be encoded using specified charset

2010-11-12 Thread Paul Taylor
Is there a function that can say whether a textvalue can be encoded in a particular charset i.e. SELECT FIELD1 FROM TABLE1 WHERE ENCODE_AS_IS08859(FIELD1)=true thanks Paul -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-05 Thread Paul Taylor
Sam Mason wrote: On Wed, Aug 05, 2009 at 08:02:13AM -0400, Bill Moran wrote: In response to Paul Taylor : this is an opensource project and to enable others to contribute easily it is much easier if they can download the code and run mvn package to compile and test. Once you start

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Guy Rouillier wrote: Paul Taylor wrote: I am testing the code that extracts information from a read only database. These are UNIT tests so only interested in getting the right results given a particular set of data, anything else is a distraction. I don't understand your test enviro

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Bill Moran wrote: In response to Paul Taylor : Bill Moran wrote: Then replace the DB client class with a class that returns fabricated data for the purpose of your test. Won't work because I am writing SQL and I want to test the SQL is correct Well, be warned

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Bill Moran wrote: In response to Paul Taylor : Bill Moran wrote: In response to Paul Taylor : Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Thomas Kellerer wrote: Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you will

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Bayless Kirtley wrote: Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Bill Moran wrote: In response to Paul Taylor : Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby database does ? No, and I think the consensus is that this

[GENERAL] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Paul Taylor
Hi Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby database does ? Paul -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po