Hi,
i have 2 Functions, one ist called by page visitors (something about 2,000 times / 1 hour)
and the other just by the admin (let say 1 time per hour or per login)
i often get a deadlock error after calling the admin function
yes they try to access the same table somewhere in the function code.
Hi there,
i m new in this board. I read a little here to find a solution for my problem. But i couldn´t find something.
My Problem ist:
I m programming a counter in PHP with Postgres as DB. I had 6,000 visitors across all day, so everything worked fine first.
Yesterday i got 80K Users at my
Hi
I have a php script and i make a pg_pconnect
If i want to make 4-10 pg_query in that script
Have i to close the connection at end of the script?
(i would say yes, is it right?)
Sorry I m a little bit confused about the persistent thing!!
Is it smart to use persistent connections at all if i ex
Hi,
what is the most performant way to select for example the first 99 rows of a table and insert them into another table...
at the moment i do this:
for userrecord in select * from table where account_id = a_account_id and counter_id = userrecord.counter_id and visitortable_id between a_minid a
Hi,
nobody has an idea? :-(
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED]
Gesendet: Freitag, 27. Februar 2004 17:53
An: [EMAIL PROTECTED]
Betreff: [PERFORM] Select-Insert-Query
Hi,
what is the most performant way to select f
l integer,
speed real,
audit real,
date timestamp with time zone,
gold_result_id integer,
CONSTRAINT result_pkey PRIMARY KEY (res_id),
CONSTRAINT unique_res UNIQUE (res_client_id, res_tc_id)
)
WITHOUT OIDS;
ALTER TABLE res OWNER TO postgres;
CREATE INDEX index_audit
ON res
USING btree
; - Don't bypass the filesystem, but feel free to tinker with mount
> options if you think it will help
Right, raw partitions are too low-level for me these days anyhow...
I assume that all postgres partitions can be mounted with noatime?
> - If you can put WAL on separate disk(s)
Hi all!
Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0?
Are there any scenarios where 8.0 can be expected to be faster? I
would love to get my hands on any numbers that someone might have.
Also does anyone know how long it will take for a stable release of
8.0 to come? Given
