hen in
first case.
Hope You got my point,maybe somebody already had the same/similar
situation ?
Sincerely
Dragan Zubac
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello
I have a stored procedure which does the billing stuff
in our system,it works ok,but if I put in
production,where there is some 5-10 billing events per
second,the whole database slows down. It won't even
drop some test table,reindex,vacuum,things which were
done before in the blink of an eye
from hard disk ?
I'm looking for some solution where this procedure can
operate at higher loads and to leave other parts of
database operational as much as it could.
Sincerely
Pera
--- Usama Dar <[EMAIL PROTECTED]> wrote:
> On Dec 2, 2007 7:40 AM, Dragan Zubac
> <[EMAIL PROTE
mallint |
d_npi | smallint |
status| integer|
u_id | integer |
delivery | boolean|
p_id | integer|
ip| inet |
u_mess_id | text |
ajdi | bigint
e locks so
heavily ?
Sincerely
--- Dragan Zubac <[EMAIL PROTECTED]> wrote:
> Hello
>
> I have a stored procedure which does the billing
> stuff
> in our system,it works ok,but if I put in
> production,where there is some 5-10 billing events
> per
> second,the whole d
Hello
Anybody got any ideas/experiences/links for 'longest prefix match'
solution in PostgreSQL ?
Basically,put some telephone prefices in some kind of trie,and be able
to perform fast lookups ?
Sincerely
Dragan Zubac
---(end of
Hello
Not so familiar with all this math :) ,but here's my solution,which I
must admit keep things going at the moment:
db=> \d prefix
Table "public.prefix"
Column | Type | Modifiers
--+-+--
Hello
Is it possible to use transactions with 'per sub table' locks? What I
mean,if I partition a table and use transaction on that table with
constraint,will the database lock the master table (and all
subtables),or only sub table where the data is ?
Sincerely
Dragan Zubac
Hello
What are the possibilities (if any) for continuous dataflow streaming
with PostgreSQL v.8.1 ? Something like TelegraphCQ project,but it was
for v.7.3.Is there any alternatives for the latest version of
PostgreSQL ?
Sincerely
--
Dragan Zubac
Hello
We're looking for HA PostgreSQL solution,so have a couple of questions:
1. Is it possible for multiply PostgreSQL instances (engines,cores) to
use same DATA space? For example,to have two PostgreSQL processes which
will use same data directory,same files,and same data ? So,if You
update som
Hello
Does anybody knows the Postgres v8.0.3 data directory hierarchy ? What is
the purpose of the multiply files such as:
5
5.1
5.2
5.3
each of the same size ?
Sincerely
Dragan Zubac
---(end of broadcast)---
TIP 1: if posting
11 matches
Mail list logo
