Re: [GENERAL] SELECT DISTINCT performance issue

2005-06-04 Thread Tom Lane
K C Lau <[EMAIL PROTECTED]> writes: > esdt=> explain analyze select DISTINCT ON (PlayerID) PlayerID,AtDate from > Player > where PlayerID='0' order by PlayerID desc, AtDate desc; > Unique (cost=0.00..2507.66 rows=1 width=23) (actual time=0.000..187.000 > rows=1 loops=1) > -> Index S

[GENERAL] SELECT DISTINCT performance issue

2005-06-04 Thread K C Lau
Hi All, We are testing PostgreSQL 8.0.3 on MS Windows for porting an OLTP system from MS SqlServer. We got a major performance issue which seems to boil down to the following type of query: select DISTINCT ON (PlayerID) PlayerID,AtDate from Player where PlayerID='0' order by PlayerID

Re: [GENERAL] Rollback on Error

2005-06-04 Thread Bruce Momjian
This has already been implemented in CVS as a psql \set variable: ON_ERROR_ROLLBACK = 'interactive' and will appear in 8.1. --- Michael Paesold wrote: > Tom Lane wrote: > > > "Michael Paesold" <[EMAIL PROTECTED]>

Re: [GENERAL] Limits of SQL

2005-06-04 Thread Bruno Wolff III
On Sat, Jun 04, 2005 at 21:53:24 +0200, Joachim Zobel <[EMAIL PROTECTED]> wrote: > Am Samstag, den 04.06.2005, 07:38 -0500 schrieb Bruno Wolff III: > > On Sat, Jun 04, 2005 at 11:31:02 +0200, > > Joachim Zobel <[EMAIL PROTECTED]> wrote: > > > > > > ... And it seems that > > > a plain SELECT th

Re: [GENERAL] Limits of SQL

2005-06-04 Thread Joachim Zobel
Am Samstag, den 04.06.2005, 07:38 -0500 schrieb Bruno Wolff III: > On Sat, Jun 04, 2005 at 11:31:02 +0200, > Joachim Zobel <[EMAIL PROTECTED]> wrote: > > > > ... And it seems that > > a plain SELECT that tells me if a path exists is not possible... > > When 'WITH' gets implemented then you shou

Re: [GENERAL] postgresql books

2005-06-04 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: > "Gevik babakhani" <[EMAIL PROTECTED]> wrote: > >> Beside the documentation, which pg book would you recommend? Which one is >> your personal favorite pg book? > > I saw an O'Reilly book [1] this afternoon at a bookshop here in

Re: [GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Magnus Hagander
Title: Message The link is on http://www.openssl.org/related/binaries.html, and it points to http://www.slproweb.com/products/Win32OpenSSL.html. Which has the required download links. You want version 0.9.7g.   //Magnus -Original Message-From: Jon Christian Ottersen [mailto:

Re: [GENERAL] Old problem needs solution

2005-06-04 Thread Gerald D. Anderson
Ok, that did it. All fixed up and upgraded to 8. The command for gentoo to rebuild WITH the pg-hier patch is (for those that might see this question again): # USE="pg-hier" emerge "=postgresql-7.4.7-r2" -vD # or whatever latest 7.x version is at that time. Backup the data, etc. Then whe

Re: [GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Jon Christian Ottersen
Title: Message Sorry, I am a bit newbie to this. I am not able to find links to these files on the openssl web pages. I have tried searhing the internet, and find a lot of places to dowload them, but mostly without information about the version number and seldom the two files at the same p

Re: [GENERAL] PostgreSQL vs. InnoDB performance

2005-06-04 Thread Zlatko Calusic
Scott Marlowe <[EMAIL PROTECTED]> writes: > Also, I wonder how well both databases will survive having power removed > while under heavy load... It depends more on the underlying hardware setup (disk/raid array) than on the any other aspect (like OS). Assuming you have fsync enabled, of course.

Re: [GENERAL] PostgreSQL vs. InnoDB performance

2005-06-04 Thread Zlatko Calusic
Christopher Browne <[EMAIL PROTECTED]> writes: > After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Marco Colombo) > belched out: >> On Fri, 2005-06-03 at 11:38 +0200, Peter Eisentraut wrote: >>> Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut: >>> > On a particular system, load

Re: [GENERAL] Limits of SQL

2005-06-04 Thread Bruno Wolff III
On Sat, Jun 04, 2005 at 11:31:02 +0200, Joachim Zobel <[EMAIL PROTECTED]> wrote: > > These are both things I want to avoid. I am not trying to solve a real > world problem, I want to understand the limits of SQL. And it seems that > a plain SELECT that tells me if a path exists is not possible.

Re: [GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Magnus Hagander
Title: Message Just get the latest openssl binary download from their site (linked from their site, that is, I think their main site only carries source) and just copy over the file. Make sure you replace *both* openssl DLLs - ilbeay32.dll and ssleay32.dll - they should always be the same ve

Re: [GENERAL] Limits of SQL

2005-06-04 Thread Joachim Zobel
Am Donnerstag, den 02.06.2005, 12:46 -0700 schrieb Ben: > You mean, you want to be able to say something like: > > select isConnected(a,b) > > and get back a true/false, or maybe the path? > > That seems quite doable in SQL, assuming you either store those results > and simply use sql to retrie

[GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Jon Christian Ottersen
Dear friends,   After having installed Crystal Reports on my machine, I get the following error message trying to open PgAdminIII: “The ordinal 2821 could not be located in the dynamic link library LIBEAY32.dll.”   A search on the pgsql-mailing lists indicates that CR has overwritten m