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
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
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
mallint |
d_npi | smallint |
status| integer|
u_id | integer |
delivery | boolean|
p_id | integer|
ip| inet |
u_mess_id | text |
ajdi | bigint
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
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
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
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
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
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
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
