PFC wrote:
PFC wrote:
Hello,
So, I embarked (yesterday) on a weekend project to add a new
feature to Postgres...
I use PHP with persistent connections and always have been
bothered that those very small AJAX queries (usually simple selects
returning 1 row) take more CPU in
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Mayer
Sent: Wednesday, 19 December 2007 19:26
To: Mark Mielke; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Sorting Improvements for 8.4
Or do you mean being able to perform parts of the query
given (NULL or a value) than fail?
I would really suggest using a single one: If the user has no access and
tries to specify it should fail. Otherwise take the current behaviour of
the system.
Just my EUR 0,02...
Good luck with the project.
- Joris Dobbelsteen
---(end
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg
Sabino Mullane
Sent: woensdag 28 maart 2007 2:50
To: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Guarenteeing complex referencial
integrity through custom triggers
[snip]
Much too elaborate
-Original Message-
From: Hannu Krosing [mailto:[EMAIL PROTECTED]
Sent: dinsdag 27 maart 2007 15:45
To: Joris Dobbelsteen
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] Guarenteeing complex referencial
integrity throughcustom triggers
Ühel kenal päeval, E, 2007-03-26 kell 16:05
, should give a failure.
* Doing parallel tests?
I think about hacking it in... Any opinions?
- Joris Dobbelsteen
---(end of broadcast)---
TIP 6: explain analyze is your friend
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: maandag 26 maart 2007 19:52
To: Joris Dobbelsteen
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Guarenteeing complex referencial
integrity through custom triggers
Joris Dobbelsteen [EMAIL PROTECTED] writes:
My
[66.207.139.130]
said: 5505.0.0 Go away, spammer (in reply to MAIL FROM command)
[//]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: maandag 26 maart 2007 19:52
To: Joris Dobbelsteen
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Guarenteeing complex referencial
table.
- Joris Dobbelsteen
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
for the
'single underlaying model' (with everything visible) and for your view
(under your visibility rules). I believe, but are not certain, that
under these conditions any (valid) snapshot will obey the desired
constraints.
- Joris Dobbelsteen
---(end of broadcast
, the vacuuming should pay back.
A nice metric might be: cost_of_not_vacuuming / cost_of_vacuuming.
Obviously, the higher the better.
- Joris Dobbelsteen
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
11 matches
Mail list logo