I think you are missing something. Threads and processes, to a great
extent are 6 of one and half a dozen of the other. Postgres uses
multiple processes accessing a shared memory area. A multithreaded
database would use multiple threads accessing a shared memory area. In
most OSes, threads and pro
Hi,
I am really impressed with the features of PostgreSQL but am wondering if we
should use this product for our project. We have tried several databases
(MySQL, Sybase ASE, Sybase ASA) and we are now looking at PostgreSQL before
releasing our service on the Internet.
My concern comes from the f
On Wed, 14 Jul 1999, Albert Chen wrote:
> I want to search my database table named ex, whose the attribute is
> subject,
> and list the results that matches the keyword 'electric'.
> I run the SQL command: SELECT subject FROM ex WHERE subject='*electric*';
use one of the following:
select subj
Hi,
I want to search my database table named ex, whose the attribute is
subject,
and list the results that matches the keyword 'electric'.
I run the SQL command: SELECT subject FROM ex WHERE subject='*electric*';
Appearently, it doesn't work. Would anyone know how to do, thanks in
advance.
Hey,
More info on the index problem.
I fixed the previous problem by doing a pg_upgrade and all that stuff.
Now explain actually says it's using indices and whatnot.
But now I'm having a different but related problem.
Now, If I do a select on one field, everything is all good and indices are
bein
Hi,
I'm still having this same problem.
Below is a simple test to show the problem.
Same table as before, but I removed all indices except the itemid
field(serial).
Thanks,
Ole Gjerde
parts=> create index av_parts_nsn_index on av_parts(nsn);
CREATE
parts=> explain select * from av_parts where ns
Package: postgresql-contrib
Version: 6.5-2
I wonder whether anybody on the postgresql lists can reproduce the
following problem:
Cascaded updates tend to write old data on top of new, as the following
minimalistic example shows:
CREATE TABLE "tipos" (
"tipo" text NOT NULL,
"desi
On Wed, 14 Jul 1999, Aaron Holtz wrote:
> Is it possible with postgres to do a select from tables contained in
> separate databases? I have two separate db's that are maintained, but
> would like to make a select from one of them to insert the data into the
> second one. Any thoughts on how to
Adriaan Joubert wrote:
> > Erik Colson wrote:
> >
> > I'm using Apache with mod_perl to access a PostgresSQL database (6.5)
> > .
> >
> > The script starts with connecting to the database... this means that
> > the server is actually reconnecting everytime the script starts and
> > disconnect whe
Is it possible with postgres to do a select from tables contained in
separate databases? I have two separate db's that are maintained, but
would like to make a select from one of them to insert the data into the
second one. Any thoughts on how to make this work would be appreciated.
Merging the
Hello,
Has anyone had any luck installing postgreSql on Caldera 2.2. I have
tried versions 6.5 and 6.4.2 with no luck. I am not sure what is
happening. I follow the instructions to the "T" and after doing the
install, there are no files anywhere. I am not sure what the problem is
as I don't seem
> Erik Colson wrote:
>
> I'm using Apache with mod_perl to access a PostgresSQL database (6.5)
> .
>
> The script starts with connecting to the database... this means that
> the server is actually reconnecting everytime the script starts and
> disconnect when the HTML page is generated.
>
> I'v
I'm using Apache with mod_perl to access a
PostgresSQL database (6.5) .
The script starts with connecting to the
database... this means that the server is actually reconnecting everytime the
script starts and disconnect when the HTML page is generated.
I've read about a possibility to ma
13 matches
Mail list logo
