Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and

> SELECT count(*) FROM users WHERE id NOT IN ( SELECT users_id FROM >users_demographics ); I'm not sure about the difference in speed, but try the following for a much faster query: SELECT count(id) FROM users EXCEPT SELECT users_id FROM users_demographics Should be a great deal faster

[ADMIN] Please help me write this query or function

Hi We have a table like follows: id, account_name, amount, action_type The amount field has both debit and credit entires and action_type defines the type of transaction ( debit or credit), debit entries have negative '-' symbol before the amount. where there are multipble transaction for the

[ADMIN] the results of pgbench are not stable (in tps)

hi, i try Excuting pgbench in order to get some performance results of postgreSQL . my system: Person Computer with PIII 600,RAM 256M,Maxtor 10G 7200rpm IDE OS RedHat 7.1 linux,PostgreSQL 7.1.3 However,even the same command (such as "./pgbench -t 10 -c 10") I Excute every time, the results ret

[ADMIN] Postgresql on win2000

Hello I am beginner and I want help to compile Postgresql to win2000 Can you help me ? Thank you fot your help ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

I'm not sure how to go about doing that Tom. If it doesn't inconveniece you too much, could you let me know how to go about it? Heather - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Heather Johnson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Harry Ford" <[EMAIL PROTEC

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

"Heather Johnson" <[EMAIL PROTECTED]> writes: > Sure, this is what I get: > 2001-12-11 09:40:24 DEBUG: StartTransactionCommand > 2001-12-11 09:40:24 DEBUG: query: select count(*) from users where id not = > in (select users_id from users_demographics) > /opt/postgres/bin/postmaster: reaping dea

[ADMIN] Strange thing : ldconfig and libpq.so.2.1

Hello, Well, I have a strange problem on linux (Red Hat 6.2). When I type this command line : /sbin/ldconfig -p | grep libpq I have this result : libpq.so.2 (libc6) => /usr/local/pgsql/lib/libpq.so.2 libpq.so (libc6) => /usr/local/pgsql/lib/libpq.so One night before on the same machine and at thi

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Thanks Brandon---that's a very good idea. I'd still like to know why my x86 box can handle the less effecient query better than an E-450, but this is what I'll do until I can get my curiosity satisfied. ;) Heather - Original Message - From: "bpalmer" <[EMAIL PROTECTED]> To: "Heather John

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Thanks! That's also a good idea. Heather - Original Message - From: "Peralta Miguel-MPERALT1" <[EMAIL PROTECTED]> To: "Heather Johnson" <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 5:43 PM Subject: RE: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7 > I woul

Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Hi Tom--   Sure, this is what I get:   2001-12-11 09:40:24 DEBUG:  StartTransactionCommand2001-12-11 09:40:24 DEBUG:  query: select count(*) from users where id not in (select users_id from users_demographics)/opt/postgres/bin/postmaster: reaping dead processes.../opt/postgres/bin/postmaster

[ADMIN] shared library

Hi , I am a new comer to this list.My problem is related to installing of postgres 7.1.3 to Slackware 8.0 Linux. 2.2.19 Kernel I had not any problems in my first time install but I tried to install postgres in to another machine having almost the same configuration. But new installation step fa