Re: [HACKERS] MS SQL features for new version

2004-02-10 Thread Keith Bottner
Can't they just let the old index continue to work while generating the new index and then after the new index is created switch? I know the details are more complex but what would be the factor(s) preventing this? Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: [HACKERS] MS SQL features for new version

2004-02-10 Thread Keith Bottner
Yes MS tools for MS SQL have always been there strong point. Easy to get started and get things going quickly. I on the other hand have never ran into a lack of flexibility with the client APIs or the stored procedure syntax. In all cases I have encountered we have turned away from MS SQL because

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-09 Thread Keith Bottner
m and more specifically mine, adding another layer at the organizational/app level will not provide the level of functionality that is required. Regards, Keith -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 9:54 AM To: Keith Bottner Cc: &#

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-09 Thread Keith Bottner
Alex, I agree that this is something that is worth spending time on. This resembles the Oracle RAC (Real Application Cluster). While other people may feel that the amount of data is unreasonable I have a similar problem that will only be solved using such a solution. In regards to how your databa

[HACKERS] planner, how difficult to ...

2004-01-05 Thread Keith Bottner
Title: Message I have been working with Postgres for just a short while, however, we are looking to use Postgres for our next project and I was hoping someone could answer a question for me regarding the planner to save me some research time.   How integrated is the planner into the database

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Keith Bottner
It would be interesting to have a JBoss, PostgreSQL and the JDBC driver for PostgreSQL all bundled together in a single installation script. Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivelin Ivanov Sent: Tuesday, December 09, 2003 9:16 AM To: [

Re: [HACKERS] Threads vs Processes

2003-09-25 Thread Keith Bottner
Actually you can use a DLL with LoadLibrary as long as you do the following. When a process uses load-time linking with this DLL, the entry-point function is sufficient to manage the thread local storage. Problems can occur with a process that uses run-time linking because the entry-point function

Re: [HACKERS] Threads vs Processes (was: NuSphere and PostgreSQL for windows)

2003-09-25 Thread Keith Bottner
helps. Keith -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: Keith Bottner Cc: 'Tom Lane'; 'Claudio Natoli'; 'Robert Treat'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Thre

Re: [HACKERS] Threads vs Processes (was: NuSphere and PostgreSQL for windows)

2003-09-25 Thread Keith Bottner
Typically variables that you want to be per-thread are stored in what Microsoft calls Thread Local Storage (TLS). Variables that you want shared you can just treat as globals and statics with the appropriate threading synchronization primitives. With Windows 2000 and later you have up to 1088 TLS l