Re: [GENERAL] [pgsql-advocacy] European users mailing list
Dave Page wrote: > As discussed at the first meeting of what will become the European > PostgreSQL Users Group after pgDay in Prato, we now have a mailing > list setup at [EMAIL PROTECTED] > > This is for the European users group, so is not really intended as a > technical list but as a place to discuss events, advocacy and other > topics relevant to our work in Europe. If it's not a general list, why did you name it "general"? That will certainly cause confusion. It sounds like -eu-advocacy might have been better. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] locale and performance?
Daniel Weinand wrote: > it isn't acceptable to use the database without indexes if another > locale is used. are custom operator classes as described in the > manual as high-performance as the native index? I'm not sure what you are comparing here, because the different operator classes serve different use cases. The operator classes are as fast as they can be to solve the problem at hand. Whether they are fast enough for you is up to your testing. > are there any examples how to use them in my case? Perhaps, but you didn't tell us what your case is. > are there any tests that show how the performance decreases if > another locale is used? why is there a perfomance impact? Because having a computer sort letters in an order useful for humans is slower than sorting them in an order useful for computers. And vice versa! > it's a > disappointing that postgresql is only in one configuration to suply > the max. performance. That is nonsense. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] [pgsql-advocacy] European users mailing list
> --- Original Message --- > From: Peter Eisentraut <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: 29/07/07, 14:37:57 > Subject: Re: [pgsql-advocacy] European users mailing list > > Dave Page wrote: > > As discussed at the first meeting of what will become the European > > PostgreSQL Users Group after pgDay in Prato, we now have a mailing > > list setup at [EMAIL PROTECTED] > > > > This is for the European users group, so is not really intended as a > > technical list but as a place to discuss events, advocacy and other > > topics relevant to our work in Europe. > > If it's not a general list, why did you name it "general"? That will > certainly cause confusion. It sounds like -eu-advocacy might have been > better. Who said it wasn't 'general'? I said it wasn't intended to be technical, but that's because technical issues are rarely region specific. That doesn't mean there aren't a variety of other general topics we might discuss. /D ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] The leanest, meanest Windows installer possible
On 7/28/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > Hi all. I'm looking at distributing PostgreSQL with a desktop > application and have a couple of what might be simple questions. > > I've been using PG for years and years but bringing it to the Win32 > desktop presents some deployment challenges. Since this software will > be downloaded I am looking for the smallest possible installer that > provides the functionality I'm looking for. Currently the whole > application (including the SQLite library that it's using now) is only > about 4 megs. The 20+ meg installer is awesome in it's functionality > but I won't be using most of what is contained in it (docs, language > drivers, etc). Is there a smaller "bare essentials" MSI installer that > provides an easy interface for setting things like the admin password > and the non-privileged service user addition but that contains only > the required EXEs and DLLs? Or perhaps a way for me to take the MSI > installer and strip out the things I won't be needing? Well, it's possible to install postgresql on windows using only a batch file, plus a couple of small utilities like 'ntrights.exe' and possibly 'sanur.exe' to do some things which are difficult from the command prompt. You can use the built in net command to do user management and pg_ctl.exe can handle creation of the service and bootstrap the database yourself with runas/initdb.exe. This would add a few kb to the required files which are the in the lib, bin, and share folders iirc. Also, if you don't have any ssl requirements you can recompile the database without ssl...ditto contrib. This is a medium difficulty exercise and you have to test with all versions of windows you plan to deploy on (watch out for things like password policies, etc). Also remember you can run the standard installer in silent mode. I think in the long run this is probably a better idea than what you are thinking about doing... merlin ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] The leanest, meanest Windows installer possible
> On 7/28/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > Also remember you can run the standard installer in silent mode. I > think in the long run this is probably a better idea than what you are > thinking about doing... Yes, what I'm looking for is a way to reduce the size of the MSI installer. Since it's been tested I'd sure like to use it but deploying 20+ megs of additional software with a 4 meg program is prohibitive right now. Thanks! -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] The leanest, meanest Windows installer possible
Now that I think of it, shouldn't everything that is needed to build the .MSI installer be in one of the source packages? As a user of InnoSetup I'm afraid I'm clueless about MSI, so if someone could shove me in the right direction I'd sure appreciate it! > On 7/28/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > > Hi all. I'm looking at distributing PostgreSQL with a desktop > > application and have a couple of what might be simple questions. > > > > I've been using PG for years and years but bringing it to the Win32 > > desktop presents some deployment challenges. Since this software will > > be downloaded I am looking for the smallest possible installer that > > provides the functionality I'm looking for. Currently the whole > > application (including the SQLite library that it's using now) is only > > about 4 megs. The 20+ meg installer is awesome in it's functionality > > but I won't be using most of what is contained in it (docs, language > > drivers, etc). Is there a smaller "bare essentials" MSI installer that > > provides an easy interface for setting things like the admin password > > and the non-privileged service user addition but that contains only > > the required EXEs and DLLs? Or perhaps a way for me to take the MSI > > installer and strip out the things I won't be needing? > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] The leanest, meanest Windows installer possible
Mitchell Vincent wrote: > Now that I think of it, shouldn't everything that is needed to build > the .MSI installer be in one of the source packages? As a user of > InnoSetup I'm afraid I'm clueless about MSI, so if someone could shove > me in the right direction I'd sure appreciate it! All that's needed is certainly in the pginstaller package. Or rather, it's either there or in one of the packages referenced by the documentation for that one (we don't actually ship a "source package"). You can find the source for the installer on http://pgfoundry.org/projects/pginstaller. //Magnus ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] The leanest, meanest Windows installer possible
Mitchell Vincent wrote: > Ah, I see what you mean. > > I was hoping to be able to rebuild the MSI to not include the things I > didn't need but that doesn't look like it's going to be the case > Humbug.. Is there any way at all to modify what's contained in the MSI > file so I can shrink the distribution size of the windows installer > package? Yes, you need to modify the wxs/pginst.wxs file - it lists what's included in the package. //Magnus ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] [pgsql-advocacy] European users mailing list
Peter Eisentraut wrote: Dave Page wrote: As discussed at the first meeting of what will become the European PostgreSQL Users Group after pgDay in Prato, we now have a mailing list setup at [EMAIL PROTECTED] This is for the European users group, so is not really intended as a technical list but as a place to discuss events, advocacy and other topics relevant to our work in Europe. If it's not a general list, why did you name it "general"? That will certainly cause confusion. It sounds like -eu-advocacy might have been better. +1 -eu-advocacy seems to make more sense. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
