Jorge Medina wrote:
> hi guys
>
> I know this list it's about SQL, but if somebody have a pgsql engine
> with 1000 or more concurrent connections please show me the
> postgresql.conf or if the pgpool work as a solution to this problem.
Out of interest - why 1000 connections?
Do you really expect
On Tue, Aug 5, 2008 at 12:11 PM, Jorge Medina <[EMAIL PROTECTED]> wrote:
> ok, so I think if can not increment the max_connections to 1000
> because my main memory it's 2G some test with max connections allowed
> ?
Sorry I don't understand your question. Also, don't forget to
reply-all so that
I would like to get effect of selecting table record when construct a
composite type.
CREATE TYPE "chains"."foo" AS (
id INTEGER,
bar INTEGER
);
CREATE OR REPLACE FUNCTION construct_foo(INTEGER,INTEGER) RETURNS
chains.foo AS $$
DECLARE
f chains.foo;
BEGIN
f.id := $1;
f.bar := $2;
RETURN f;
Hi all,
I am trying to perform a full text search for the word 'ksan (which starts with
a quote). After much frustration and syntax errors I stumbled upon the
following statement which seems to work:
select *
from items
where to_tsvector(name) @@ to_tsquery(E'[\']ksan')
I would like to know if
On Fri, Aug 1, 2008 at 3:16 AM, Anoop G <[EMAIL PROTECTED]> wrote:
> We can change the owner of a tbale like this
> alter table tbl_year_end owner to anoop;
> Is it possible to change the owner name of a view through sql?
Here is what the "notes:" section of
http://www.postgresql.org/docs/8.3/i
On Tue, Aug 5, 2008 at 8:14 AM, Jorge Medina <[EMAIL PROTECTED]> wrote:
> I know this list it's about SQL, but if somebody have a pgsql engine
> with 1000 or more concurrent connections please show me the
> postgresql.conf or if the pgpool work as a solution to this problem.
The PG performance li
hi guys
I know this list it's about SQL, but if somebody have a pgsql engine
with 1000 or more concurrent connections please show me the
postgresql.conf or if the pgpool work as a solution to this problem.
thanks.
--
Jorge Andrés Medina Oliva.
Evolve or die!
--
Sent via pgsql-sql mailing list
