I have to do a multicolumn self-join to find the median. I am using postgres
8.2. How do I force postgres to use an index scan? I have a multicolumn
index but postgres is not using it.
Query
explain select e.time
from page_view e, page_view d
where e.test_
capability(only C/C++) and the name size limitation was a killer.
Steve
--- Original Message ---
From: "Stephen Ince" <[EMAIL PROTECTED]>
To: "Tony Caduto" <[EMAIL PROTECTED]>, "Greg Smith"
<[EMAIL PROTECTED]>, pgsql-general@postgresql.org
From: "Tony Caduto" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, August 27, 2007 12:47 PM
Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished
Stephen Ince wrote:
Postgres can't be embedded or serverless. Firebird has the embedded
feature. Most of the data
Postgres can't be embedded or serverless. Firebird has the embedded feature.
Most of the databases have this capability (hsqldb, derby,oracle,mysql,
firebird, and db2). Derby and hsqldb are the only free embedded databases
for commercial use.
I recently ported a schema from postgres to firebir
Hi. I am new to postgres. I would like some advise on how to get a minimum
postgres installation. I want to use postgres embedded in application on
windows.
I have done the following.
C:\Program Files\PostgreSQL>msiexec /i postgresql-8.2-int.msi /qr
INTERNALLAUNCH=1 ADDLOCAL=server,psql SERV
Hi. I am new to postgres and I am porting an application to windows that is
using postgresql as it's backend. I am also trying to do a silent install
of postgres. I would also like to install postgres on a usb thumbdrive. It
is just for demo purposes.
1) Can you have more than one instance of
