7. How many concurrent readers of your database, and what's the average
transfer rate, suppose all readers are doing one table scaning.
Concurrent but idle connections in production are around 600. Active
connections at a time are in the dozens. I can read at about 60 to 70
Megs a second
On Sun, 17 Aug 2008, Amber wrote:
what I am wondering is how multiple agent process share page caches.
The database allocates a block of shared memory (sized by the
shared_buffers parameter) that all the client processes share for caching
pages.
--
* Greg Smith [EMAIL PROTECTED]
I'm not sure if I've violated some rule or the installation is just not
working the way I'm thinking it should work.
This is a Windows XP Professional Service Pack 2 install. Yes, I know
it sucks but until I get my app rewritten in Qt it will have to do and
even after that point I will still
Wow, very good to know. That was driving me crazy.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I am trying to delete a set of related record across the whole
database, In tests I
have managed to delete records from 2 tables using the code below.
DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one =
2;
but I need to be able to delete from up to 5 different tables, is
Stefan Berglund wrote on 16.08.2008 08:30:
[...]
First I install 8.3.1 using this command line:
[...]
Next I do (after a reboot because the service name, service user, super
user, and super password are not known until after the reboot) an
install of version 8.3.3 using the following
On Wed, 13 Aug 2008 16:32:18 -0500
ries van Twisk [EMAIL PROTECTED] wrote:
On Aug 13, 2008, at 4:25 PM, Ivan Sergio Borgonovo wrote:
I need to write an import function with enough isolation from
apache daemon.
Code has no input other than cvs files and a signal about when to
start the
You may use something like this in a stored function:
DECLARE
a INTEGER[];
BEGIN
a := '{2341548, 2325251, 2333130, 2015421,2073536, 2252374, 2273219,
2350850, 2367318, 2032977, 2032849}';
select * from users where id = any(a) order by idx(a, id);
END;
Or in the plain SQL:
select
Hi,everybody!
I wish to have a function with code above, but compiller generate
syntactic error at the line SET SESSION ROLE wishedrole;.
How to pass the wishedrole value to the structure?
CREATE OR REPLACE FUNCTION f_switch_role(INOUT text,INOUT boolean) AS
$BODY$
DECLARE
wishedrole ALIAS
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold either a
Just a suggestion:
EXECUTE 'SET SESSION ROLE wishedrole';
won't help?
2008/8/17 Oleg Vasylenko [EMAIL PROTECTED]
Hi,everybody!
I wish to have a function with code above, but compiller generate
syntactic error at the line SET SESSION ROLE wishedrole;.
How to pass the wishedrole value to
Mark wrote:
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold
Thanks. You suggestion helped me to find a solution!
DECLARE
...
query text;
BEGIN
query := query :='SET SESSION ROLE ' || wishedrole;
EXECUTE query;
..
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hello.
Is there any open source and well-tested PHP libraries to parse and build
the following PostgreSQL data types?
- arrays (including N-dimensional): {a,b,c}
- hstore: a=b, c=d
- ROW: (a,b,(c,d))
E.g. I have some PHP variable and want to build corresponding PostgreSQL
value.
Or, I have
On 15/08/2008 11:08, Fuzzygoth wrote:
but I need to be able to delete from up to 5 different tables, is
there a quick and
simple way of doing this? can someone post an example?
Just guessing without more detailed information, but are the tables
related one-to-many using foreign keys? If so,
15 matches
Mail list logo