[GENERAL] lo or bytea streaming engine??
helloany future for lo or bytea streaming engine with security like http://pbxt.blogspot.com/2007/06/geting-blob-out-of-database-with-blob.html many thank youssincerelysiva
Re: [GENERAL] lo or bytea streaming engine??
bytea streaming engine is easy?? kindlt explain how?? how http://localhost:8080/database/table/bytea_column/id_column=value get data without select?? sincerely siva Original Message Subject: Re: [GENERAL] lo or bytea streaming engine?? From: Martijn van Oosterhout <[EMAIL PROTECTED]> Date: Tue, June 05, 2007 11:29 am To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org On Tue, Jun 05, 2007 at 08:12:26AM -0700, [EMAIL PROTECTED] wrote: > > hello > any future for lo or bytea streaming engine with security > like [1]http://pbxt.blogspot.com/2007/06/geting-blob-out-of-database-w > ith-blob.html If that page is all there is on it it seems to me to be (a) a terrible idea (b) trivial to implement. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] an other provokative question??
Relational database pioneer says technology is obsolete http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9034619 kindlt explain how?? sincerely siva ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] an other provokative question??
howto check column than row??
create table horizontal (id integer, first varchar(8), last varchar(8));
insert into horizontal values ('1', 'Jack', 'Ja');
insert into horizontal values ('2', 'Jill', 'Ji');
insert into horizontal values ('3', 'Mary', 'Ma');
select * from horizontal where true;
++---+---+
| id | first | last |
++---+---+
| 1 | Jack | Ja |
| 2 | Jill | Ji |
| 3 | Mary | Ma |
++---+---+
(3 rows)
#
create table vertical (id varchar(8), one varchar(8));
insert into vertical values ('first', 'Jack');
insert into vertical values ('last', 'Ja');
alter table vertical add column two varchar(8);
update vertical set two = 'Jill' where id = 'first';
update vertical set two = 'Ji' where id = 'last';
alter table vertical add column three varchar(8);
update vertical set three = 'Mary' where id = 'first';
update vertical set three = 'Ma' where id = 'last';
select * from vertical where true;
+---+---+--+---+
| id | one | two | three |
+---+---+--+---+
| first | Jack | Jill | Mary |
| last | Ja | Ji | Ma |
+---+---+--+---+
(2 rows)
#
select * from horizontal where last like 'J%' order by last;
++---+---+
| id | first | last |
++---+---+
| 1 | Jack | Ja |
| 2 | Jill | Ji |
++---+---+
(2 rows)
howto get flip result from vertical??
sincerely
siva
Original Message
Subject: [GENERAL] an other provokative question??
From: [EMAIL PROTECTED]
Date: Thu, September 06, 2007 3:32 pm
To: pgsql-general@postgresql.org
Relational database pioneer says technology is obsolete
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9034619
kindlt explain how??
sincerely
siva
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
[GENERAL] query help
hello table is +---+---+--+---+ | id | one | two | three | +---+---+--+---+ | first | Jack | Jill | Mary | | last | Ja | Ji | Ma | +---+---+--+---+ result is ++---+---+ | id | one | two | ++---+---+ | first | Jack | Jill | | last | Ja | Ji | ++---+---+ query is?? sincerely siva ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] query help
hello i add more column not row for new user. i want all "last like 'J%'". http://www.nabble.com/an-other-provokative-question---tf4394285.html sincerely siva Original Message Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007 11:17 am To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > hello > > table is > +---+---+--+---+ > | id | one | two | three | > +---+---+--+---+ > | first | Jack | Jill | Mary | > | last | Ja | Ji | Ma | > +---+---+--+---+ > > result is > ++---+---+ > | id | one | two | > ++---+---+ > | first | Jack | Jill | > | last | Ja | Ji | > ++---+---+ > > query is?? Unless I am missing something crucial, this is SQL 101: select id, one, two from foo; Alexander. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] query help
many apologees. right link http://archives.postgresql.org/pgsql-general/2007-09/msg00607.php i flip row to column if ok. but howto query?? sincerely siva Original Message Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007 11:38 am To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > i add more column not row for new user. i want all "last like 'J%'". > http://www.nabble.com/an-other-provokative-question---tf4394285.html Sorry, but the only difference between your table example and your result example was the absence, in the results, of one of the columns. If you want to constrain by some attribute, then you have to tell us that. I recommend that you buy a book on SQL. Lastly, I don't see what this has to do with the "provokative question" thread. Alexander. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] query help
can u refer to row?? howto select * from table where row(#2) like 'J%'?? i wanted to test column storing but not ok as no row refer name/id. many thank yous sincerely siva Original Message Subject: Re: [GENERAL] query help From: [EMAIL PROTECTED] Date: Thu, September 13, 2007 11:46 am To: Alexander Staubo <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org many apologees. right link http://archives.postgresql.org/pgsql-general/2007-09/msg00607.php i flip row to column if ok. but howto query?? sincerely siva Original Message Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007 11:38 am To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > i add more column not row for new user. i want all "last like 'J%'". > http://www.nabble.com/an-other-provokative-question---tf4394285.html Sorry, but the only difference between your table example and your result example was the absence, in the results, of one of the columns. If you want to constrain by some attribute, then you have to tell us that. I recommend that you buy a book on SQL. Lastly, I don't see what this has to do with the "provokative question" thread. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] any way to query for current connections to db?
select * from pg_stat_activity where datname = ( select * from current_database() ); Original Message Subject: [GENERAL] any way to query for current connections to db? From: "Coarr, Matt" <[EMAIL PROTECTED]> Date: Fri, November 09, 2007 5:36 pm To: Hi, Is there any way to query the database to identify what the current connections are (connections, sessions, or whatever you want to call them)? This would be something similar to oracle's v$session view. Thanks, Matt ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Scalability
Top at 350-400 concurrent connections! Although more than my project's peak estimates, it is a bit discomforting. Are there any *promising* load testing numbers with Windows 2003? I'd be happy to share results from my simulations. Matt > Original Message > Subject: Re: [GENERAL] Scalability > From: "Joshua D. Drake" <[EMAIL PROTECTED]> > Date: Sat, October 28, 2006 8:38 pm > To: Bill <[EMAIL PROTECTED]> > Cc: pgsql-general@postgresql.org > > Bill wrote: > > I am new to PostgreSQL and just beginning to learn the product. I will > > probrobably be using it exclusively on Windows. > > > > I was surprised to learn that PostgreSQL creates a new process for each > > connection. Doesn't this severely limit its scalability by consuming > > resources rapidly on the server as the number of user increases? > > The Windows version is not anywhere near as scalable as the unix > versions. Depending on your hardware you will top out a Windows > installation about about 350-400 connections. You can get more out of > Windows by modifying the registry but I am unsure of how far it will go. > > I have Linux installations that happily hum along with 2000-5000 > connections. > > So in answer to your question, in general -- no the process methodology > we use does not limit scalability and it makes our code base much > simpler that the equivalent threading model. > > Sincerely, > > Joshua D. Drake ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] apt-get install postgresql.deb??
hello how to get postgresql 8* debian package?? nto at http://www.debian.org/distrib/packages http://www.postgresql.org/ftp/binary/v8.2.1/linux/?? many thank yous sincerely siva ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
