On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <[EMAIL PROTECTED]>
wrote:
On Nov 29, 2007 9:33 AM, Max Zorloff <[EMAIL PROTECTED]> wrote:
I don't think that works.
ponline=# select ('{1,2,3}'::text)::int[];
ERROR: cannot cast type text to integer[]
Ca
On Thu, 29 Nov 2007 19:21:03 +0400, Pavel Stehule
<[EMAIL PROTECTED]> wrote:
Hello
arrays in PostgreSQL have to be regular allways. And before 8.3 array
cannot contais NULL, so you cannot simpl resize two dim array :(. But
your functions doesn't work in 8.3. too. So you can
a) use 1D array a
On Thu, 29 Nov 2007 18:11:22 +0400, Rodrigo De León <[EMAIL PROTECTED]>
wrote:
On Nov 29, 2007 3:34 AM, Max Zorloff <[EMAIL PROTECTED]> wrote:
According to the docs it seems that only way would be to declare it as
something like :
myArray := ARRAY[[1,2], [3,4], [5,6]];
You
Hi, all.
I was wondering, can I really declare a 2-dimensional array of arbitrary
size in pl/pgsql?
According to the docs it seems that only way would be to declare it as
something like :
myArray := ARRAY[[1,2], [3,4], [5,6]];
But what if I pass the dimensions as function parameters?
My po
On Sat, 08 Sep 2007 19:28:52 +0400, Scott Marlowe
<[EMAIL PROTECTED]> wrote:
On 9/7/07, Max Zorloff <[EMAIL PROTECTED]> wrote:
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]>
wrote:
>> The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2)
On Fri, 07 Sep 2007 10:58:36 +0400, Marko Kreen <[EMAIL PROTECTED]> wrote:
The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just "hangs", and if I try to connect to it with psql it just hangs
indefinitely. After restart
it works fine a
Hello. I'm using Apache + PHP + Postgres for my project. I've tried the
two poolers people
usually recommend here - pgbouncer and pgpool.
I have a problem with pgbouncer - under the load the query execution
becomes ~10 times slower
than it should be - basically to test it, I connect with psql
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
shared_memory is used for caching. It is filled as stuff is used. If
you're not using all of it that means it isn't need
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<[EMAIL PROTECTED]> wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the syste
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the system. I've set num_init_children to 5 and
here is the top output.
One of postmasters is my demon running some insert/update tasks. I see
that they all use cpu heavily,
On Thu, 23 Aug 2007 21:29:46 +0400, Bill Moran <[EMAIL PROTECTED]>
wrote:
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
> Hello.
>
> I have a subject setup and a few questions.
On Thu, 23 Aug 2007 21:16:48 +0400, Joshua D. Drake <[EMAIL PROTECTED]>
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Max Zorloff wrote:
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database t
Hello.
I have a subject setup and a few questions.
The first one is this. PHP establishes a connection to the Postgres
database through pg_pconnect(). Then it
runs some query, then the script returns, leaving the persistent
connection hanging. But the trouble
is that in this case any query t
On Thu, 23 Aug 2007 12:24:32 +0400, Hannes Dorbath
<[EMAIL PROTECTED]> wrote:
On 23.08.2007 11:04, Max Zorloff wrote:
When one postgres process waits for lock to release does it use any cpu?
And also, when apache waits for query to finish, does it use cpu?
No, but are you sure what y
On Thu, 23 Aug 2007 08:29:03 +0400, Tom Lane <[EMAIL PROTECTED]> wrote:
"Max Zorloff" <[EMAIL PROTECTED]> writes:
... The problem is that after the number of concurrent users rises to
100, CPU becomes almost 100% loaded. How do I find out what's hogging
the
CPU?
Hello.
I have a web-server with php 5.2 connected to postgres 8.0 backend. Most
of the queries the users are doing are SELECTs (100-150 in a second for
100 concurrent users), with a 5-10 INSERTs/UPDATEs at the same time. There
is also a demon running in the background doing some work once e
16 matches
Mail list logo
