Re: [PERFORM] multicolumn index column order

2007-07-30 Thread Lew
valgog wrote: On Jul 25, 2:14 am, Lew <[EMAIL PROTECTED]> wrote: How about two indexes, one on each column? Then the indexes will cooperate when combined in a WHERE clause. <http://www.postgresql.org/docs/8.2/interactive/indexes-bitmap-scans.html> I don't believe the index

Re: [PERFORM] Using high speed swap to improve performance?

2010-04-06 Thread Lew
ich discusses that Oracle may move away from open-sourcing Solaris, but indicates that Oracle remains committed to Solaris as a for-pay product, and also assesses a rosy future for Java. -- Lew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to

Re: [PERFORM] Using high speed swap to improve performance?

2010-04-08 Thread Lew
Christiaan Willemsen wrote: About a year ago we setup a machine with sixteen 15k disk spindles on Solaris using ZFS. Now that Oracle has taken Sun, and is closing up Solaris, we want to move away (we are more familiar with Linux anyway). Lew wrote: What evidence do you have that Oracle is

Re: [PERFORM] Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...

2010-07-27 Thread Lew
r the catch. Strangely, the runtime is shown with a period for the separator, though. -- Lew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] adding foreign key constraint locks up table

2010-12-28 Thread Lew
he system has to lock the table to alter it. It also has to check that all records already in "bbb" satisfy the new constraint. What's the longest you've waited for ALTER TABLE to release its lock? -- Lew Ceci n'est pas une pipe. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] PostgreSQL

2010-12-31 Thread Lew
nextage Tech wrote: How good are c***c.com practice exams for PostgreSQL exam? My friends told me they are pretty good and he has passed many exams with their material. Let me know guys! "... friends ... he ..."? Is this an ad for c***c.com? What is your connection to them? -

Re: [PERFORM] Any experience using "shake" defragmenter?

2011-01-31 Thread Lew
ce with it. That seems a little harsh. You post to a discussion group but want to suppress discussion? Maybe that works with paid tech-support staff, but here ... -- Lew Ceci n'est pas une fenĂȘtre. .___. |###] | [###| |##/ | *\##| |#/ * | \#| |#|#| ||| *

Re: [PERFORM] Any experience using "shake" defragmenter?

2011-02-01 Thread Lew
Please reply to the list with list business. On 01/31/2011 03:22 PM, Mladen Gogala wrote: On 1/31/2011 7:28 AM, Lew wrote: That seems a little harsh. Oh? How so? You post to a discussion group but want to suppress discussion? No, I just want to stick to the subject. My motivation for doing

[PERFORM] [OT]: Confidentiality disclosures in list posts (Was: SORT performance - slow?)

2011-05-21 Thread Lew
t alone Usenet or mailing-list posts. -- Lew Honi soit qui mal y pense. http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Very long deletion time on a 200 GB database

2012-02-24 Thread Lew
as usually immediate, like it's Wednesday and it'll be faster by Thursday the next day, and we'll get more done by Friday of the same week the new way. But we don't have time. I have had this conversation dozens of times over the years. (I was always "Programmer".

Re: [PERFORM] Very long deletion time on a 200 GB database

2012-02-29 Thread Lew
s long as I'm not fired for it), than have them hate me and try not to pay me. I am just loud about what is correct and what the consequences of incorrect are; then when they get those consequences I make sure to draw the connection. I'm not there to make friends, I'm there to make solu