Re: [GENERAL] Speed of postgres compared to ms sql, is this

From: novnov [mailto:[EMAIL PROTECTED]To: pgsql-general@postgresql.orgSent: Sat, 11 Nov 2006 20:15:08 -0500Subject: Re: [GENERAL] Speed of postgres compared to ms sql, is this I agree with what you say. And I'd still be interesting in hearing of first hand experience with the speed of the two d

Re: [GENERAL] Can PostgreSQL reside on the same server as MSDE?

[EMAIL PROTECTED] wrote: Any issues with running PostgreSQL on a Windows 2003 server that already has Microsoft SQL Server Desktop Engine? What about with MS SQL Server? No issues on Windows XP, 2003 Server should be similar. -- P. J. "Josh" Rovero

[GENERAL] PostgreSQL and EnterpriseDB in New York Times

Thomas Friedman (NYT editorial writer) mentions PostgreSQL and EnterpriseDB in his column (published today in syndication in the hinterlands) about how outsourcing is helping the economies in many places. ---(end of broadcast)--- TIP 4: Have you se

[GENERAL] Intel Duo Issues

I searched the archives looking for something definitive related to Postgresql on Windows XP with Intel Duo. We loaded postgresql 8.0.3 on a Dell with T2600 processor, Intel Duo at 2.16 GHz. It wasn't long after a copy of our production DB was loaded that numerous connection and "not a socket" e

Re: [GENERAL] [SQL] Flight numbers data

We built an operational flight tracking and weather system that uses Postgresql, http://www.sonalysts.com/wXstation One data feed (FAA ASDI) uses both aircraft registration numbers (tail numbers) and airline-assigned flight numbers. Typically if you have the latter, you won't get the former.

Re: [GENERAL] Licensing of .DLL files

None of these licenses prohibit distribution, AFAIK. You may have to offer source, etc. We normally just bundle all source tar files for similar components that we distribute with our code. Dave Page wrote: On 20/3/06 13:17, "Vladimira Nitrova" <[EMAIL PROTECTED]> wrote: Hello, We'd lik

Re: [GENERAL] pgsql and streams

Chris Condit wrote:I'm new to Postgres and have a question about bulk loading from streams.I know that I can bulk load from a file using COPY. Is it possible touse a stream instead of a file? If so, and I limited to stdin? I'mattempting to stream data from a remote database into my Postgresi

Re: [GENERAL] Postgres in government

The NOAA National Data Buoy Center is a government customer (there are many commercial customers) for our wXstation(R) product, which uses PostgreSQL as its database. The number of government customers may increase dramatically in the near future. -- P. J. "Josh&qu

Re: [GENERAL] Postgresql and Athlon64 ?

or someone personal experience ? Or should I stay in 32 bit platform for a while ? -- P. J. "Josh" Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3671 or 442-4355

Re: [GENERAL] Performance tuning on RedHat Enterprise Linux 3

I'm all for that. But I doubt there are any quick-hack improvements to be had here. regards, tom lane -- P. J. "Josh" Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3671 or 442-435

Re: [GENERAL] Reuse of Subselects

...) FROM table1; do I really have to rewrite the subselect a 2nd time if I need that result in another column's expression? -- P. J. "Josh" Rovero Sonalysts, Inc. Email: [EMAIL PROTECTED]www.sonalysts.com215 Parkway North Work: (860)326-3

[GENERAL] Glacial deletes (fixed), now glacial lo vacuum

eems to be spawned. The current psql session seems to disconnect (no more messages), while a "tail -f postmaster.log" shows the vacuum proceeding to the other tables. select version(); PostgreSQL 7.1.2 on hppa2.0-hp-hpux10.20, compiled by GCC 2.95.3 --

[GENERAL] glacial deletes (long)

137 :opid 184 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ 0 51 18 -6 ] })})) :indxorderdir 1 } NOTICE: QUERY PLAN: Index Scan us