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
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
; - 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,
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,
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
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
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 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
