Hello
Does anybody know if there're any companies offering PostgreSQL 'hosting' ?
By 'hosting', I mean you get access to a database to which your
application connects remotely and do sql stuff.
'Hosting' company takes care of database maintenance,backup,etc.
ables' and
make backup or restore them. Backup is from lowest to biggest ID in that
table,while restore is from biggest to lower.
pg_dump/pg_restore does not have any intelligence over foreign-key
dependencies between tables.
Sincerely
Dragan Zubac
--
Sent via pgsql-general mailing
Hello
I have some similar situation like Yours,we're using at the moment PG
8.2.0. At the moment we do manually vacuum (one or more times to
minimize 'dead' data/tuples),and if necessary we do 'full' vacuum. On
heavy-updated PG,one surely must think of this procedures because they
are conside
Hello
Got one table:
Column | Type | Modifiers
-+-+---
message | bytea |
insert data like for example:
insert into zub (message) values (E'\004\065 Ciao');
is it possible to somehow get the
Hello
http://www.postgresql.at/english/pr_cybercluster_e.html
didn't test it myself though
Sincerely
Dragan
Rob Collins wrote:
Hello Dimitri
To clarify the requirement: much like you, we're not looking for
synchronous replication, which would be too slow. The branches and
central server c
.' wait for transactions to end. If
possible kill all processes that access that table and try 'vacuum full
verbose analyze table'. Anyway,if processor is mostly idle,always check
'select count (*) from pg_locks' , at least in my experience.
Sincerely
Dragan Zubac
Tom
Ross Boylan wrote:
I'm not a DB admin; I only play one on my computer. I clearly need to
figure out how to get regular vacuum, analyze, and reindexing going (if
they aren't going already).
Thanks for all your help.
Ross
1. optimize your sql queries and 'understand' index usage,don't inde
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
Have the same problem but in ordinary usage,no replication or
whatsoever. Problem is when client connects to the DB,stored procedure
in its initialization check mapping between some_table_name and
corresponding OID. Once something is changed in DB,for example OID's
deleted and recreate
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
14 matches
Mail list logo
