Re: [HACKERS] Compression and on-disk sorting

2006-05-17 Thread Andrew Piskorski
ficult to use reliably in practice (in certain circumstances updates could fail, or if not fail perhaps have pathological performance), bugs which are supposed to be fixed in 10.2.0.2, which was only released within the last few months. -- Andrew Piskorski <[EMAIL PROTECTED]> http:

Re: [HACKERS] Compression and on-disk sorting

2006-05-16 Thread Andrew Piskorski
s possible. A corrolary of that is forget compression schemes like gzip - it reduces data size nicely but is far too slow on the cpu to be particularly useful in improving overall throughput rates. Note, I have not really tested ANY of the above myself, your mileage may well

Re: [HACKERS] ice-broker scan thread

2005-11-29 Thread Andrew Piskorski
mention that for RDBMS workloads, the default Linux 2.6 disk scheduler "anticipatory" is inferior to the "deadline" scheduler. They base their (simple sounding) Prioritized I/O support on the deadline scheduler. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Testing of MVCC

2005-08-16 Thread Andrew Piskorski
e Tcl Threads Extension, or Expect, or some other tool would best meet your needs. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Contrib -- PostgreSQL shared variables

2004-08-29 Thread Andrew Piskorski
riment with using SQLite for that), but that's not what you're talking about, right? The shared variables you're talking about here are just simple scalar values, no tables, no integrity constraints, no MVCC, none of that, right? -- Andrew Piskorski <[EMAIL PROTECTED]> http://

[HACKERS] SAN, clustering, MPI, Backplane Re: Postgresql on SAN

2004-07-08 Thread Andrew Piskorski
ALL RDBMSs? What about systems like Backplane, which claims to be "the only open-source, transactional, truly distributed database."? http://www.backplane.com/ -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ ---(end of broadcast)--

[HACKERS] OpenORB Re: 2-phase commit

2003-10-11 Thread Andrew Piskorski
d a high reliable > recovery system. > Here is a sourceforge version of the same thing > http://openorb.sourceforge.net/ -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] native bi-temporal support?

2003-06-09 Thread Andrew Piskorski
zona.edu/people/rts/timecenter/timecenter.html [4] http://raa.ruby-lang.org/list.rhtml?name=btpgsql [5] http://www.cs.arizona.edu/people/rts/tsql2.html [6] http://www.cs.arizona.edu/people/rts/sql3.html FYI, I also asked this question in another forum, here: http://openacs.org/forums/message-view