: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Mike Benoit [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
I'm not a developer, but I know this item on the todo list has been a
magor pain in my side for quite a while:
# Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS
[http://momjian.postgresql.org/cgi-bin/pgtodo?exists]
Any time I've attempted to use this feature, the query cost is in
Some of you may be interested in this seemingly exhaustive benchmark
between ext2/3, ReiserFS, JFS, and XFS.
http://www.osdl.org/presentations/lwe-jgfs.pdf
---(end of broadcast)---
TIP 6: Have you searched our list archives?
nice.
--
Best Regards,
Mike Benoit
NetNation Communication Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
---
Disclaimer: Opinions expressed here are my own and not
necessarily those of my employer
---(end
YourEmailAddressHere to [EMAIL PROTECTED])
--
Best Regards,
Mike Benoit
NetNation Communication Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
--
Disclaimer: Opinions expressed here are my own and not
necessarily those of my employer
---(end of broadcast
On Fri, 2002-11-29 at 13:22, Tom Lane wrote:
Mike Benoit [EMAIL PROTECTED] writes:
I'm just curious, will your proposed in/exists optimizations help for
queries like:
db=# explain delete from dns_expired_domains where domain_id in (select
domain_id from dns_expired_domains group
in size. Vacuum was run on database.
How did you calculate the size of database? If you used du make sure
you do it in the data/base directory as to not include the WAL files.
--
Best Regards,
Mike Benoit
NetNation Communication Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
of the cycle.
Trying to adhere rigidly to a date set nine or twelve months previously
doesn't strike me as good practice.
cheers
andrew
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Mike Benoit
/SUBABORT for
subtransactions, then using a simple ABORT would abort the whole
transaction tree.
But then we're back to the application having to know if its in a
regular transaction or a sub-transaction aren't we? To me that sounds
just as bad.
ABORT ALL sure would be nice.
--
Mike Benoit
often then necessary anyways? Assuming security exploits
are back ported of course.
--
Mike Benoit [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Mike Benoit [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
)---
TIP 6: explain analyze is your friend
--
Mike Benoit [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
)---
TIP 6: explain analyze is your friend
--
Mike Benoit [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
13 matches
Mail list logo